topic Re: Convert days from YTD count into mm-dd in SAS Programming

Convert days from YTD count into mm-dd

brulard — Thu, 27 Apr 2017 11:31:52 GMT

hello,

I need to convert date-of-birth that is printed in text as YYYYNNN where NNN=days count from Jan1 inclusive.

Here are the examples:

Data have;

Input DOB $ ;

Datalines;

1975325

1993236

1980280

run;

here is the output that I would like to get:

DATA WANT;

FORMAT DOB $ 10.;

Input DOB $ ;

Datalines;

1975-11-21

1993-08-24

1980-06-10

RUN;

thank you

Re: Convert days from YTD count into mm-dd

RW9 — Thu, 27 Apr 2017 11:49:05 GMT

I don't know of an informat offhand which would handle that, but just code is pretty simple:

data have;
  input dob $;
  date_of_birth=input(cats(substr(dob,1,4),"01","01"),yymmdd10.) + input(substr(dob,5),best.);
  format date_of_birth date9.; 
datalines;
1975325
1993236
1980280
run;

So create a date of 01-01-year, and then add days on.

Re: Convert days from YTD count into mm-dd

brulard — Thu, 27 Apr 2017 12:16:53 GMT

Thanks RW9.

Re: Convert days from YTD count into mm-dd

RW9 — Thu, 27 Apr 2017 12:17:48 GMT

Actually,after scanning the formats page there is a format to do this (always best to use the informats where possible):

http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000201594.htm

data have;
  informat dob julian7.;
  input dob;
  format dob yymmdd10.; 
datalines;
1975325
1993236
1980280
run;