topic Re: Importing dates into SAS in SAS Programming

Importing dates into SAS

Jack1 — Tue, 31 Jan 2017 19:37:13 GMT

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

Re: Importing dates into SAS

Shmuel — Tue, 31 Jan 2017 19:44:20 GMT

the easyest way:

date = input(put(date_in,z6.)||'01' , yymmdd8.);

format date yymmddn6.;

Re: Importing dates into SAS

ballardw — Tue, 31 Jan 2017 21:05:41 GMT

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.

Re: Importing dates into SAS

Jack1 — Wed, 01 Feb 2017 20:29:51 GMT

Works! Thanks. Jack