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
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.
@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.
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.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.