topic Re: Date formatting in SAS Programming

Date formatting

myboys2 — Thu, 12 Oct 2017 16:48:53 GMT

I have field as a char 10 (teststop3) 01/31/2017

I need to make this field a numeric 8. I have tried many ways and can not get this straight one way was

srvstop=input(teststop3,8.)

ballardw — Thu, 12 Oct 2017 17:36:51 GMT

Likely you are looking for something like:

srvstop = input(teststop3, mmddyy10.);

and if you want to see the value as a date apply an appropriate format:

format srvstop mmddyy10. ;

format srvstop date9. ;

as a couple of examples.

srvstop will have a value similar to 20850. The formats show the value as a human readable date.

PeterClemmensen — Thu, 12 Oct 2017 19:59:09 GMT

data _null_;
   chardate = '01/31/2017';
   date = input(chardate, mmddyy10.);
   format date date9.;
   put date;
run;