topic Re: Convert numeric to date YYYYMMDD format in SAS Programming

Convert numeric to date YYYYMMDD format

newboy1218 — Fri, 26 Jul 2019 16:01:39 GMT

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;

Re: Convert numeric to date YYYYMMDD format

Reeza — Fri, 26 Jul 2019 16:05:43 GMT

What does your input values look like? 200906?

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

Re: Convert numeric to date YYYYMMDD format

newboy1218 — Fri, 26 Jul 2019 16:06:14 GMT

yeah 😃

Re: Convert numeric to date YYYYMMDD format

novinosrin — Fri, 26 Jul 2019 16:10:28 GMT


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

Re: Convert numeric to date YYYYMMDD format

newboy1218 — Fri, 26 Jul 2019 16:13:54 GMT

Amazing. Thank you so much!

Re: Convert numeric to date YYYYMMDD format

Tom — Fri, 26 Jul 2019 16:56:39 GMT

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