topic Date and Time formats in SAS Programming

Date and Time formats

Sairampulipati — Tue, 28 Apr 2020 15:00:34 GMT

Hi All,

I have a dataset in csv format and I can import it to SAS data, but there is particular variable for date and time in the format of 200428202835 (which is YYMMDDHHMMSS). I wanted to read this variable as in proper format like date9. and time5. Is there any option to get above formatted date and time in this format.

Best Regards,

Sairam

Re: Date and Time formats

ballardw — Tue, 28 Apr 2020 15:16:08 GMT

One way:

data example;
   x = '200428202835';
   date = input(x,yymmdd6.);
   time = input(substr(x,7), hhmmss.);
   format date date9. time time8.;
run;

You will likely need to read the value as character and then parse because this is a pretty non-typical format.

And talk to whoever is using 2 digit years. Did they not learn anything from Y2K?

Re: Date and Time formats

Sairampulipati — Tue, 28 Apr 2020 15:42:01 GMT

Thank you very much for the resolution. I would reach to my data manager to check the Y2K.

Re: Date and Time formats

FreelanceReinh — Tue, 28 Apr 2020 15:45:25 GMT

Hi @Sairampulipati,

Assuming that you are using the most recommended technique for reading CSV files, a DATA step with INPUT statement(s), you can mix input styles and switch to formatted input for just the date part of this particular field.

Example:

data want;
infile cards dsd;
input seqno name $ date yymmdd6. time :hhmmss. amt :dollar.;
format date date9. time time8.;
cards;
1,John Doe,200428202835,$1234.56
;

Re: Date and Time formats

Tom — Tue, 28 Apr 2020 16:00:58 GMT

@Sairampulipati wrote:

Thank you very much for the resolution. I would reach to my data manager to check the Y2K.

If you can get the century digits included then your strings will match the B8601DJ informat.

https://documentation.sas.com/?docsetId=leforinforref&docsetTarget=n1hj2e5ozbucufn1laeoghx9pb6r.htm&docsetVersion=9.4&locale=en