month date conversion

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 122
Accepted Solution

month date conversion

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


Accepted Solutions
Solution
‎07-18-2013 08:01 PM
Super User
Posts: 19,851

Re: month date conversion

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;

View solution in original post


All Replies
Solution
‎07-18-2013 08:01 PM
Super User
Posts: 19,851

Re: month date conversion

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;

Frequent Contributor
Posts: 122

Re: month date conversion

Perfect! Thanks

🔒 This topic is solved and locked.

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

Discussion stats
  • 2 replies
  • 272 views
  • 0 likes
  • 2 in conversation