topic Date format error? in SAS Procedures

Date format error?

ybz12003 — Wed, 07 Mar 2018 14:49:55 GMT

Hello,

I have imported code below. But the log page showed error message below. Please advice how to fix it.

Data residences;
      infile  "\\Pathway\ResidencesDates.csv" dlm="," dsd missover lrecl=32000 firstobs=2;
;
input 
      Id
      ResStartMM_1
      ResStartYY_1
      ResStopMM_1
      ResStopYY_1
	  ;
Format  ResStartMM_1 DateMM.;
Format  ResStartYY_1 DateYY.;
Format  ResStopMM_1 DateMM.;
Format  ResStopYY_1 DateYY.;
Label  ResStartMM_1="Residence Start Date Month";
Label  ResStartYY_1="Residence Start Date Year";
Label  ResStopMM_1="Residence Stop Date Month";
Label  ResStopYY_1="Residence Stop Date Year";
RUN;

The error message in the Log page:

45 Format ResStartMM_1 DateMM.;

-------

ERROR 48-59: The format DATEMM was not found or could not be loaded.

46 Format ResStartYY_1 DateYY.;

-------

ERROR 48-59: The format DATEYY was not found or could not be loaded.

47 Format ResStopMM_1 DateMM.;

-------

ERROR 48-59: The format DATEMM was not found or could not be loaded.

48 Format ResStopYY_1 DateYY.;

-------

ERROR 48-59: The format DATEYY was not found or could not be loaded.

Re: Date format error?

Astounding — Wed, 07 Mar 2018 14:55:46 GMT

Months and years are numeric variables that don't need formats.

Are you trying to change how they are displayed? If the answer is no, then just get rid of the format statements.

Re: Date format error?

ybz12003 — Wed, 07 Mar 2018 14:56:29 GMT

I paste the code below again.

Data residences;

infile "\\Pathway\ResidencesDates.csv" dlm="," dsd missover lrecl=32000 firstobs=2;

;

input

ResStartMM_1

ResStartYY_1

ResStopMM_1

ResStopYY_1

;

Format ResStartMM_1 DateMM.;

Format ResStartYY_1 DateYY.;

Format ResStopMM_1 DateMM.;

Format ResStopYY_1 DateYY.;

Label ResStartMM_1="Residence Start Date Month";

Label ResStartYY_1="Residence Start Date Year";

Label ResStopMM_1="Residence Stop Date Month";

Label ResStopYY_1="Residence Stop Date Year";

RUN;

Re: Date format error?

Damo — Wed, 07 Mar 2018 15:00:01 GMT

Hi @ybz12003

Those are not valid formats.

Try to use date9., etc. (cf https://support.sas.com/documentation/cdl/en/leforinforref/64790/HTML/default/viewer.htm#n16vcb736tge20n1ex3yxx49fzqa.htm)

Hope that helps.

Cheers,
Damien

Re: Date format error?

ybz12003 — Wed, 07 Mar 2018 15:00:59 GMT

Below is my CSV file. It's in the numbers was in general format in Excel. I'm not sure if you could see that.

Id	ResStartMM_1	ResStartYY_1	ResStopMM_1	ResStopYY_1
30005	2	1994	6	2001

Re: Date format error?

RW9 — Wed, 07 Mar 2018 15:25:16 GMT

Use valid formats. You can find a lit of them on:

https://support.sas.com/documentation/cdl/en/leforinforref/64790/HTML/default/viewer.htm#titlepage.htm

Re: Date format error?

ybz12003 — Wed, 07 Mar 2018 15:34:51 GMT

Thank you all your prompt reply. I got it fixed.