topic Re: how to fix date in SAS Programming

how to fix date

thanikondharish — Tue, 14 Aug 2018 13:24:54 GMT

data s1 ;
name=22122018 ;
run;

proc sql ;
select input(put(name,best.),ddmmyy10.) as date format=ddmmyyd10. from s1 ;
quit;

if run above program it gives 22-12-2020 but i want as it is date

Ksharp — Tue, 14 Aug 2018 13:30:42 GMT

data s1 ;
name=22122018 ;
run;

proc sql ;
select input(put(name,best. -l),ddmmyy10.) as date format=ddmmyyd10. from s1 ;
quit;

thanikondharish — Tue, 14 Aug 2018 13:34:22 GMT

what is best. -|

data_null__ — Tue, 14 Aug 2018 13:37:37 GMT

@thanikondharish wrote:
what is best. -|

-L left justify.

thanikondharish — Tue, 14 Aug 2018 13:50:22 GMT

how it works could you explain that

Kurt_Bremser — Tue, 14 Aug 2018 15:13:05 GMT

So you have a 8-digit number that should be a date. Convert it with

date = input(put(name,z8.),ddmmyy8.);

The z8. format makes sure that leading zeroes are not dropped.

What format you assign to the new variable depends on how you want it displayed.

Ksharp — Wed, 15 Aug 2018 12:50:05 GMT

Your code would keep lead blanks .

Like : ___20122018 .So when you input() it ,your code only read the first 10 characters ___201220, that lead to wrong date.

if you use put(x,best. -L) would get rid of lead blanks and you would get:

20122018 and input() will correctly read it .