topic Re: Dates in SAS Programming

Dates

Ronein — Fri, 01 Sep 2017 19:20:07 GMT

Hello
I import excel data into sas.
In excel there are some dates columns with numeric format.
When i import it into sas i define format ddmmyy10.
And get error dates that were not conerted correctly.
When i change format of dates in excel to mmddyy then all is fine in sas import.
The problem is that my client doesn't want to convert excel format into mmddyy and want to leave it with numeric format.
My question-How can I import into sas excel date fields with numeric format in excel??

Re: Dates

ballardw — Fri, 01 Sep 2017 19:45:58 GMT

Please describe what you mean by "dates columns with numeric format". You probably should describe how you import the Excel data into SAS as well.

Your client doesn't need to know what you do as long as the results match the requirements.

Re: Dates

Ronein — Fri, 01 Sep 2017 20:31:35 GMT

The orignal data in dates columns in excel is with numeric format. For example 9876 .when i report it from excel into sas i wamt to get numeric value with ddmmyy10. Format