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.
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
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.
Ready to level-up your skills? Choose your own adventure.