Date function with only month and year?

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 6
Accepted Solution

Date function with only month and year?


Hi I'm trying to create a new variable using a month and year variable. I believe I should use the format Monyy7. but I am not sure what function to use. Typically I would use MDY ( Month, Day, Year).... but I do not have the day so I am a bit stumpped especially since MY (Month, year) does not work. See the example below....

data female;                                                                       data female;

date = MDY (Month, day, year);    -------->                          ????date = MY (month, year)?????

format Date monyy7.;                                                          format Date monyy7.;

run;                                                                                    run;

Please help!!!


Accepted Solutions
Solution
‎12-28-2012 12:14 PM
Respected Advisor
Posts: 3,124

Re: Date function with only month and year?

In case of this, you will have to artificially plug in a day number: data=mdy(month,1,year).

Haikuo

Update: more clarification: if you let SAS to choose base on your limited information, SAS will pick the first day of the month:

data _null_;

month=7; year=2012;

date1=input(catx('-',month,year),ANYDTDTE.);

date2=mdy(month,1,year);

put "date1=" date1 date9. "  date2=" date2 date9.;

run;

View solution in original post


All Replies
Solution
‎12-28-2012 12:14 PM
Respected Advisor
Posts: 3,124

Re: Date function with only month and year?

In case of this, you will have to artificially plug in a day number: data=mdy(month,1,year).

Haikuo

Update: more clarification: if you let SAS to choose base on your limited information, SAS will pick the first day of the month:

data _null_;

month=7; year=2012;

date1=input(catx('-',month,year),ANYDTDTE.);

date2=mdy(month,1,year);

put "date1=" date1 date9. "  date2=" date2 date9.;

run;

Occasional Contributor
Posts: 10

Re: Date function with only month and year?

this is the exact problem i am having now except I want sas to choose the end of the month. Im working with gdp time series data that is the total for the month at the end of the month. I plan to put them into proc expand to get them to daily and calculate a moving average so if sas assumes the 1st day that will mess me up. why cant they do date=my(month,year) ? i tried exactly what the original poster tried bc that would have been so logical :-/

Occasional Contributor
Posts: 10

Re: Date function with only month and year?

nevermind. your original solution looks like it works for me instead of data9. format i used yymmn6.

Occasional Contributor
Posts: 10

Re: Date function with only month and year?

What day?
Just use 1
Every month has 1
Pun intended
Occasional Contributor
Posts: 10

Re: Date function with only month and year?

I got it to give me the dates in YYYYMM using the original solution that was there. But Im using a gdp data series where the observations represent the total at the end of the month. Im trying to convert from end of month monthly observations to daily in proc expand now that I have them in the right format
☑ This topic is SOLVED.

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

Discussion stats
  • 5 replies
  • 9196 views
  • 0 likes
  • 4 in conversation