topic Re: date conversion in SAS Programming

date conversion

Xinhui — Wed, 20 Nov 2019 23:08:44 GMT

Hello There

My date variable is present like 20120317, I tried the code "fomate date yymmdd8.;" hoever, there is a error occurs as " There was a problem with the format so BEST. was used." .

Please let me know how to convert the 20120317 to yymmdd8.

Thanks advance.

Re: date conversion

art297 — Wed, 20 Nov 2019 23:21:11 GMT

Try:

data have;
  input date;
  cards;
20120317
;
run;

data want (drop=_:);
  set have (rename=(date=_date));
  format date yymmdd8.;
  date=input(put(_date,8.),yymmdd8.);
run;

Art, CEO, AnalystFinder.com

Re: date conversion

ballardw — Wed, 20 Nov 2019 23:24:41 GMT

Your current variable is apparently a simple numeric with the value 20120317. So conversion would look like:

data want;
   set have;
   datevar = input(put(datevar,f8. -L),yymmdd10.);
   format datevar date9.; /* to show the FORMAT is working*/
run;

use whatever format that you want.