INPUT date conversion

[G_I_Jeff]

Have a date field on INFILE with format CCYY.JJJ and need to convert to SAS date. Can't seem to wrap my head around this for some reason. Example of input date:

2020.350

[Reeza]

What should that map to? Is 350 the # of days? ie roughly December 15/16, 2020?

If so, I think that's a Julian Date.
https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.5&docsetId=leforinforref&docsetTarge...

data test; 
date='2018099'; 
sasdate=input(date,julian7.); 
put sasdate ; 
put sasdate date9.; 
run;

---

@G_I_Jeff wrote:

Have a date field on INFILE with format CCYY.JJJ and need to convert to SAS date. Can't seem to wrap my head around this for some reason. Example of input date:

2020.350

---

[G_I_Jeff]

Reeza,
It is a Julian date, but the field has the full year (CCYY) separated with the Julian date (JJJ) with a period:

2020.350
How do you take account of the period in the INPUT statement?

Jeff

[Reeza]

Remove the period (COMPRESS) or create a custom informat that handles the period. I'd lean towards the COMPRESS option.

[Tom · Accepted solution]

Remove the period and use JULIAN7. informat.  Or parse out the YEAR and DAYS part and re-combine them.

data test;
  input str $ ;
  date1=input(compress(str,'.'),julian7.);
  date2=mdy(1,1,input(str,4.))+input(scan(str,2,'.'),3.)-1;
  format date: yymmdd10.;
  put (_all_) (=);
cards;
2020.350
2020.001
;