topic Re: Informat for JAN-01-2008 date? in SAS Programming

Informat for JAN-01-2008 date?

wernie — Thu, 13 Jun 2019 17:13:17 GMT

I can't seem to figure this out for some reason. I'm trying to import a .CSV file into SAS. It's a very large file (~20 million + records), so I can't easily change something in Excel, etc. The date appears in the format of MON-DD-YYYY, so an example is Jan-01-2008. How do I use an informat to make sure this gets into SAS properly?

I used Proc Import and then tried editing the code in the log to change the informat and nothing I'm doing gets the proper format. The closest I've gotten is just something like JAN2008, but no day. Thanks!

Re: Informat for JAN-01-2008 date?

PeterClemmensen — Thu, 13 Jun 2019 17:17:26 GMT

The anydtdte informat can handle it

data test;
   date='Jan-01-2008';
   newdate=input(date, anydtdte12.);
   format newdate date9.;
run;

Re: Informat for JAN-01-2008 date?

wernie — Thu, 13 Jun 2019 17:22:22 GMT

Thank you! I thought I had tried that, but I guess not. That worked.