Help using Base SAS procedures

Imported Excel Date being read by SAS as 0?

Reply
Occasional Contributor
Posts: 6

Imported Excel Date being read by SAS as 0?

Hello,

I imported an excel workbook that contains dates. SAS imported them using the format date9. However, when I go to use the datepart function, I get 0 for every observation.

Any help in getting SAS to read the dates correctly? I need to extract the year and month of each entry.

Thanks,

Super User
Posts: 17,907

Re: Imported Excel Date being read by SAS as 0?

datepart() -> converts DATETIME variables to date variables

year()-> extracts year from date variable

month()-> extracts month from date variable

YYMMN6. format will change the format from date9. (01Jan2012) to 201206.

format your_date yymmn6.;

Ask a Question
Discussion stats
  • 1 reply
  • 142 views
  • 0 likes
  • 2 in conversation