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

Reply
New Contributor
Posts: 4

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

 

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.

 

Super User
Posts: 21,530

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

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.;
New Contributor
Posts: 4

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

It worked! Thank you so much!

 

Ask a Question
Discussion stats
  • 2 replies
  • 72 views
  • 1 like
  • 2 in conversation