01-31-2017 02:37 PM
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?
01-31-2017 04:05 PM
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.
Need further help from the community? Please ask a new question.