Extracting date from day/month/year

Babloo — Fri, 21 Sep 2018 05:06:00 GMT

I have a variables as follows. Day as character,Month as character and year as numeric. I want to combine these variables to create a new SAS date variable.

Example:

data test;

day='21';

month='11'; /*have to convert to this to November. i.e.1 as January, 12 as December*/

year=2018;

run;

Desired Output:

Renewal_date='21NOV2018'd /*should be in SAS date*/

Re: Extracting date from day/month/year

Kurt_Bremser — Fri, 21 Sep 2018 05:15:09 GMT

Concatenate day, month and put(year,z4.) to one string, and use the informat ddmmyy8. in an input() function. Assign a date format as desired.

topic Extracting date from day/month/year in SAS Programming

Extracting date from day/month/year

Re: Extracting date from day/month/year