Convert numeric to date YYYYMMDD format

[newboy1218]

Hi. In my dataset I have a variable has format numeric 8.. I would like to change it to YYYYMMDD without '-' or '/'.

All records' perfdate is '200906'. However, my result 'hidate' is '1920-09-06', which is not what I want. I want them to be '20090531' (the month end before perfdate). Thanks.

data B;
	set A;
	hidate = input(put(perfdate - 1, 8.), yymmdd10.);
	format hidate yymmdd10.;
run;

[Reeza]

What does your input values look like? 200906?

And then you want that incremented to the previous month end date?

[newboy1218]

yeah 😃

[novinosrin · Accepted solution]

data want;
num_date=200906;
want_date=intnx('month',input(put(num_date,8. -l),yymmn6.),-1,'e');
format want_date yymmddn8.;
run;

[newboy1218]

Amazing. Thank you so much!

[Tom]

You are subtracting one in the wrong place. You are using the wrong informat for reading a string that is missing the day of the month.

data A;
 perfdate=200906;
run;
data B;
  set A ;
  hidate = input(put(perfdate, 6.), yymmn6.)-1;
  format hidate yymmdd10.;
run;
proc print;
run;

Obs    perfdate        hidate

 1      200906     2009-05-31