Hi,
I have a character variable for date, which shows like '23-JUN-12'. I was trying to convert this char variable into numeric, but could not do that. It seems that SAS does not have format for the date format like '23-JUN-12'. Could you let me know how to do? Thanks so much!
Remove the dashes and use date9? You can use compress function to remove the -
Remove the dashes and use date9? You can use compress function to remove the -
it works! thanks so much!
DATE11 works.
data xx;
input x date11.;
format x date9.;
put x=;
cards;
23-jun-12
23jun12
23jun2012
;;;;
ANYDTDTE11 works.
data xx;
input x anydtdte11.;
format x date9.;
put x=;
cards;
23-jun-12
23jun12
23jun2012
;;;;
Notes (2)
53
54
55
56 data xx;
57 input x anydtdte11.;
58 format x date9.;
59 put x=;
60 cards;
x=23JUN2012
x=23JUN2012
x=23JUN2012
NOTE: DATA statement used (Total process time):
real time 0.84 seconds
64 ;;;;
NOTE: The data set WORK.XX has 3 observations and 1 variables.
cpu time 0.58 seconds
65
66 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
76
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: