topic Re: Date format Month and Year in SAS Data Management

Date format Month and Year

mlogan — Tue, 10 Nov 2015 16:21:58 GMT

Hi there,

I wanted to extract the Month and Year from the date and soft them by MonthYear.

After running the following code I see that MonthYear in sas dataset (want) is also $7. format. When I export the dataset to excel (os that I can do some manipulation in excel) I see that MonthYear is not in date format. Can someone please help.

data want;
set have;
MonthYear=put(Date,monyy7.);
run;

Re: Date format Month and Year

PaigeMiller — Tue, 10 Nov 2015 18:57:07 GMT

~~You haven't actually asked a question. It seems like your sample code would get you the month and year.~~

~~What is the problem?~~

Now that you have added a paragraph to the original message, I withdraw my questions.

Re: Date format Month and Year

mlogan — Tue, 10 Nov 2015 16:22:51 GMT

Here it is Miller

Re: Date format Month and Year

Reeza — Tue, 10 Nov 2015 17:03:43 GMT

PUT() converts the variable to a character format. Apply the format instead of converting it.

Format MonthYear monyy7.;

Re: Date format Month and Year

Astounding — Tue, 10 Nov 2015 17:41:36 GMT

Why not make life easy and just create two variables:

data want;

set have;

y = year(date);

m = month(date);

run;

They will pass to Excel easily, and can easily be sorted in any order you need.