topic Re: how to change date format 20160107 into sas dates in SAS Enterprise Guide

how to change date format 20160107 into sas dates

SASuserxx — Mon, 15 May 2017 04:16:02 GMT

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

Re: how to change date format 20160107 into sas dates

RahulG — Mon, 15 May 2017 04:25:15 GMT

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.

Re: how to change date format 20160107 into sas dates

SASuserxx — Mon, 15 May 2017 04:52:28 GMT

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

Re: how to change date format 20160107 into sas dates

Reeza — Mon, 15 May 2017 05:27:49 GMT

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

Re: how to change date format 20160107 into sas dates

Kurt_Bremser — Mon, 15 May 2017 06:44:23 GMT

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-data-AKA-generate/ta-p/258712 to post your data in the form of a data step.