Quick question that I have spent a lot of time trying to figure out with no luck.
I have dates in the form 201601, 201602, etc. that I want to convert from numeric to a SAS date while keeping this format (yyyymm). How do you convert this in SAS?
Thanks
Jack
the easyest way:
date = input(put(date_in,z6.)||'01' , yymmdd8.);
format date yymmddn6.;
the easyest way:
date = input(put(date_in,z6.)||'01' , yymmdd8.);
format date yymmddn6.;
Works! Thanks. Jack
Are you reading an external file or are converting data already in SAS?
If reading an external file with a data step you can use the informat yymmn6. and display format yymmn6. ;
Note that this and @Shmuel's suggestion will both have an implicit value including the first day of the month.
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.