topic Re: Converting character variable to SAS date in SAS Programming

Converting character variable to SAS date

lillymaginta1 — Tue, 26 Apr 2022 13:44:23 GMT

data have;
infile cards ;
input ID   $Date1 ;	 
cards;
001 200404
002 201205
003 200903
;
run;

I have a data with date variable entered into a character format. Would it be possible to: 1) assign all dates a day of "01" and 2) convert the variable to SAS date

Output

001 04012004

002 05012012

003 03012009 ;

Re: Converting character variable to SAS date

andreas_lds — Tue, 26 Apr 2022 13:46:30 GMT

Yes, of course, something like

data want;
  set have(rename=(Date1 = DateStr));
  Date = input(cats(DateStr, '01'), yymmdd8.);
  format Date mmddyy8.;
run;

Re: Converting character variable to SAS date

lillymaginta1 — Tue, 26 Apr 2022 13:48:43 GMT

Super! thank you!

Re: Converting character variable to SAS date

japelin — Tue, 26 Apr 2022 13:49:34 GMT

data want;
  set have;
  sasdt=input(cats(date1,'01'),yymmdd8.);
  format sasdt mmddyyn8.;
run;