## Extracting year, month, day from date

Solved
Regular Contributor
Posts: 218

# 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),

 Name Start_Date A 2015-06-17 B 2015-06-03 C 2015-06-12 D 2015-07-30 E 2015-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:

 Name Start Date Year Month Day_of_Week monthyear A 2015-06-17 2015 Jun Wednesday Jun2015 B 2015-06-03 2015 Jun Wednesday Jun2015 C 2015-06-12 2015 Jun Friday Jun2015 D 2015-07-30 2015 Jul Sunday Jul2015 E 2015-07-15 2015 Jul Saturday Jul2015

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.);

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.