Desktop productivity for business analysts and programmers

how to change date format 20160107 into sas dates

Reply
Contributor
Posts: 23

how to change date format 20160107 into sas dates

Hi all,

 

im trying to change my sas format from 

20160107

 to a sas format sas forecast studio can read.

 

i have tried yymmddn8. but it comes up blank. my current laod format is numeric 

 

thank you

 

Super Contributor
Posts: 259

Re: how to change date format 20160107 into sas dates

data _null_;
format want date9.;
val=20160515;
want=input(put(val,8.),yymmdd8.);
put want=;
run;

I converted numeric value to string and then converted it back to numeric using yymmdd8.

Contributor
Posts: 23

Re: how to change date format 20160107 into sas dates

HI

Thank you,

This would mean is I have a column with all the dates of 20160101 then I will have to put all in

I would just replace the data to the variables column




Super User
Posts: 19,132

Re: how to change date format 20160107 into sas dates


SASuserxx wrote:
HI

Thank you,

This would mean is I have a column with all the dates of 20160101 then I will have to put all in

I would just replace the data to the variables column





This is unclear. 

Super User
Posts: 7,431

Re: how to change date format 20160107 into sas dates

When you posted your question, you saw this at the bottom:

 

Stop right there! Before pressing POST, tick off this checklist. Does your post …

✔ Have a descriptive subject line, i.e., How do I ‘XYZ’? ✔ Use simple language and provide context? Definitely mention what version you’re on. ✔ Include code and example data? Consider using the SAS Syntax feature.

 

 

 

 

 

 

Please follow these suggestions, especially #3. Use the macro from https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-dat... to post your data in the form of a data step.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Ask a Question
Discussion stats
  • 4 replies
  • 132 views
  • 2 likes
  • 4 in conversation