Date format issue - date9 not working

tobyfarms — Mon, 13 Nov 2017 16:33:15 GMT

Hello,

I am importing several tables where the date field is in Character format(1994/06/17), which I want to place is date9 format (17JUN1994). I know the fix is simple but I am missing something in my code. .

1 %_eg_hidenotesandsource;

5 %_eg_hidenotesandsource;

30 Data work.Weather_Merge;

31 set ACY_F_100117_2017_10_02_07_30_21 DCA_F_100117_2017_10_02_07_30_27 ILG_F_100217_2017_10_03_07_30_37

31 ! SBY_F_100217_2017_10_03_07_30_42;

32 where 'O/F'n = 'O';

34 rename 'O/F'n = Status;

35 hour=substr('Forecast Date'n,11,3);

36 date=substr('Forecast Date'n,1,10);

38 format date date9.;

______

484

NOTE 484-185: Format $DATE was not found or could not be loaded.

40 Drop 'Forecast Date'n 'Forecast Date_0001'n;

41 Run;

NOTE: There were 98 observations read from the data set WORK.ACY_F_100117_2017_10_02_07_30_21.

WHERE 'O/F'n='O';

NOTE: There were 98 observations read from the data set WORK.DCA_F_100117_2017_10_02_07_30_27.

WHERE 'O/F'n='O';

NOTE: There were 98 observations read from the data set WORK.ILG_F_100217_2017_10_03_07_30_37.

WHERE 'O/F'n='O';

NOTE: There were 98 observations read from the data set WORK.SBY_F_100217_2017_10_03_07_30_42.

WHERE 'O/F'n='O';

NOTE: The data set WORK.WEATHER_MERGE has 392 observations and 15 variables.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.01 seconds

Data work.Weather_Merge;
set ACY_F_100117_2017_10_02_07_30_21 DCA_F_100117_2017_10_02_07_30_27 ILG_F_100217_2017_10_03_07_30_37 SBY_F_100217_2017_10_03_07_30_42;
where 'O/F'n = 'O';

rename 'O/F'n = Status;
hour=substr('Forecast Date'n,11,3);
date=substr('Forecast Date'n,1,10);

format date date9.;

Drop 'Forecast Date'n 'Forecast Date_0001'n;
Run;

Re: Date format issue - date9 not working

Astounding — Mon, 13 Nov 2017 16:45:32 GMT

You are creating DATE as a character variable. But to apply the DATE9 format, DATE must be numeric, with a value that matches SAS's idea of what a date looks like. Fortunately, all of this can be corrected by changing this statement:

date=substr('Forecast Date'n,1,10);

Instead, it should be:

date=input('Forecast Date'n, yymmdd10.) ;

Re: Date format issue - date9 not working

tobyfarms — Mon, 13 Nov 2017 16:48:22 GMT

That Worked. Thanks for the quick fix.

topic Re: Date format issue - date9 not working in SAS Programming

Date format issue - date9 not working

Re: Date format issue - date9 not working

Re: Date format issue - date9 not working