DATA Step, Macro, Functions and more

Dates

Reply
Regular Contributor
Posts: 199

Dates

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??
Super User
Posts: 13,941

Re: Dates

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.

 

 

Regular Contributor
Posts: 199

Re: Dates

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
Ask a Question
Discussion stats
  • 2 replies
  • 93 views
  • 0 likes
  • 2 in conversation