Date Formatting

[Sas_noob25]

I have a dataset that has the following columns:

Year - Numerical - 2021

Date - Character - 07/03

I am attempting to get a numerical day_skey that takes the two columns and creates the following:

day_skey - 20210703

Any tips on how to get my desired date field?

[PeterClemmensen]

Use the MDY function and the yymmddn8. format.

data _null_;
   year = 2021;
   date = '07/03';
   dt = mdy(scan(date, 1, '/'), scan(date, 2, '/'), year);
   put dt = yymmddn8.;
run;

[ballardw · Accepted solution]

If you don't want to see the log "NOTE: Character values have been converted to numeric values at the places given by: "  one of several ways:

data _null_;
   year = 2021;
   date = '07/03';
   dt = Input(catx('/',date,year),mmddyy10.);
   put dt = yymmddn8.;
run;

[Sas_noob25]

I tried both options but am still getting the same result for the day_skey

[Sas_noob25]

Thanks for your response. I've tried doing your example, but am getting the following for the desired date field:

[Kurt_Bremser]

These are valid SAS date values (count of days starting at 1960-01-01), but you need to assign a date format to make them human-readable:

format day_skey yymmdd10.;

[Sas_noob25]

Thank you all! I just needed to format that date, it wasn't working with the put statement for some reason. 

[ballardw]

The PUT state results appear in the LOG (or if you have a FILE statement in the named file).