I have dates comming in as char 02-mar-49, how do i read this date in and output it to yymmddn8.
Thank you
Use DATE9. as the INFORMAT and YYMMDDN8. as the format.
So if you are reading from a text file:
data want ;
infile 'myfile' ;
input mydate date9.;
format mydate yymmddn8.;
run;
If you already have the value in a character variable then you can use INPUT function to convert it to an actual date.
mydate=input(mystr,date9.);
If you want to write it back to another character variable then use the PUT function.
mystr2 = put(mydate,yymmddn8.);
Use DATE9. as the INFORMAT and YYMMDDN8. as the format.
So if you are reading from a text file:
data want ;
infile 'myfile' ;
input mydate date9.;
format mydate yymmddn8.;
run;
If you already have the value in a character variable then you can use INPUT function to convert it to an actual date.
mydate=input(mystr,date9.);
If you want to write it back to another character variable then use the PUT function.
mystr2 = put(mydate,yymmddn8.);
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.