Hi,
I imported a Stata dataset to SAS. Everything looks correct except for the month variable. I have a month date variable in Stata dataset. It looks like this way, 1991m1, 1991m2, 1991m3,.... When I imported this variable into SAS, It changes to 372, 373, 374.... I wonder how I can correctly convert this variable into a date variable such as 1JAN1991, 1FEB1991,.....
Thanks
It looks like its counting months from January 1, 1960.
The example below shows how to convert it to a SAS date called test and then display as month or date (variable=test2).
data have;
input num_months;
cards;
373
374
375
;
run;
data want;
set have;
test=intnx('month', '01Jan1960'd, num_months);
format test date9.;
test2=test;
format test2 yymm7.;
run;
It looks like its counting months from January 1, 1960.
The example below shows how to convert it to a SAS date called test and then display as month or date (variable=test2).
data have;
input num_months;
cards;
373
374
375
;
run;
data want;
set have;
test=intnx('month', '01Jan1960'd, num_months);
format test date9.;
test2=test;
format test2 yymm7.;
run;
Perfect! Thanks
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.