topic Re: Not able to read the date accurately in SAS Programming

Not able to read the date accurately

kajal_30 — Tue, 21 Jun 2022 14:22:58 GMT

I have one column having values like 20201022, 20200123, 20220410 I have tried almost all informats to read the value. Can anyone please suggest the informat to read these values? I am expecting to read it as date and output value in the format of date9.

Thanks

Kajal

Re: Not able to read the date accurately

PaigeMiller — Tue, 21 Jun 2022 14:29:37 GMT

You don't say if these values are numeric or character according to PROC CONTENTS.

If character, use informat YYMMDD8.

If numeric, they have to be converted to character first.

Re: Not able to read the date accurately

JOL — Tue, 21 Jun 2022 15:03:00 GMT

Did you try adding the colon (:) modifier:

data test;
format d1 d2 d3 date9.;
input d1 :yymmdd8. d2 :yymmdd8. d3 :yymmdd8.;
datalines;
20201022 20200123 20220410
;
run;

Re: Not able to read the date accurately

ballardw — Tue, 21 Jun 2022 15:06:36 GMT

Code and/or log.

Please don't make us guess what you attempted and failed.

Re: Not able to read the date accurately

kajal_30 — Tue, 21 Jun 2022 22:22:09 GMT

Thank you everyone. It worked fine after converting the type.