topic Reading raw data with missing values: Error message by SAS in SAS Studio

Reading raw data with missing values: Error message by SAS

ak2011 — Fri, 22 Nov 2019 17:12:50 GMT

I would appreciate if someone could help me with the SAS code to properly read the dataset below:
I have missing values and SAS log produced an error message.There were 21 obs but SAS read only 17.
 Please help. Thanks. The SAS log is shown below.


data idnew1m;
input id$  job idchem;
datalines;
os1 1 990005
os1 1 990021
    1 210701
os1 1 211700
os1 2 211700
os1 2 990021
os2 2 
os1 2 210701
os1 2 990005
os2 1 210701
os2   211700 
os2 1 990005
os2 2 990021
os2 3 210701
os2 3 990005
os3 3 210701
os3 1 211700
os4 1 210701
os4 1 990005
os4 1 211700
os5  990021
;
run;

proc print data=idnew1m;
run;

.

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

73 data idnew1m;

74 input id$ job idchem;

75 datalines;

NOTE: Invalid data for idchem in line 79 1-3.

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

79 os1 1 211700

id=1 job=210701 idchem=. _ERROR_=1 _N_=3

NOTE: Invalid data for idchem in line 83 1-3.

83 os1 2 210701

id=os2 job=2 idchem=. _ERROR_=1 _N_=6

NOTE: Invalid data for idchem in line 87 1-3.

87 os2 1 990005

id=os2 job=211700 idchem=. _ERROR_=1 _N_=9

NOTE: LOST CARD.

97 ;

id=os5 job=990021 idchem=. _ERROR_=1 _N_=18

NOTE: SAS went to a new line when INPUT statement reached past the end of a line.

NOTE: The data set WORK.IDNEW1M has 17 observations and 3 variables.

NOTE: DATA statement used (Total process time):

real time 0.01 seconds

cpu time 0.01 seconds

97 ;

98 run;

100 proc print data=idnew1m;

101 run;

NOTE: There were 17 observations read from the data set WORK.IDNEW1M.

NOTE: PROCEDURE PRINT used (Total process time):

real time 0.25 seconds

cpu time 0.25 seconds

102

103

104 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

116

Thanks in advance.

ak.

Re: Reading raw data with missing values: Error message by SAS

Tom — Fri, 22 Nov 2019 17:23:02 GMT

If you want to use list mode input, like in your INPUT statement, then you need to have a value for every field. Use a period to indicate missing values (for both numeric and character variables).

data idnew1m;
  input id$  job idchem;
datalines;
os1 1 990021
.   1 210701
os2 2 .
os2 . 211700 
os4 1 211700
;

Or make sure the values are always in the same place on the line. Then you could switch to formattted input

data idnew1m;
  input id $3. +1 job 1. +1 idchem 5.;
datalines;
os1 1 990021
    1 210701
os2 2
os2   211700
os4 1 211700
;

or column based input.

data idnew1m;
  input id $ 1-3 job 5 idchem 7-12 ;
datalines;
os1 1 990021
    1 210701
os2 2
os2   211700
os4 1 211700
;

You could still use list mode if you used to the DSD option to interpret adjacent delimiters as representing a missing value. Normally you would use something other than space as the delimiter in that case.

data idnew1m;
  infile datalines dsd dlm='|' truncover;
  input id$  job idchem;
datalines;
os1|1|990021
|1|210701
os2|2|
os2||211700 
os4|1|211700
;

Re: Reading raw data with missing values: Error message by SAS

ak2011 — Mon, 25 Nov 2019 09:23:58 GMT

Thanks very much, Tom! SAS reads perfect now!