topic Re: Reading Raw Data Error in SAS Programming

Reading Raw Data Error

jfaruqui — Fri, 29 Mar 2019 18:50:16 GMT

Hi,

Just experimenting with very basic raw data reading and I'm getting stumped with this error.

Any insight or help will be appreciated

The error shows the program I am running .. the raw data is 24/12/1856765

The first 8 characters is the date 24/12/18 i am trying to read with the informat ddmmyy8. but its throwing an error

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

73 data test;

74 input date :ddmmyy8. @9 amount;

75 format date date9. amount dollar16.2;

76 cards;

NOTE: Invalid data for date in line 77 1-13.

RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----

77 24/12/1856765

date=. amount=$56,765.00 _ERROR_=1 _N_=1

NOTE: The data set WORK.TEST has 1 observations and 2 variables.

NOTE: DATA statement used (Total process time):

Re: Reading Raw Data Error

novinosrin — Fri, 29 Mar 2019 18:58:43 GMT

~~Can you paste the datalines as well plz?~~

~~I can't see the data~~

data test;
input date ddmmyy8.  amount;
format date date9. amount dollar16.2;
cards;
24/12/1856765
;

Re: Reading Raw Data Error

Tom — Fri, 29 Mar 2019 18:58:45 GMT

By using the colon modifier you told SAS to read all of the characters up to the next delimiter (or end of line) using the MMDDYY informat.

Note that in list mode the INPUT statement ignores the width on the informat and uses the width of the actual next word of data. SAS cannot make a date value with a year of 1,856,765.

Just remove the : from the INPUT statement.

Re: Reading Raw Data Error

jfaruqui — Fri, 29 Mar 2019 20:52:42 GMT

Thanks guys ... silly silly mistake ..