topic Re: SAS 9.4 Reformat dates after CSV import in SAS Procedures

SAS 9.4 Reformat dates after CSV import

Jolly — Wed, 06 Apr 2016 13:08:48 GMT

Hello,

I am importing a csv file from excel and the dates that is pulled from the file contains time as well. SAS is reading the dates correctly, however I want to change the DATETIME16. to MMYYDD10. Any guidance on how to do this would be greatly appreciated.

Thank you,
Jeff S. O.

Re: SAS 9.4 Reformat dates after CSV import

Kurt_Bremser — Wed, 06 Apr 2016 13:19:35 GMT

newdate = datepart(date);
format newdate mmddyy10.;

(there is no mmyydd format)

If you want to preserve the original variable name, add

drop date;
rename newdate=date;

in the data step.

Re: SAS 9.4 Reformat dates after CSV import

ballardw — Wed, 06 Apr 2016 15:00:52 GMT

If you use a datastep program to read CSV (highly recommended) instead of proc import then you specify the informat and format in the datastep.

If you are going to be repeatedly importing similar format files you are almost gauranteed to get some inconsistency over time from changing lengths of character variables, change from numeric to character, from date to character or similar. Getting one datastep and modifying input file and output dataset will save you lots of headaches down the road.

Re: SAS 9.4 Reformat dates after CSV import

Jolly — Wed, 06 Apr 2016 15:09:31 GMT

Hello Ballardw,

Would you mind giving a brief example? I have always used the import statement, but if I can decide the format before the dataset is created, that sounds way better than what I have been doing.

Thank you,
Jeff S O

Re: SAS 9.4 Reformat dates after CSV import

ballardw — Wed, 06 Apr 2016 17:46:56 GMT

If you have been using Proc Import you should get code SAS generates to read a csv file in the log.

You can copy that and paste into the editor to see a basic example. Look at statements like INFORMAT. Those tell SAS how to read specific variables. When they are character the $nn sets the length of the text variables to nn characters.

Re: SAS 9.4 Reformat dates after CSV import

Jolly — Wed, 06 Apr 2016 18:58:28 GMT

Thank you very much for that Ballardw!

Jeff S O