topic Informat for date in SAS Programming

Informat for date

GreggB — Wed, 17 Oct 2018 21:18:16 GMT

dates vary in length. single digit months and single digit days do not have leading zeroes.

WHENCREATED

9/20/2018 7:58 AM

9/2/2018 7:00 AM

11/20/2018 9:58 AM

data WORK.CHRONIC_ABSENTEEISM;
infile 'G:\FAKEPATH\Chronic_Absenteeism.csv' delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2 ;

informat WHENCREATED ???;

format SchoolYear 4. CollectionID $4. DISTRICTCODE 4.;
	
input  SchoolYear	CollectionID $	DISTRICTCODE WHENCREATED;
run;

Re: Informat for date

ballardw — Wed, 17 Oct 2018 21:39:18 GMT

Do you want a date or datetime? They are different.

Unless you have reason to suspect that you have incomplete or partial dates you might try ANYDTDTM32.

Assign a datetime19. or longer format to display a 4 digit year.

Re: Informat for date

singhsahab — Thu, 18 Oct 2018 03:53:05 GMT

Hello Sir,

Good Morning !!

Thank you for your suggestion on above question . I applied informat and format as mention. But while applying format datetime20. or datetime19. , view of date & time got change. if i applied only any date format then it's working perfectly.

Here is my code.

data test;
input date anydtdte32.;
format date datetime20.;
cards;
9/20/2018 7:58 AM
9/2/2018 7:00 AM
11/20/2018 9:58 AM
;
run;

here is output . Looking for your suggestion .

Re: Informat for date

ChrisNZ — Thu, 18 Oct 2018 03:57:07 GMT

You have a date and not a datetime.

Use

format date date9.;

Re: Informat for date

andreas_lds — Thu, 18 Oct 2018 04:58:18 GMT

Try mdyampm20. as informat, instead of anydtdte32.

Re: Informat for date

Kurt_Bremser — Thu, 18 Oct 2018 07:17:19 GMT

Use the mdyampm informat, as suggested by @andreas_lds, and a proper datetime format for display:

data want;
infile cards dlm=',' truncover;
input
  schoolyear :4.
  collectionid :$4.
  districtcode :$4.
  whencreated :mdyampm25.
;
format whencreated e8601dt20.;
cards;
2018,AAAA,AAAA,9/20/2018 7:58 AM
2018,BBBB,BBBB,9/2/2018 7:00 AM
2018,CCCC,CCCC,11/20/2018 9:58 AM
;
run;

Re: Informat for date

Ksharp — Thu, 18 Oct 2018 13:25:21 GMT

You are using WRONG informat .

input date anydtdtm32.;

Re: Informat for date

GreggB — Thu, 18 Oct 2018 15:41:28 GMT

I don't get an error when using anydtdtm32.; but it returns all values as missing.

Re: Informat for date

ballardw — Thu, 18 Oct 2018 18:13:25 GMT

@singhsahab wrote:

Hello Sir,

Good Morning !!

Thank you for your suggestion on above question . I applied informat and format as mention. But while applying format datetime20. or datetime19. , view of date & time got change. if i applied only any date format then it's working perfectly.

Here is my code.

data test;
input date anydtdte32.;
format date datetime20.;
cards;
9/20/2018 7:58 AM
9/2/2018 7:00 AM
11/20/2018 9:58 AM
;
run;

here is output . Looking for your suggestion .

I suggested ANYDTDTM32 and expected to be reading from an external file. Your input would be incorrect in data lines as you are not accounting for spaces

data test;
infile datalines dsd;
input date anydtdtm32.;
format date datetime20.;
cards;
9/20/2018 7:58 AM
9/2/2018 7:00 AM
11/20/2018 9:58 AM
;
run;