topic Re: How to store a SAS numeric date field to a new dataset with a date type in SAS Programming

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

lmtamina — Wed, 14 Feb 2018 16:17:55 GMT

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.

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

Reeza — Wed, 14 Feb 2018 16:19:55 GMT

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.;

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

lmtamina — Wed, 14 Feb 2018 16:27:06 GMT

It worked! Thank you so much!