topic creating a date format variable in SAS Programming

creating a date format variable

Gick — Tue, 08 Mar 2022 12:44:25 GMT

data dat;
length month 8 year 8 ;
input month year;
datalines;
2         2020
5         1992
10       2005
12       2012
4 1994
;
Data dat;
set dat;
format date DDMM10. mois1 $ 2. annee1 $4.;
mois1=put(month, 2.);
annee1=put(year, 4.);
date=mdy(input(mois1,DDMM10.),input(annee1,DDMM10.));
run;

Hi,

I have 2 numeric format variables month and year. The data is presented in the set dat. I want to calculate the date variable in date format taking into account only the month and the year, for example "Feb2020" or "02/2020".

here is the code i made but i find the dots(.). I don't know why it doesn't work.

I'm open to other suggestions too.

Thank you
Gick

Re: creating a date format variable

PaigeMiller — Tue, 08 Mar 2022 12:58:35 GMT

data want;
    set dat;
    date=mdy(month,1,year);
    format date monyy7.;
run;

Re: creating a date format variable

Tom — Tue, 08 Mar 2022 14:25:39 GMT

The reason it does not work is pretty clearly explained by the error messages in the SAS log.

1035  Data dat;
1036  set dat;
1037  format date DDMM10. mois1 $ 2. annee1 $4.;
                  -------
                  484
NOTE 484-185: Format DDMM was not found or could not be loaded.

1038  mois1=put(month, 2.);
1039  annee1=put(year, 4.);
1040  date=mdy(input(mois1,DDMM10.),input(annee1,DDMM10.));
                           -------               -------
                           485                   485
           ---
           71
NOTE 485-185: Informat DDMM was not found or could not be loaded.

ERROR 71-185: The MDY function call does not have enough arguments.

1041  run;

There is no format named DDMM nor any informat with that name either.

The MDY() function requires three arguments, Month, Day and Year.

Your dataset has Month and Year so you just need to pick some day in that month to be able to generate a date value. Normally people use 1.