creating new date variable from separate month and year

BenRB — Fri, 13 May 2011 17:29:18 GMT

I am merging two datasets - one dataset has the date recorded as separate month and year variables. I want to convert these into a single variable for the date in the format mm.yyyy, to match the date variable in the second dataset.
Is this possible? Any advice is appreciated

Re: creating new date variable from separate month and year

SPR — Fri, 13 May 2011 17:36:24 GMT

Hello BenRB,

You could use the following code:
[pre]
data i;
month=5;
year=2011;
date=MDY(month,01,year);
format date mmyyp8.;
run;
[/pre]
Sincerely,
SPR

topic Re: creating new date variable from separate month and year in SAS Procedures

creating new date variable from separate month and year

Re: creating new date variable from separate month and year