topic Re: Convert charachter date to sas date in SAS Programming

Convert charachter date to sas date

Viktoreli — Wed, 25 Sep 2019 12:33:09 GMT

Hi,

I know this is a subject on wich there is alot of forum posts already but I was not able to find a solution for my problem.

I have a dataset with dates in the characther (L:10 Format:$10 Informat:$10) format "yyyy-mm-dd" and I want to transform them to a SAS numeric date, or add a new variable with the SAS numeric date. I have been trying to use the informat E8601DAw. in different ways but I may be using it wrong.

date=input(olddate, E8601DAw.);
run;

This gives me an error on the informat E8601DAw and 0 observations.

Is there another informat I should use to transform the dates from characther to sas date? Should I be using a different code?

I would be highly gratefull for any response,

thank you in advance.

Re: Convert charachter date to sas date

PaigeMiller — Wed, 25 Sep 2019 12:36:51 GMT

cdate = '2019-02-17';
date = input(cdate,yymmdd10.);

Re: Convert charachter date to sas date

PeterClemmensen — Wed, 25 Sep 2019 12:38:02 GMT

data test;
    olddate='2019-09-25';
    date=input(olddate, yymmdd10.);
    format date yymmdd10.;
run;

Re: Convert charachter date to sas date

Kurt_Bremser — Wed, 25 Sep 2019 13:04:09 GMT

The lowercase "w" stands for width and needs to be replaced by a suitable number, in your case 10.

Re: Convert charachter date to sas date

data_null__ — Wed, 25 Sep 2019 13:05:03 GMT

lower case w in is the width specification should be number or use default.

15   data _null_;
16      olddate = '2019-09-25';
17      date=input(olddate, E8601DA.);
18      put date= date=date11.;
19      run;

date=21817 date=25-SEP-2019

Re: Convert charachter date to sas date

Viktoreli — Wed, 25 Sep 2019 13:27:20 GMT

Thank you very much for your response. Thanks for the info! It finally worked but had to remove

olddate = '2019-09-25'

I really apreciate your help!