How to store a SAS numeric date field to a new dataset with a date type

[lmtamina]

Good Morning,

I am creating a new variable that will store the end of the month data of my "date of service " field. I am using the formula below:

eom_var= intnx('month',serv_from_date,0,'e');

eom_date = put(eom_var, mmddyy10.);

The variable created in the new dataset has a character type. How do I convert this new variable to date field type so I can compare with another dataset whose date variables are all date type.

I am beginner in SA and would greatly appreciate your assistance. Thank you in advance.

[Reeza · Accepted solution]

eom_var= intnx('month',serv_from_date,0,'e');

eom_date = put(eom_var, mmddyy10.);  <- PUT converts the variable to a character. Remove this line.

Instead, add a format to your date so you can see it properly.

eom_date = intnx('month', serv_from_date, 0, 'e');
format eom_date yymmdd10.;

[lmtamina]

It worked! Thank you so much!