convert excel date to excel general format in SAS

jcurran1289 — Tue, 26 Jul 2016 19:01:20 GMT

Hi,

I have data that is suppose to be a date in the format mmddyy in excel. I am able to get majority of it into sas and convert it properly apart from some. The observations i am have a problem with are the ones that the user just entered the year, leaving out the day and month. These convert to 0 . is there any way to get sas to convert these observations to the equivalent of general formate in excel? Thave attached a sceenshot of the data

Thanks

Re: convert excel date to excel general format in SAS

PGStats — Tue, 26 Jul 2016 21:42:49 GMT

The answer is no. In Excel, each value (cell) can have its own format. In SAS, formats are associated with variables, not individual values. A variable can be formatted as YEAR4. or MMDDYY10. , but not both. If you want to mix formats. convert your data to character.

topic convert excel date to excel general format in SAS in SAS Programming

convert excel date to excel general format in SAS

Re: convert excel date to excel general format in SAS