Building models with SAS Enterprise Miner, SAS Factory Miner, SAS Visual Data Mining and Machine Learning or just with programming

Extracting year, month, day from date

Accepted Solution Solved
Reply
Regular Contributor
Posts: 218
Accepted Solution

Extracting year, month, day from date

Hi All,

I have the following table with name and date. I want to extract year, month, day_of_week (eg: Monday, tuesday) and monthyear (eg: JAN2014),

NameStart_Date
A2015-06-17
B2015-06-03
C2015-06-12
D2015-07-30
E2015-07-15

I have the following code, can't figure out what would be the code for  day_of_week (eg: Monday, tuesday) and monthyear (eg: JAN2014). Can someone help please.

data out;

set have;

year = year(Start_Date);

month = month(Start_Date);

run;

Output will look like this:

NameStart DateYear MonthDay_of_Weekmonthyear
A2015-06-172015JunWednesdayJun2015
B2015-06-032015JunWednesdayJun2015
C2015-06-122015JunFridayJun2015
D2015-07-302015JulSundayJul2015
E2015-07-152015JulSaturdayJul2015


Thanks,


Accepted Solutions
Solution
‎08-11-2015 01:33 PM
Super Contributor
Posts: 275

Re: Extracting year, month, day from date

Day_of_Week=put(weekday(Start_Date)+1,downame7.);

monthyear=put(Start_Date,monyy7.);

View solution in original post


All Replies
Solution
‎08-11-2015 01:33 PM
Super Contributor
Posts: 275

Re: Extracting year, month, day from date

Day_of_Week=put(weekday(Start_Date)+1,downame7.);

monthyear=put(Start_Date,monyy7.);

Super User
Posts: 19,877

Re: Extracting year, month, day from date

Look at the date formats

downame - day of week

year  - year

monname3 - month name, either full or 3 chars

monyear - for Jul2015

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 412 views
  • 0 likes
  • 3 in conversation