If you have a sense of humor about dating/relationships, check out the new FREEWARE video game: Dating 101: The Video Game. It is a single downloadable file with NO installation required. it is being given away for free by www.MarriageMindedMatchmaking.com as a marketing tactic. Here is the direct link to download the game from: http://www.marriagemindedmatchmaking.com/marriagemindedmatchmaking/DATING101
Hi DP, data sample; input PT DAY YEAR MONTH; cards; 101 8 4 6 101 24 4 6 101 13 4 8 101 7 4 9 ; run; data result; set sample; date = mdy(month,day,year); format date date9.; run; Hope this is helpful. Mark Terjeson Senior Programmer Analyst Investment Management & Research Russell Investments Russell Investments Global Leaders in Multi-Manager
Show your code. Be more specific than "did not work". Include exact text of any diagnostics. If you convert the character value in month to a numeric variable, MDY should work fine. You could add a few debugging put statements to make sure variables contain the values you think they do. -----Original Message----- From: DP [mailto:snip] Sent: Tuesday, August 26, 2008 3:27 PM To: SAS-L@LISTSERV
if I have a bunch of dates in a datetime colum. How do I check for dates that are the same for today. For example this days value would be '#dateFormat(Now(),"mm dd yyyy")#' The best I could come up with was: select * from staff_charts_data where staff_charts_data.userID = 263 AND convert(varchar, dateAdded , 101) = '#dateFormat(Now(),"mm dd yyyy")#' How can I
