topic Re: SAS char convert to Date format in SAS Programming

SAS char convert to Date format

JHE — Mon, 19 Aug 2019 17:15:25 GMT

Good afternoon,

I have data set, the date is Char, I need convert to Date.

data Set: Test_date

DOB DOB2
19380527 1938-05-27
19720416 1972-04-16
19400701 1940-07-01
19520821 1952-08-21
19451202 1945-12-02
19320128 1932-01-28
19410922 1941-09-22
19620520 1962-05-20
19310303 1931-03-03
19300816 1930-08-16

My SAS program, but do not know this is not working:

data new ;
set test_date;
b = (SUBSTR(DOB,1,4)||'-'||SUBSTR(DOB,5,2)||'-'||SUBSTR(DOB,7,2));
c=input(dob2,mmddyy10.);
format c mmddyy10.;
d=datepart(c);
run;

Please help/ I need convert DOB2 from Char to Date format.

Re: SAS char convert to Date format

novinosrin — Mon, 19 Aug 2019 17:19:32 GMT


data have;
input DOB   :$10.        DOB2  :$10. ;
cards;
19380527 1938-05-27
19720416 1972-04-16
19400701 1940-07-01
19520821 1952-08-21
19451202 1945-12-02
19320128 1932-01-28
19410922 1941-09-22
19620520 1962-05-20
19310303 1931-03-03
19300816 1930-08-16
;
data want;
set have;
num_dob=input(dob,yymmdd10.);
num_dob2=input(dob2,yymmdd10.);
format num_dob: date9.;
run;

Re: SAS char convert to Date format

ballardw — Mon, 19 Aug 2019 17:20:13 GMT

You can read that character value with the yymmdd8. or yymmdd10 informat depending on which one. Your code shows DOB but you ask about DOB2 so I am not sure what you actually want.

But consider;

data example;
   input dob yymmdd8.;
   format dob mmddyy10.;
datalines;
19380527 
19720416 
19400701 
19520821 
19451202 
19320128 
19410922 
19620520 
19310303 
19300816 
run;

Re: SAS char convert to Date format

JHE — Mon, 19 Aug 2019 17:39:02 GMT

Thank you. this works.

Re: SAS char convert to Date format

JHE — Mon, 19 Aug 2019 17:39:35 GMT

Thank you.