Help using Base SAS procedures

How to change BEST12 to MMDDYY10.

Accepted Solution Solved
Reply
Contributor
Posts: 41
Accepted Solution

How to change BEST12 to MMDDYY10.

I have a numeric date variable with the format BEST12 and informat BEST32 assigned to it. I want to change it to MMDDYY10. How can I do this?

Thanks in advance


Accepted Solutions
Solution
‎06-05-2018 09:49 AM
Contributor
Posts: 41

Re: How to change BEST12 to MMDDYY10.

Yes, you are right.

I just figured this out. This is what I am doing and it works. Thank you very much.

 

data temp;

set flowsheet;

 

service_day2= input(put(service_day, z8.),yymmdd8.);

format service_day2 mmddyy10.;

drop service_day;

rename service_day2= service_day;

run;

View solution in original post


All Replies
Super User
Super User
Posts: 9,599

Re: How to change BEST12 to MMDDYY10.

Post example test data in the form of a datastep.  Otherwise I am just guessing what you have!  Is it looking like this?

data want;
  num_var=20180212;
  date_var=input(put(num_date,8.),yymmdd8.);
  format date_var date9.;
run;
Solution
‎06-05-2018 09:49 AM
Contributor
Posts: 41

Re: How to change BEST12 to MMDDYY10.

Yes, you are right.

I just figured this out. This is what I am doing and it works. Thank you very much.

 

data temp;

set flowsheet;

 

service_day2= input(put(service_day, z8.),yymmdd8.);

format service_day2 mmddyy10.;

drop service_day;

rename service_day2= service_day;

run;

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 150 views
  • 0 likes
  • 2 in conversation