Re: Error w/ColumnInput?

ashb · Posted 09-16-2020 09:14 AM

I have an issue. I am trying to use ColumnInput to input this data set instream, but i keep coming up with errors. This is the code:

data ColumnInput;
input Jurisdiction 1-14 Confirmed Cases 16-31 Probable Cases 33-47 Total Cases 49-60;
Delaware 15930 1012 16942
Washington D.C . . 13590
Maryland . . 104669
New Jersey . . 189494
Pennsylvania 125407 3641 129048
Virginia 108767 4863 113630
West Virginia 9097 175 9272
run;

"Delaware" keeps showing up in red text and this is the error line I get:

Delaware 15930 1012 16942
--------
180
ERROR 180-322: Statement is not valid or it is used out of proper order.

What should I do?

Shmuel · Posted 09-16-2020 09:26 AM

Did you mean:

data ColumnInput;
    length Jurisdiction $20; /* assign max length needed */
    infile cards;
    input Jurisdiction $ Confirmed_Cases  Probable_Cases  Total_cases; 
cards;
Delaware 15930 1012 16942
Washington D.C . . 13590
Maryland . . 104669
New Jersey . . 189494
Pennsylvania 125407 3641 129048
Virginia 108767 4863 113630
West Virginia 9097 175 9272
;
run;

pay attention:

1) you missed assigning variable type - '$' for char-type.

2) your input is not formatted in fixed positions

3) You missed assigning input file - cards or datalines for in-stream data

4) You missed the semicolon ; to assign end of input just before RUN;

5) Since Jurisdiction is sometimes a single words and sometimes more then one

you need to add delimiters between the variables. The default delimiter - a space -

is not good enough.

If you add the delimiters then the INFILE statement need a change:

infile cards dlm='<your delimiter>';

PaigeMiller · Posted 09-16-2020 09:26 AM

You have a number of errors in your code.

If you place a CARDS; statement after the INPUT statement and on the line above Delaware, then the red goes away.

But the way you have presented the input data in your DATA step, this is not a place where COLUMN input would work, as clearly (for example) the values for Total Cases is not in columns 49-60. And the variable name Total Cases (with a space) is not a valid variable name (as are some of your other variable names).

Since your Jurisdiction names sometimes have spaces in them, you need to account for that as well.

So you need to clean all this up as well

--
Paige Miller

Kurt_Bremser · Posted 09-16-2020 09:41 AM

Please use the "little running man" button to post your code. It may very well be that your column numbers are correct, but the horizontal formatting of your code was scrambled when you posted it in the main window.

A DATALINES (or CARDS) block ends with a line with a single semicolon, and since the DATALINES statement is always the last of a data step (and therefore constitutes a step boundary), no RUN is needed.

Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
The macro for direct download as ZIP
How to post code
Please vote for Provide Sequential Search Capability for Hash Objects
How to deal with locked files on UNIX

ashb · Posted 09-16-2020 09:52 AM

Thank you everyone. I fixed it and used ListInput instead, but not it won't show up on the output:

data ListInput;
infile datalines;
input Jurisdiction $ Confirmed_Cases Probable_Cases Total_Cases;
datalines;
Delaware 15930 1012 16942
Washington_DC..13590
Maryland..104669
New_Jersey..189494
Pennsylvania 125407 3641 129048
Virginia 108767 4863 113630
West_Virginia 9097 175 9272
;
proc print data=ListInput;
run;

Kurt_Bremser · Posted 09-16-2020 10:14 AM

Please do NOT (as in NOT) post code and logs in the main posting window. Use the "little running man" for code and </> for logs.

Please post the whole log of these two steps, using the correct subwindow as mentioned above.

Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
The macro for direct download as ZIP
How to post code
Please vote for Provide Sequential Search Capability for Hash Objects
How to deal with locked files on UNIX

ashb · Posted 09-16-2020 01:00 PM

Tried to fix it...still isn't working

LOG
172  data NewData;
173      length Name $ 16;
174      input Jurisdiction $ ConfirmedCases ProbableCases TotalCases;
175      datalines;

NOTE: Variable Name is uninitialized.
NOTE: Invalid data for ConfirmedCases in line 176 17-25.
NOTE: Invalid data for ProbableCases in line 176 27-31.
NOTE: Invalid data for TotalCases in line 176 33-40.
RULE:      ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0
176        Jurisdiction    Confirmed Cases Probable Cases  Total Cases
Name=  Jurisdiction=Jurisdic ConfirmedCases=. ProbableCases=. TotalCases=. _ERROR_=1 _N_=1
NOTE: Invalid data for ConfirmedCases in line 177 13-18.
NOTE: Invalid data for ProbableCases in line 177 21-25.
NOTE: Invalid data for TotalCases in line 177 29-34.
177        Delaware    15,930  1,012   16,942
Name=  Jurisdiction=Delaware ConfirmedCases=. ProbableCases=. TotalCases=. _ERROR_=1 _N_=2
NOTE: Invalid data for ConfirmedCases in line 178 12-15.
NOTE: Invalid data for ProbableCases in line 178 17-19.
NOTE: Invalid data for TotalCases in line 178 21-23.
178        Washington D.C. N/A N/A 13,590
Name=  Jurisdiction=Washingt ConfirmedCases=. ProbableCases=. TotalCases=. _ERROR_=1 _N_=3
NOTE: Invalid data for ConfirmedCases in line 179 13-15.
NOTE: Invalid data for ProbableCases in line 179 17-19.
NOTE: Invalid data for TotalCases in line 179 21-27.
179        Maryland    N/A N/A 104,669
Name=  Jurisdiction=Maryland ConfirmedCases=. ProbableCases=. TotalCases=. _ERROR_=1 _N_=4
NOTE: Invalid data for ConfirmedCases in line 180 5-10.
NOTE: Invalid data for ProbableCases in line 180 13-15.
NOTE: Invalid data for TotalCases in line 180 17-19.
180        New Jersey  N/A N/A 189,494
Name=  Jurisdiction=New ConfirmedCases=. ProbableCases=. TotalCases=. _ERROR_=1 _N_=5
NOTE: Invalid data for ConfirmedCases in line 181 17-23.
NOTE: Invalid data for ProbableCases in line 181 25-29.
NOTE: Invalid data for TotalCases in line 181 33-39.
181        Pennsylvania    125,407 3,641   129,048
Name=  Jurisdiction=Pennsylv ConfirmedCases=. ProbableCases=. TotalCases=. _ERROR_=1 _N_=6
NOTE: Invalid data for ConfirmedCases in line 182 13-19.
NOTE: Invalid data for ProbableCases in line 182 21-25.
NOTE: Invalid data for TotalCases in line 182 29-35.
182        Virginia    108,767 4,863   113,630
Name=  Jurisdiction=Virginia ConfirmedCases=. ProbableCases=. TotalCases=. _ERROR_=1 _N_=7
NOTE: Invalid data for ConfirmedCases in line 183 6-13.
NOTE: Invalid data for ProbableCases in line 183 17-21.
183        West Virginia   9,097   175 9,272
Name=  Jurisdiction=West ConfirmedCases=. ProbableCases=. TotalCases=175 _ERROR_=1 _N_=8
NOTE: The data set WORK.NEWDATA has 8 observations and 5 variables.
NOTE: DATA statement used (Total process time):
      real time           0.08 seconds
      cpu time            0.07 seconds


184  run;

185  options nodate center orientation=landscape;
186  run;
187  proc import datafile='C:\Users\bamfo\Downloads\Copy of BMX_J.xlsx'
188      out=ExcelData
189      dbms=xlsx;
190  run;

NOTE: Import cancelled.  Output dataset WORK.EXCELDATA already exists.  Specify REPLACE option to overwrite it.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE IMPORT used (Total process time):
      real time           0.00 seconds
      cpu time            0.01 seconds



191  proc print data=work.exceldata (obs=10);
192  run;

NOTE: There were 10 observations read from the data set WORK.EXCELDATA.
NOTE: PROCEDURE PRINT used (Total process time):
      real time           0.05 seconds
      cpu time            0.04 seconds


193  proc means data=work.exceldata;
194      var bmdstats bmxwt bmxht bmxwaist bmxhip;
195  run;

NOTE: There were 8704 observations read from the data set WORK.EXCELDATA.
NOTE: PROCEDURE MEANS used (Total process time):
      real time           0.07 seconds
      cpu time            0.04 seconds


196  data NewData;
197      length Name $ 16;
198      input Jurisdiction $ ConfirmedCases ProbableCases TotalCases;
199      datalines;

NOTE: Variable Name is uninitialized.
NOTE: Invalid data for ConfirmedCases in line 200 17-25.
NOTE: Invalid data for ProbableCases in line 200 27-31.
NOTE: Invalid data for TotalCases in line 200 33-40.
RULE:      ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0
200        Jurisdiction    Confirmed Cases Probable Cases  Total Cases
Name=  Jurisdiction=Jurisdic ConfirmedCases=. ProbableCases=. TotalCases=. _ERROR_=1 _N_=1
NOTE: Invalid data for ConfirmedCases in line 201 13-18.
NOTE: Invalid data for ProbableCases in line 201 21-25.
NOTE: Invalid data for TotalCases in line 201 29-34.
201        Delaware    15,930  1,012   16,942
Name=  Jurisdiction=Delaware ConfirmedCases=. ProbableCases=. TotalCases=. _ERROR_=1 _N_=2
NOTE: Invalid data for ConfirmedCases in line 202 12-15.
NOTE: Invalid data for ProbableCases in line 202 17-19.
NOTE: Invalid data for TotalCases in line 202 21-23.
202        Washington D.C. N/A N/A 13,590
Name=  Jurisdiction=Washingt ConfirmedCases=. ProbableCases=. TotalCases=. _ERROR_=1 _N_=3
NOTE: Invalid data for ConfirmedCases in line 203 13-15.
NOTE: Invalid data for ProbableCases in line 203 17-19.
NOTE: Invalid data for TotalCases in line 203 21-27.
203        Maryland    N/A N/A 104,669
Name=  Jurisdiction=Maryland ConfirmedCases=. ProbableCases=. TotalCases=. _ERROR_=1 _N_=4
NOTE: Invalid data for ConfirmedCases in line 204 5-10.
NOTE: Invalid data for ProbableCases in line 204 13-15.
NOTE: Invalid data for TotalCases in line 204 17-19.
204        New Jersey  N/A N/A 189,494
Name=  Jurisdiction=New ConfirmedCases=. ProbableCases=. TotalCases=. _ERROR_=1 _N_=5
NOTE: Invalid data for ConfirmedCases in line 205 17-23.
NOTE: Invalid data for ProbableCases in line 205 25-29.
NOTE: Invalid data for TotalCases in line 205 33-39.
205        Pennsylvania    125,407 3,641   129,048
Name=  Jurisdiction=Pennsylv ConfirmedCases=. ProbableCases=. TotalCases=. _ERROR_=1 _N_=6
NOTE: Invalid data for ConfirmedCases in line 206 13-19.
NOTE: Invalid data for ProbableCases in line 206 21-25.
NOTE: Invalid data for TotalCases in line 206 29-35.
206        Virginia    108,767 4,863   113,630
Name=  Jurisdiction=Virginia ConfirmedCases=. ProbableCases=. TotalCases=. _ERROR_=1 _N_=7
NOTE: Invalid data for ConfirmedCases in line 207 6-13.
NOTE: Invalid data for ProbableCases in line 207 17-21.
207        West Virginia   9,097   175 9,272
Name=  Jurisdiction=West ConfirmedCases=. ProbableCases=. TotalCases=175 _ERROR_=1 _N_=8
NOTE: The data set WORK.NEWDATA has 8 observations and 5 variables.
NOTE: DATA statement used (Total process time):
      real time           0.05 seconds
      cpu time            0.06 seconds


208  run;
209  data ListInput;
210      length Name $ 16;
211      input Jurisdiction $ ConfirmedCases ProbableCases TotalCases;
212      datalines;

NOTE: Variable Name is uninitialized.
NOTE: Invalid data for ConfirmedCases in line 213 17-25.
NOTE: Invalid data for ProbableCases in line 213 27-31.
NOTE: Invalid data for TotalCases in line 213 33-40.
RULE:      ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0
213        Jurisdiction    Confirmed Cases Probable Cases  Total Cases
Name=  Jurisdiction=Jurisdic ConfirmedCases=. ProbableCases=. TotalCases=. _ERROR_=1 _N_=1
NOTE: Invalid data for ConfirmedCases in line 214 13-18.
NOTE: Invalid data for ProbableCases in line 214 21-25.
NOTE: Invalid data for TotalCases in line 214 29-34.
214        Delaware    15,930  1,012   16,942
Name=  Jurisdiction=Delaware ConfirmedCases=. ProbableCases=. TotalCases=. _ERROR_=1 _N_=2
NOTE: Invalid data for ConfirmedCases in line 215 12-15.
NOTE: Invalid data for ProbableCases in line 215 17-19.
NOTE: Invalid data for TotalCases in line 215 21-23.
215        Washington D.C. N/A N/A 13,590
Name=  Jurisdiction=Washingt ConfirmedCases=. ProbableCases=. TotalCases=. _ERROR_=1 _N_=3
NOTE: Invalid data for ConfirmedCases in line 216 13-15.
NOTE: Invalid data for ProbableCases in line 216 17-19.
NOTE: Invalid data for TotalCases in line 216 21-27.
216        Maryland    N/A N/A 104,669
Name=  Jurisdiction=Maryland ConfirmedCases=. ProbableCases=. TotalCases=. _ERROR_=1 _N_=4
NOTE: Invalid data for ConfirmedCases in line 217 5-10.
NOTE: Invalid data for ProbableCases in line 217 13-15.
NOTE: Invalid data for TotalCases in line 217 17-19.
217        New Jersey  N/A N/A 189,494
Name=  Jurisdiction=New ConfirmedCases=. ProbableCases=. TotalCases=. _ERROR_=1 _N_=5
NOTE: Invalid data for ConfirmedCases in line 218 17-23.
NOTE: Invalid data for ProbableCases in line 218 25-29.
NOTE: Invalid data for TotalCases in line 218 33-39.
218        Pennsylvania    125,407 3,641   129,048
Name=  Jurisdiction=Pennsylv ConfirmedCases=. ProbableCases=. TotalCases=. _ERROR_=1 _N_=6
NOTE: Invalid data for ConfirmedCases in line 219 13-19.
NOTE: Invalid data for ProbableCases in line 219 21-25.
NOTE: Invalid data for TotalCases in line 219 29-35.
219        Virginia    108,767 4,863   113,630
Name=  Jurisdiction=Virginia ConfirmedCases=. ProbableCases=. TotalCases=. _ERROR_=1 _N_=7
NOTE: Invalid data for ConfirmedCases in line 220 6-13.
NOTE: Invalid data for ProbableCases in line 220 17-21.
220        West Virginia   9,097   175 9,272
Name=  Jurisdiction=West ConfirmedCases=. ProbableCases=. TotalCases=175 _ERROR_=1 _N_=8
NOTE: The data set WORK.LISTINPUT has 8 observations and 5 variables.
NOTE: DATA statement used (Total process time):
      real time           0.06 seconds
      cpu time            0.03 seconds


221  run;

222  data ListInput;
223      length Jurisdiction $ 16;
224      input Jurisdiction $ ConfirmedCases ProbableCases TotalCases;
225      datalines;

NOTE: Invalid data for ConfirmedCases in line 226 17-25.
NOTE: Invalid data for ProbableCases in line 226 27-31.
NOTE: Invalid data for TotalCases in line 226 33-40.
RULE:      ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0
226        Jurisdiction    Confirmed Cases Probable Cases  Total Cases
Jurisdiction=Jurisdiction ConfirmedCases=. ProbableCases=. TotalCases=. _ERROR_=1 _N_=1
NOTE: Invalid data for ConfirmedCases in line 227 13-18.
NOTE: Invalid data for ProbableCases in line 227 21-25.
NOTE: Invalid data for TotalCases in line 227 29-34.
227        Delaware    15,930  1,012   16,942
Jurisdiction=Delaware ConfirmedCases=. ProbableCases=. TotalCases=. _ERROR_=1 _N_=2
NOTE: Invalid data for ConfirmedCases in line 228 12-15.
NOTE: Invalid data for ProbableCases in line 228 17-19.
NOTE: Invalid data for TotalCases in line 228 21-23.
228        Washington D.C. N/A N/A 13,590
Jurisdiction=Washington ConfirmedCases=. ProbableCases=. TotalCases=. _ERROR_=1 _N_=3
NOTE: Invalid data for ConfirmedCases in line 229 13-15.
NOTE: Invalid data for ProbableCases in line 229 17-19.
NOTE: Invalid data for TotalCases in line 229 21-27.
229        Maryland    N/A N/A 104,669
Jurisdiction=Maryland ConfirmedCases=. ProbableCases=. TotalCases=. _ERROR_=1 _N_=4
NOTE: Invalid data for ConfirmedCases in line 230 5-10.
NOTE: Invalid data for ProbableCases in line 230 13-15.
NOTE: Invalid data for TotalCases in line 230 17-19.
230        New Jersey  N/A N/A 189,494
Jurisdiction=New ConfirmedCases=. ProbableCases=. TotalCases=. _ERROR_=1 _N_=5
NOTE: Invalid data for ConfirmedCases in line 231 17-23.
NOTE: Invalid data for ProbableCases in line 231 25-29.
NOTE: Invalid data for TotalCases in line 231 33-39.
231        Pennsylvania    125,407 3,641   129,048
Jurisdiction=Pennsylvania ConfirmedCases=. ProbableCases=. TotalCases=. _ERROR_=1 _N_=6
NOTE: Invalid data for ConfirmedCases in line 232 13-19.
NOTE: Invalid data for ProbableCases in line 232 21-25.
NOTE: Invalid data for TotalCases in line 232 29-35.
232        Virginia    108,767 4,863   113,630
Jurisdiction=Virginia ConfirmedCases=. ProbableCases=. TotalCases=. _ERROR_=1 _N_=7
NOTE: Invalid data for ConfirmedCases in line 233 6-13.
NOTE: Invalid data for ProbableCases in line 233 17-21.
233        West Virginia   9,097   175 9,272
Jurisdiction=West ConfirmedCases=. ProbableCases=. TotalCases=175 _ERROR_=1 _N_=8
NOTE: The data set WORK.LISTINPUT has 8 observations and 4 variables.
NOTE: DATA statement used (Total process time):
      real time           0.05 seconds
      cpu time            0.03 seconds


234  run;

235  data FormatInput;
236      input Jurisdiction $17. ConfirmedCases 6. ProbableCases 4. TotalCases 7.;
237      datalines;

NOTE: Invalid data for ConfirmedCases in line 238 18-23.
NOTE: Invalid data for ProbableCases in line 238 24-27.
NOTE: Invalid data for TotalCases in line 238 28-34.
RULE:      ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0
238        Jurisdiction    Confirmed Cases Probable Cases  Total Cases
Jurisdiction=Jurisdiction    C ConfirmedCases=. ProbableCases=. TotalCases=. _ERROR_=1 _N_=1
NOTE: Invalid data for ConfirmedCases in line 239 18-23.
NOTE: Invalid data for TotalCases in line 239 28-34.
239        Delaware    15,930  1,012   16,942
Jurisdiction=Delaware    15,93 ConfirmedCases=. ProbableCases=12 TotalCases=. _ERROR_=1 _N_=2
NOTE: Invalid data for ConfirmedCases in line 240 18-23.
NOTE: Invalid data for ProbableCases in line 240 24-27.
240        Washington D.C. N/A N/A 13,590
Jurisdiction=Washington D.C. N ConfirmedCases=. ProbableCases=. TotalCases=590 _ERROR_=1 _N_=3
NOTE: Invalid data for ConfirmedCases in line 241 18-23.
NOTE: Invalid data for ProbableCases in line 241 24-27.
241        Maryland    N/A N/A 104,669
Jurisdiction=Maryland    N/A N ConfirmedCases=. ProbableCases=. TotalCases=. _ERROR_=1 _N_=4
NOTE: Invalid data for ConfirmedCases in line 242 18-23.
NOTE: Invalid data for ProbableCases in line 242 24-27.
242        New Jersey  N/A N/A 189,494
Jurisdiction=New Jersey  N/A N ConfirmedCases=. ProbableCases=. TotalCases=. _ERROR_=1 _N_=5
NOTE: Invalid data for ConfirmedCases in line 243 18-23.
NOTE: Invalid data for ProbableCases in line 243 24-27.
NOTE: Invalid data for TotalCases in line 243 28-34.
243        Pennsylvania    125,407 3,641   129,048
Jurisdiction=Pennsylvania    1 ConfirmedCases=. ProbableCases=. TotalCases=. _ERROR_=1 _N_=6
NOTE: Invalid data for ConfirmedCases in line 244 18-23.
NOTE: Invalid data for TotalCases in line 244 28-34.
244        Virginia    108,767 4,863   113,630
Jurisdiction=Virginia    108,7 ConfirmedCases=. ProbableCases=63 TotalCases=. _ERROR_=1 _N_=7
NOTE: Invalid data for ConfirmedCases in line 245 18-23.
NOTE: Invalid data for TotalCases in line 245 28-34.
245        West Virginia   9,097   175 9,272
Jurisdiction=West Virginia   9 ConfirmedCases=. ProbableCases=175 TotalCases=. _ERROR_=1 _N_=8
NOTE: The data set WORK.FORMATINPUT has 8 observations and 4 variables.
NOTE: DATA statement used (Total process time):
      real time           0.07 seconds
      cpu time            0.06 seconds


246  run;

247  data FormatInput;
248      input Jurisdiction $17. ConfirmedCases 6. ProbableCases 4. TotalCases 7.;
249      datalines;

NOTE: Invalid data for ConfirmedCases in line 250 18-23.
NOTE: Invalid data for ProbableCases in line 250 24-27.
NOTE: Invalid data for TotalCases in line 250 28-34.
RULE:      ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0
250        Jurisdiction    Confirmed Cases Probable Cases  Total Cases
Jurisdiction=Jurisdiction    C ConfirmedCases=. ProbableCases=. TotalCases=. _ERROR_=1 _N_=1
NOTE: Invalid data for ConfirmedCases in line 252 18-23.
252        Washington D.C. N/A N/A 13590
Jurisdiction=Washington D.C. N ConfirmedCases=. ProbableCases=135 TotalCases=90 _ERROR_=1 _N_=3
NOTE: Invalid data for ConfirmedCases in line 253 18-23.
253        Maryland    N/A N/A 104669
Jurisdiction=Maryland    N/A N ConfirmedCases=. ProbableCases=669 TotalCases=. _ERROR_=1 _N_=4
NOTE: Invalid data for ConfirmedCases in line 254 18-23.
254        New Jersey  N/A N/A 189494
Jurisdiction=New Jersey  N/A N ConfirmedCases=. ProbableCases=494 TotalCases=. _ERROR_=1 _N_=5
NOTE: Invalid data for TotalCases in line 255 28-34.
255        Pennsylvania    125407  3641    129048
Jurisdiction=Pennsylvania    1 ConfirmedCases=25407 ProbableCases=364 TotalCases=. _ERROR_=1 _N_=6
NOTE: Invalid data for ConfirmedCases in line 256 18-23.
256        Virginia    108767  4863    113630
Jurisdiction=Virginia    10876 ConfirmedCases=. ProbableCases=3 TotalCases=113630 _ERROR_=1 _N_=7
NOTE: The data set WORK.FORMATINPUT has 8 observations and 4 variables.
NOTE: DATA statement used (Total process time):
      real time           0.06 seconds
      cpu time            0.03 seconds


258  run;

259  data ListInput;
260      length Jurisdiction $ 14
261      input Jurisdiction $ Confirmed Cases Probable Cases Total Cases;
                              ---------
                              22
WARNING: Length of character variable Jurisdiction has already been set.
         Use the LENGTH statement as the very first statement in the DATA STEP to declare the length of a character variable.
261      input Jurisdiction $ Confirmed Cases Probable Cases Total Cases;
                                                                        -
                                                                        22
ERROR 22-322: Expecting a numeric constant.

1    1
     -
     352
262  Delaware    15930   1012    16942
     --------
     180
ERROR 352-185: The length of numeric variables is 3-8.

ERROR 180-322: Statement is not valid or it is used out of proper order.

263  Washington DC   .   .   13590
264  Maryland    .   .   104669
265  New Jersey  .   .   189494
266  Pennsylvania    125407  3641    129048
267  Virginia    108767  4863    113630
268  West Virginia   9097    175 9272
269  run;

NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.LISTINPUT may be incomplete.  When this step was stopped there were 0 observations and 6 variables.
WARNING: Data set WORK.LISTINPUT was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
      real time           10:48.71
      cpu time            5.57 seconds



270  data ColumnInput;
271      length Jurisdiction $ 14
272      input Jurisdiction $ 1-14 Confirmed Cases 16-22 Probable Cases 24-30 Total Cases 32-38
                               -
                               22
                               200
WARNING: Length of character variable Jurisdiction has already been set.
         Use the LENGTH statement as the very first statement in the DATA STEP to declare the length of a character variable.
ERROR 22-322: Syntax error, expecting one of the following: a name, ;, DEFAULT, _ALL_, _CHARACTER_, _CHAR_, _NUMERIC_.

ERROR 200-322: The symbol is not recognized and will be ignored.

352: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 352-185: The length of numeric variables is 3-8.
272      input Jurisdiction $ 1-14 Confirmed Cases 16-22 Probable Cases 24-30 Total Cases 32-38
                                                     -
                                                     22
ERROR 22-322: Syntax error, expecting one of the following: a name, ;, DEFAULT, _ALL_, _CHARACTER_, _CHAR_, _NUMERIC_.

272      input Jurisdiction $ 1-14 Confirmed Cases 16-22 Probable Cases 24-30 Total Cases 32-38
                                                     -
                                                     200
ERROR 200-322: The symbol is not recognized and will be ignored.

352: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 352-185: The length of numeric variables is 3-8.
272      input Jurisdiction $ 1-14 Confirmed Cases 16-22 Probable Cases 24-30 Total Cases 32-38
                                                                          -
                                                                          22
ERROR 22-322: Syntax error, expecting one of the following: a name, ;, DEFAULT, _ALL_, _CHARACTER_, _CHAR_, _NUMERIC_.

272      input Jurisdiction $ 1-14 Confirmed Cases 16-22 Probable Cases 24-30 Total Cases 32-38
                                                                          -
                                                                          200
ERROR 200-322: The symbol is not recognized and will be ignored.

352: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 352-185: The length of numeric variables is 3-8.
272      input Jurisdiction $ 1-14 Confirmed Cases 16-22 Probable Cases 24-30 Total Cases 32-38
                                                                                            -
                                                                                            22
ERROR 22-322: Syntax error, expecting one of the following: a name, ;, DEFAULT, _ALL_, _CHARACTER_, _CHAR_, _NUMERIC_.

272      input Jurisdiction $ 1-14 Confirmed Cases 16-22 Probable Cases 24-30 Total Cases 32-38
                                                                                            -
                                                                                            200
ERROR 200-322: The symbol is not recognized and will be ignored.

273  Delaware    15930   1012    16942
352: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 352-185: The length of numeric variables is 3-8.
22: LINE and COLUMN cannot be determined.
NOTE 242-205: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 22-322: Syntax error, expecting one of the following: a name, ;, DEFAULT, _ALL_, _CHARACTER_, _CHAR_, _NUMERIC_.
200: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 200-322: The symbol is not recognized and will be ignored.
274  Washington DC   .   .   13590
352: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 352-185: The length of numeric variables is 3-8.
22: LINE and COLUMN cannot be determined.
NOTE 242-205: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 22-322: Syntax error, expecting one of the following: a name, a numeric constant, $, -, :, VARCHAR, _ALL_, _CHARACTER_, _CHAR_,
              _NUMERIC_.
76: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 76-322: Syntax error, statement will be ignored.
275  Maryland    .   .   104669
276  New Jersey  .   .   189494
277  Pennsylvania    125407  3641    129048
278  Virginia    108767  4863    113630
279  West Virginia   9097    175 9272
280  run;

NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.COLUMNINPUT may be incomplete.  When this step was stopped there were 0 observations and 12 variables.
NOTE: DATA statement used (Total process time):
      real time           6:47.05
      cpu time            10.93 seconds



281  data ListInput;
282      length Jurisdiction $13
283      input Jurisdiction Confirmed Cases Probable Cases Total Cases;
                                                                      -
                                                                      22
1    1
     -
     352
ERROR 22-322: Expecting a numeric constant.

ERROR 352-185: The length of numeric variables is 3-8.

284      datalines;
ERROR: Numeric length cannot be used with character variable Jurisdiction.

NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.LISTINPUT may be incomplete.  When this step was stopped there were 0 observations and 6 variables.
WARNING: Data set WORK.LISTINPUT was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
      real time           0.04 seconds
      cpu time            0.03 seconds

292  run;


293  data ListInput;
294      input Jurisdiction Confirmed Cases Probable Cases Total Cases;
295      datalines;

NOTE: Invalid data for Jurisdiction in line 296 1-8.
NOTE: Invalid data for Cases in line 297 1-10.
NOTE: Invalid data for Total in line 297 12-13.
RULE:      ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0
297        Washington DC   .   .   13590
NOTE: Invalid data errors for file CARDS occurred outside the printed range.
NOTE: Increase available buffer lines with the INFILE n= option.
Jurisdiction=. Confirmed=15930 Cases=. Probable=16942 Total=. _ERROR_=1 _N_=1
NOTE: Invalid data for Jurisdiction in line 298 1-8.
NOTE: Invalid data for Cases in line 299 1-3.
NOTE: Invalid data for Total in line 299 5-10.
299        New Jersey  .   .   189494
NOTE: Invalid data errors for file CARDS occurred outside the printed range.
NOTE: Increase available buffer lines with the INFILE n= option.
Jurisdiction=. Confirmed=. Cases=. Probable=104669 Total=. _ERROR_=1 _N_=2
NOTE: Invalid data for Jurisdiction in line 300 1-12.
NOTE: Invalid data for Cases in line 301 1-8.
301        Virginia    108767  4863    113630
NOTE: Invalid data errors for file CARDS occurred outside the printed range.
NOTE: Increase available buffer lines with the INFILE n= option.
Jurisdiction=. Confirmed=125407 Cases=4863 Probable=129048 Total=108767 _ERROR_=1 _N_=3
NOTE: Invalid data for Jurisdiction in line 302 1-4.
NOTE: Invalid data for Confirmed in line 302 6-13.
NOTE: LOST CARD.
303        run;
NOTE: Invalid data errors for file CARDS occurred outside the printed range.
NOTE: Increase available buffer lines with the INFILE n= option.
Jurisdiction=. Confirmed=. Cases=9272 Probable=175 Total=. _ERROR_=1 _N_=4
NOTE: SAS went to a new line when INPUT statement reached past the end of a line.
NOTE: The data set WORK.LISTINPUT has 3 observations and 5 variables.
NOTE: DATA statement used (Total process time):
      real time           0.07 seconds
      cpu time            0.06 seconds


303  run;

304  data ListInput;
305      infile n=13
                 -
                 23
ERROR 23-2: Invalid option name =.

306      input Jurisdiction Confirmed Cases Probable Cases Total Cases;
         -----
         23
ERROR 23-2: Invalid option name INPUT.

306!     input Jurisdiction Confirmed Cases Probable Cases Total Cases;
               ------------
               23
ERROR 23-2: Invalid option name JURISDICTION.

306!     input Jurisdiction Confirmed Cases Probable Cases Total Cases;
                            ---------
                            23
ERROR 23-2: Invalid option name CONFIRMED.

306!     input Jurisdiction Confirmed Cases Probable Cases Total Cases;
                                      -----          -----       -----
                                      23             23          23
ERROR 23-2: Invalid option name CASES.

306!     input Jurisdiction Confirmed Cases Probable Cases Total Cases;
                                            --------
                                            23
ERROR 23-2: Invalid option name PROBABLE.

306!     input Jurisdiction Confirmed Cases Probable Cases Total Cases;
                                                           -----
                                                           23
ERROR 23-2: Invalid option name TOTAL.

307      datalines;

NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.LISTINPUT may be incomplete.  When this step was stopped there were 0 observations and 0 variables.
WARNING: Data set WORK.LISTINPUT was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
      real time           0.08 seconds
      cpu time            0.06 seconds

315  run;


316  data ListInput;
317      infile n=15
                 -
                 23
ERROR 23-2: Invalid option name =.

318      input Jurisdiction Confirmed Cases Probable Cases Total Cases;
         -----
         23
ERROR 23-2: Invalid option name INPUT.

318!     input Jurisdiction Confirmed Cases Probable Cases Total Cases;
               ------------
               23
ERROR 23-2: Invalid option name JURISDICTION.

318!     input Jurisdiction Confirmed Cases Probable Cases Total Cases;
                            ---------
                            23
ERROR 23-2: Invalid option name CONFIRMED.

318!     input Jurisdiction Confirmed Cases Probable Cases Total Cases;
                                      -----          -----       -----
                                      23             23          23
ERROR 23-2: Invalid option name CASES.

318!     input Jurisdiction Confirmed Cases Probable Cases Total Cases;
                                            --------
                                            23
ERROR 23-2: Invalid option name PROBABLE.

318!     input Jurisdiction Confirmed Cases Probable Cases Total Cases;
                                                           -----
                                                           23
ERROR 23-2: Invalid option name TOTAL.

319      datalines;

NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.LISTINPUT may be incomplete.  When this step was stopped there were 0 observations and 0 variables.
WARNING: Data set WORK.LISTINPUT was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
      real time           0.07 seconds
      cpu time            0.04 seconds

327  run;


328  data ListInput;
329      length Jurisdiction $ 14
330      input Jurisdiction Confirmed Cases Probable Cases Total Cases;
                                                                      -
                                                                      22
1    1
     -
     352
ERROR 22-322: Expecting a numeric constant.

ERROR 352-185: The length of numeric variables is 3-8.

331      datalines;
ERROR: Numeric length cannot be used with character variable Jurisdiction.

NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.LISTINPUT may be incomplete.  When this step was stopped there were 0 observations and 6 variables.
WARNING: Data set WORK.LISTINPUT was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
      real time           0.04 seconds
      cpu time            0.03 seconds

339  run;


340  data ColumnInput;
341      input Jurisdiction 1-14 Confirmed Cases 16-31 Probable Cases 33-47 Total Cases 49-60;
342  Delaware    15930   1012    16942
     --------
     180
ERROR 180-322: Statement is not valid or it is used out of proper order.

343  Washington D.C  .   .   13590
344  Maryland    .   .   104669
345  New Jersey  .   .   189494
346  Pennsylvania    125407  3641    129048
347  Virginia    108767  4863    113630
348  West Virginia   9097    175 9272
349  run;

ERROR: No DATALINES or INFILE statement.
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.COLUMNINPUT may be incomplete.  When this step was stopped there were 0 observations and 5 variables.
WARNING: Data set WORK.COLUMNINPUT was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
      real time           4:39.39
      cpu time            5.64 seconds



350  data ColumnInput;
351      input Jurisdiction 1-14 Confirmed Cases 16-31 Probable Cases 33-47 Total Cases 49-60;
352      datalines;

NOTE: Invalid data for Jurisdiction in line 353 1-14.
NOTE: Invalid data for Cases in line 353 16-31.
NOTE: Invalid data for Total in line 354 5-14.
RULE:      ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0
354            Washington D.C  .   .   13590
NOTE: Invalid data errors for file CARDS occurred outside the printed range.
NOTE: Increase available buffer lines with the INFILE n= option.
Jurisdiction=. Confirmed=15930 Cases=. Probable=16942 Total=. _ERROR_=1 _N_=1
NOTE: Invalid data for Jurisdiction in line 355 1-14.
NOTE: Invalid data for Cases in line 355 16-31.
NOTE: Invalid data for Probable in line 356 5-7.
NOTE: Invalid data for Total in line 357 5-16.
357            Pennsylvania    125407  3641    129048
NOTE: Invalid data errors for file CARDS occurred outside the printed range.
NOTE: Increase available buffer lines with the INFILE n= option.
Jurisdiction=. Confirmed=. Cases=. Probable=. Total=. _ERROR_=1 _N_=2
NOTE: Invalid data for Jurisdiction in line 358 1-14.
NOTE: Invalid data for Cases in line 358 16-31.
NOTE: Invalid data for Total in line 359 5-8.
359            West Virginia   9097    175 9272
NOTE: Invalid data errors for file CARDS occurred outside the printed range.
NOTE: Increase available buffer lines with the INFILE n= option.
Jurisdiction=. Confirmed=108767 Cases=. Probable=113630 Total=. _ERROR_=1 _N_=3
NOTE: SAS went to a new line when INPUT statement reached past the end of a line.
NOTE: The data set WORK.COLUMNINPUT has 3 observations and 5 variables.
NOTE: DATA statement used (Total process time):
      real time           0.06 seconds
      cpu time            0.06 seconds


360  run;

361  data ColumnInput;
362      input Jurisdiction 1-14 Confirmed Cases 16-31 Probable Cases 33-47 Total Cases 49-60;
363      datalines;

NOTE: Invalid data for Jurisdiction in line 364 1-14.
NOTE: Invalid data for Cases in line 364 16-31.
NOTE: Invalid data for Total in line 365 1-10.
RULE:      ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0
365        Washington D.C  .   .   13590
NOTE: Invalid data errors for file CARDS occurred outside the printed range.
NOTE: Increase available buffer lines with the INFILE n= option.
Jurisdiction=. Confirmed=930 Cases=. Probable=42 Total=. _ERROR_=1 _N_=1
NOTE: Invalid data for Jurisdiction in line 366 1-14.
NOTE: Invalid data for Cases in line 366 16-31.
NOTE: Invalid data for Probable in line 367 1-3.
NOTE: Invalid data for Total in line 368 1-12.
368        Pennsylvania    125407  3641    129048
NOTE: Invalid data errors for file CARDS occurred outside the printed range.
NOTE: Increase available buffer lines with the INFILE n= option.
Jurisdiction=. Confirmed=. Cases=. Probable=. Total=. _ERROR_=1 _N_=2
NOTE: Invalid data for Jurisdiction in line 369 1-14.
NOTE: Invalid data for Cases in line 369 16-31.
NOTE: Invalid data for Total in line 370 1-4.
370        West Virginia   9097    175 9272
NOTE: Invalid data errors for file CARDS occurred outside the printed range.
NOTE: Increase available buffer lines with the INFILE n= option.
Jurisdiction=. Confirmed=8767 Cases=. Probable=630 Total=. _ERROR_=1 _N_=3
NOTE: SAS went to a new line when INPUT statement reached past the end of a line.
NOTE: The data set WORK.COLUMNINPUT has 3 observations and 5 variables.
NOTE: DATA statement used (Total process time):
      real time           0.06 seconds
      cpu time            0.04 seconds


371  run;

372  data ColumnInput;
373      input Jurisdiction 1-14 Confirmed Cases 16-31 Probable Cases 33-47 Total Cases 49-60;
374      datalines;

NOTE: Invalid data for Jurisdiction in line 375 1-14.
NOTE: Invalid data for Cases in line 375 16-31.
NOTE: Invalid data for Total in line 376 1-10.
RULE:      ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0
376        Washington D.C  .   .   13590
NOTE: Invalid data errors for file CARDS occurred outside the printed range.
NOTE: Increase available buffer lines with the INFILE n= option.
Jurisdiction=. Confirmed=930 Cases=. Probable=42 Total=. _ERROR_=1 _N_=1
NOTE: Invalid data for Jurisdiction in line 377 1-14.
NOTE: Invalid data for Cases in line 377 16-31.
NOTE: Invalid data for Probable in line 378 1-3.
NOTE: Invalid data for Total in line 379 1-12.
379        Pennsylvania    125407  3641    129048
NOTE: Invalid data errors for file CARDS occurred outside the printed range.
NOTE: Increase available buffer lines with the INFILE n= option.
Jurisdiction=. Confirmed=. Cases=. Probable=. Total=. _ERROR_=1 _N_=2
NOTE: Invalid data for Jurisdiction in line 380 1-14.
NOTE: Invalid data for Cases in line 380 16-31.
NOTE: Invalid data for Total in line 381 1-4.
381        West Virginia   9097    175 9272
NOTE: Invalid data errors for file CARDS occurred outside the printed range.
NOTE: Increase available buffer lines with the INFILE n= option.
Jurisdiction=. Confirmed=8767 Cases=. Probable=630 Total=. _ERROR_=1 _N_=3
NOTE: SAS went to a new line when INPUT statement reached past the end of a line.
NOTE: The data set WORK.COLUMNINPUT has 3 observations and 5 variables.
NOTE: DATA statement used (Total process time):
      real time           0.05 seconds
      cpu time            0.03 seconds


382  run;

383  data ColumnInput;
384      input Jurisdiction 1-14 Confirmed Cases 16-31 Probable Cases 33-47 Total Cases 49-60;
385      datalines;

NOTE: Invalid data for Jurisdiction in line 386 1-14.
NOTE: Invalid data for Cases in line 386 16-31.
NOTE: Invalid data for Total in line 387 1-10.
RULE:      ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0
387        Washington D.C  .   .   13590
NOTE: Invalid data errors for file CARDS occurred outside the printed range.
NOTE: Increase available buffer lines with the INFILE n= option.
Jurisdiction=. Confirmed=930 Cases=. Probable=42 Total=. _ERROR_=1 _N_=1
NOTE: Invalid data for Jurisdiction in line 388 1-14.
NOTE: Invalid data for Cases in line 388 16-31.
NOTE: Invalid data for Probable in line 389 1-3.
NOTE: Invalid data for Total in line 390 1-12.
390        Pennsylvania    125407  3641    129048
NOTE: Invalid data errors for file CARDS occurred outside the printed range.
NOTE: Increase available buffer lines with the INFILE n= option.
Jurisdiction=. Confirmed=. Cases=. Probable=. Total=. _ERROR_=1 _N_=2
NOTE: Invalid data for Jurisdiction in line 391 1-14.
NOTE: Invalid data for Cases in line 391 16-31.
NOTE: Invalid data for Total in line 392 1-4.
392        West Virginia   9097    175 9272
NOTE: Invalid data errors for file CARDS occurred outside the printed range.
NOTE: Increase available buffer lines with the INFILE n= option.
Jurisdiction=. Confirmed=8767 Cases=. Probable=630 Total=. _ERROR_=1 _N_=3
NOTE: SAS went to a new line when INPUT statement reached past the end of a line.
NOTE: The data set WORK.COLUMNINPUT has 3 observations and 5 variables.
NOTE: DATA statement used (Total process time):
      real time           0.05 seconds
      cpu time            0.04 seconds


393  run;

394  data ColumnInput;
395      input Jurisdiction 1-14 ConfirmedCases 16-31 ProbableCases 33-47 TotalCases 49-60;
396      datalines;

NOTE: Invalid data for Jurisdiction in line 397 1-14.
NOTE: Invalid data for ConfirmedCases in line 397 16-31.
RULE:      ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0
397        Delaware    15930   1012    16942
Jurisdiction=. ConfirmedCases=. ProbableCases=2 TotalCases=. _ERROR_=1 _N_=1
NOTE: Invalid data for Jurisdiction in line 398 1-14.
NOTE: Invalid data for ConfirmedCases in line 398 16-31.
398        Washington D.C  .   .   13590
Jurisdiction=. ConfirmedCases=. ProbableCases=. TotalCases=. _ERROR_=1 _N_=2
NOTE: Invalid data for Jurisdiction in line 399 1-14.
NOTE: Invalid data for ConfirmedCases in line 399 16-31.
399        Maryland    .   .   104669
Jurisdiction=. ConfirmedCases=. ProbableCases=. TotalCases=. _ERROR_=1 _N_=3
NOTE: Invalid data for Jurisdiction in line 400 1-14.
NOTE: Invalid data for ConfirmedCases in line 400 16-31.
400        New Jersey  .   .   189494
Jurisdiction=. ConfirmedCases=. ProbableCases=. TotalCases=. _ERROR_=1 _N_=4
NOTE: Invalid data for Jurisdiction in line 401 1-14.
NOTE: Invalid data for ConfirmedCases in line 401 16-31.
RULE:      ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0
401        Pennsylvania    125407  3641    129048
Jurisdiction=. ConfirmedCases=. ProbableCases=129048 TotalCases=. _ERROR_=1 _N_=5
NOTE: Invalid data for Jurisdiction in line 402 1-14.
NOTE: Invalid data for ConfirmedCases in line 402 16-31.
402        Virginia    108767  4863    113630
Jurisdiction=. ConfirmedCases=. ProbableCases=30 TotalCases=. _ERROR_=1 _N_=6
NOTE: Invalid data for Jurisdiction in line 403 1-14.
NOTE: Invalid data for ConfirmedCases in line 403 16-31.
403        West Virginia   9097    175 9272
Jurisdiction=. ConfirmedCases=. ProbableCases=. TotalCases=. _ERROR_=1 _N_=7
NOTE: The data set WORK.COLUMNINPUT has 7 observations and 4 variables.
NOTE: DATA statement used (Total process time):
      real time           0.06 seconds
      cpu time            0.04 seconds


404  run;

405  data ColumnInput;
406      input Jurisdiction $ 1-14 ConfirmedCases 16-31 ProbableCases 33-47 TotalCases 49-60;
407      datalines;

NOTE: Invalid data for ConfirmedCases in line 408 16-31.
RULE:      ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0
408        Delaware    15930   1012    16942
Jurisdiction=Delaware    15 ConfirmedCases=. ProbableCases=2 TotalCases=. _ERROR_=1 _N_=1
NOTE: Invalid data for ConfirmedCases in line 409 16-31.
409        Washington D.C  .   .   13590
Jurisdiction=Washington D.C ConfirmedCases=. ProbableCases=. TotalCases=. _ERROR_=1 _N_=2
NOTE: Invalid data for ConfirmedCases in line 410 16-31.
410        Maryland    .   .   104669
Jurisdiction=Maryland    . ConfirmedCases=. ProbableCases=. TotalCases=. _ERROR_=1 _N_=3
NOTE: Invalid data for ConfirmedCases in line 411 16-31.
411        New Jersey  .   .   189494
Jurisdiction=New Jersey  . ConfirmedCases=. ProbableCases=. TotalCases=. _ERROR_=1 _N_=4
NOTE: Invalid data for ConfirmedCases in line 412 16-31.
412        Pennsylvania    125407  3641    129048
Jurisdiction=Pennsylvania ConfirmedCases=. ProbableCases=129048 TotalCases=. _ERROR_=1 _N_=5
NOTE: Invalid data for ConfirmedCases in line 413 16-31.
413        Virginia    108767  4863    113630
Jurisdiction=Virginia    10 ConfirmedCases=. ProbableCases=30 TotalCases=. _ERROR_=1 _N_=6
NOTE: Invalid data for ConfirmedCases in line 414 16-31.
414        West Virginia   9097    175 9272
Jurisdiction=West Virginia ConfirmedCases=. ProbableCases=. TotalCases=. _ERROR_=1 _N_=7
NOTE: The data set WORK.COLUMNINPUT has 7 observations and 4 variables.
NOTE: DATA statement used (Total process time):
      real time           0.05 seconds
      cpu time            0.03 seconds


415  run;

416  data ColumnInput;
417      input Jurisdiction $ 1-14 ConfirmedCases 16-31 ProbableCases 33-47 TotalCases 49-60;
418      datalines;

NOTE: Invalid data for ConfirmedCases in line 419 16-31.
RULE:      ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0
419        Delaware    15930   1012    16942
Jurisdiction=Delaware    15 ConfirmedCases=. ProbableCases=2 TotalCases=. _ERROR_=1 _N_=1
NOTE: Invalid data for ConfirmedCases in line 420 16-31.
420        Washington DC   .   .   13590
Jurisdiction=Washington DC ConfirmedCases=. ProbableCases=. TotalCases=. _ERROR_=1 _N_=2
NOTE: Invalid data for ConfirmedCases in line 421 16-31.
421        Maryland    .   .   104669
Jurisdiction=Maryland    . ConfirmedCases=. ProbableCases=. TotalCases=. _ERROR_=1 _N_=3
NOTE: Invalid data for ConfirmedCases in line 422 16-31.
422        New Jersey  .   .   189494
Jurisdiction=New Jersey  . ConfirmedCases=. ProbableCases=. TotalCases=. _ERROR_=1 _N_=4
NOTE: Invalid data for ConfirmedCases in line 423 16-31.
423        Pennsylvania    125407  3641    129048
Jurisdiction=Pennsylvania ConfirmedCases=. ProbableCases=129048 TotalCases=. _ERROR_=1 _N_=5
NOTE: Invalid data for ConfirmedCases in line 424 16-31.
424        Virginia    108767  4863    113630
Jurisdiction=Virginia    10 ConfirmedCases=. ProbableCases=30 TotalCases=. _ERROR_=1 _N_=6
NOTE: Invalid data for ConfirmedCases in line 425 16-31.
425        West Virginia   9097    175 9272
Jurisdiction=West Virginia ConfirmedCases=. ProbableCases=. TotalCases=. _ERROR_=1 _N_=7
NOTE: The data set WORK.COLUMNINPUT has 7 observations and 4 variables.
NOTE: DATA statement used (Total process time):
      real time           0.04 seconds
      cpu time            0.04 seconds


426  run;

427  data ColumnInput;
428      input Jurisdiction $ 1-14 ConfirmedCases 16-31 ProbableCases 33-47 TotalCases 49-60;
429      datalines;

NOTE: Invalid data for ConfirmedCases in line 430 16-31.
RULE:      ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0
430        Delaware    15930   1012    16942
Jurisdiction=Delaware    15 ConfirmedCases=. ProbableCases=2 TotalCases=. _ERROR_=1 _N_=1
NOTE: Invalid data for ConfirmedCases in line 431 16-31.
431        Washington DC   .   .   13590
Jurisdiction=Washington DC ConfirmedCases=. ProbableCases=. TotalCases=. _ERROR_=1 _N_=2
NOTE: Invalid data for ConfirmedCases in line 432 16-31.
432        Maryland    .   .   104669
Jurisdiction=Maryland    . ConfirmedCases=. ProbableCases=. TotalCases=. _ERROR_=1 _N_=3
NOTE: Invalid data for ConfirmedCases in line 433 16-31.
433        New Jersey  .   .   189494
Jurisdiction=New Jersey  . ConfirmedCases=. ProbableCases=. TotalCases=. _ERROR_=1 _N_=4
NOTE: Invalid data for ConfirmedCases in line 434 16-31.
434        Pennsylvania    125407  3641    129048
Jurisdiction=Pennsylvania ConfirmedCases=. ProbableCases=129048 TotalCases=. _ERROR_=1 _N_=5
NOTE: Invalid data for ConfirmedCases in line 435 16-31.
435        Virginia    108767  4863    113630
Jurisdiction=Virginia    10 ConfirmedCases=. ProbableCases=30 TotalCases=. _ERROR_=1 _N_=6
NOTE: Invalid data for ConfirmedCases in line 436 16-31.
436        West Virginia   9097    175 9272
Jurisdiction=West Virginia ConfirmedCases=. ProbableCases=. TotalCases=. _ERROR_=1 _N_=7
NOTE: The data set WORK.COLUMNINPUT has 7 observations and 4 variables.
NOTE: DATA statement used (Total process time):
      real time           0.05 seconds
      cpu time            0.04 seconds


437  ;
438  proc print data=ColumnInput;
439      title 'Number of Ceses per Jurisdiction';
440  run;

NOTE: There were 7 observations read from the data set WORK.COLUMNINPUT.
NOTE: PROCEDURE PRINT used (Total process time):
      real time           0.03 seconds
      cpu time            0.01 seconds


441  data ColumnInput;
442      input Jurisdiction $ 1-13 ConfirmedCases 14-29 ProbableCases 30-48 TotalCases 49-60;
443      datalines;

NOTE: Invalid data for ConfirmedCases in line 444 14-29.
RULE:      ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0
444        Delaware    15930   1012    16942
Jurisdiction=Delaware    1 ConfirmedCases=. ProbableCases=6942 TotalCases=. _ERROR_=1 _N_=1
NOTE: Invalid data for ConfirmedCases in line 445 14-29.
445        Washington DC   .   .   13590
Jurisdiction=Washington DC ConfirmedCases=. ProbableCases=. TotalCases=. _ERROR_=1 _N_=2
NOTE: Invalid data for ConfirmedCases in line 446 14-29.
446        Maryland    .   .   104669
Jurisdiction=Maryland    . ConfirmedCases=. ProbableCases=. TotalCases=. _ERROR_=1 _N_=3
NOTE: Invalid data for ConfirmedCases in line 447 14-29.
447        New Jersey  .   .   189494
Jurisdiction=New Jersey  . ConfirmedCases=. ProbableCases=. TotalCases=. _ERROR_=1 _N_=4
NOTE: Invalid data for ConfirmedCases in line 448 14-29.
448        Pennsylvania    125407  3641    129048
Jurisdiction=Pennsylvania ConfirmedCases=. ProbableCases=129048 TotalCases=. _ERROR_=1 _N_=5
NOTE: Invalid data for ConfirmedCases in line 449 14-29.
449        Virginia    108767  4863    113630
Jurisdiction=Virginia    1 ConfirmedCases=. ProbableCases=13630 TotalCases=. _ERROR_=1 _N_=6
NOTE: Invalid data for ConfirmedCases in line 450 14-29.
450        West Virginia   9097    175 9272
Jurisdiction=West Virginia ConfirmedCases=. ProbableCases=272 TotalCases=. _ERROR_=1 _N_=7
NOTE: The data set WORK.COLUMNINPUT has 7 observations and 4 variables.
NOTE: DATA statement used (Total process time):
      real time           0.04 seconds
      cpu time            0.01 seconds


451  ;
452  proc print data=ColumnInput;
453      title 'Number of Cases per Jurisdiction';
454  run;

NOTE: There were 7 observations read from the data set WORK.COLUMNINPUT.
NOTE: PROCEDURE PRINT used (Total process time):
      real time           0.02 seconds
      cpu time            0.01 seconds


455  data ListInput;
456      length Jurisdiction $ 14
457      input Jurisdiction Confirmed Cases Probable Cases Total Cases;
                                                                      -
                                                                      22
1    1
     -
     352
ERROR 22-322: Expecting a numeric constant.

ERROR 352-185: The length of numeric variables is 3-8.

458      datalines;
ERROR: Numeric length cannot be used with character variable Jurisdiction.

NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.LISTINPUT may be incomplete.  When this step was stopped there were 0 observations and 6 variables.
WARNING: Data set WORK.LISTINPUT was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
      real time           0.03 seconds
      cpu time            0.03 seconds

466  ;


467  proc print data=ListInput
468  run;
     ---
     22
     202
ERROR 22-322: Syntax error, expecting one of the following: ;, (, BLANKLINE, CONTENTS, DATA, DOUBLE, GRANDTOTAL_LABEL, GRANDTOT_LABEL,
              GRAND_LABEL, GTOTAL_LABEL, GTOT_LABEL, HEADING, LABEL, N, NOOBS, NOSUMLABEL, OBS, ROUND, ROWS, SPLIT, STYLE, SUMLABEL,
              UNIFORM, WIDTH.

ERROR 202-322: The option or parameter is not recognized and will be ignored.


NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE PRINT used (Total process time):
      real time           3:26.77
      cpu time            6.49 seconds



469  data FormatInput;
470      input Jurisdiction $14 Confirmed Cases 6. Probable Cases 6. Total Cases 6.;
471      datalines;

NOTE: Invalid data for Total in line 473 1-10.
NOTE: Invalid data for Cases in line 473 12-17.
RULE:      ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0
473        Washington DC   .   .   13590
Jurisdiction=5 Confirmed=930 Cases=. Probable=16942 Total=. _ERROR_=1 _N_=1
NOTE: Invalid data for Total in line 475 1-3.
NOTE: Invalid data for Cases in line 475 5-10.
475        New Jersey  .   .   189494
Jurisdiction=  Confirmed=. Cases=. Probable=69 Total=. _ERROR_=1 _N_=2
NOTE: Invalid data for Total in line 477 1-8.
477        Virginia    108767  4863    113630
Jurisdiction=  Confirmed=125407 Cases=108 Probable=129048 Total=. _ERROR_=1 _N_=3
NOTE: LOST CARD.
479        ;
Jurisdiction=  Confirmed=9097 Cases=. Probable=9272 Total=. _ERROR_=1 _N_=4
NOTE: SAS went to a new line when INPUT statement reached past the end of a line.
NOTE: The data set WORK.FORMATINPUT has 3 observations and 5 variables.
NOTE: DATA statement used (Total process time):
      real time           0.04 seconds
      cpu time            0.01 seconds


479  ;
480  proc print data=FormatInput
481  run;
     ---
     22
     202
ERROR 22-322: Syntax error, expecting one of the following: ;, (, BLANKLINE, CONTENTS, DATA, DOUBLE, GRANDTOTAL_LABEL, GRANDTOT_LABEL,
              GRAND_LABEL, GTOTAL_LABEL, GTOT_LABEL, HEADING, LABEL, N, NOOBS, NOSUMLABEL, OBS, ROUND, ROWS, SPLIT, STYLE, SUMLABEL,
              UNIFORM, WIDTH.

ERROR 202-322: The option or parameter is not recognized and will be ignored.


NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE PRINT used (Total process time):
      real time           3:48.55
      cpu time            10.59 seconds



482  data ColumnInput;
483      infile cards;
484      input Jurisdiction $ Confirmed_Cases Probable_Cases Total_Cases;
485      datalines;

NOTE: Invalid data for Confirmed_Cases in line 487 12-20.
NOTE: Invalid data for Probable_Cases in line 488 1-16.
NOTE: Invalid data for Total_Cases in line 489 1-3.
RULE:      ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0
489        New Jersey..189494
NOTE: Invalid data errors for file CARDS occurred outside the printed range.
NOTE: Increase available buffer lines with the INFILE n= option.
Jurisdiction=Washingt Confirmed_Cases=. Probable_Cases=. Total_Cases=. _ERROR_=1 _N_=2
NOTE: Invalid data for Confirmed_Cases in line 492 6-13.
492        West Virginia   9097    175 9272
Jurisdiction=West Confirmed_Cases=. Probable_Cases=9097 Total_Cases=175 _ERROR_=1 _N_=5
NOTE: SAS went to a new line when INPUT statement reached past the end of a line.
NOTE: The data set WORK.COLUMNINPUT has 5 observations and 4 variables.
NOTE: DATA statement used (Total process time):
      real time           0.04 seconds
      cpu time            0.03 seconds


493  ;
494  proc print data=FormatInput'
495  run;
496  data ColumnInput;
497      infile cards;
498      input Jurisdiction $ Confirmed_Cases Probable_Cases Total_Cases;
499      datalines;
500  Delaware    15930   1012    16942
NOTE: The quoted string currently being processed has become more than 262 bytes long.  You might have unbalanced quotation marks.
501  Washington_DC..13590
502  Maryland..104669
503  New_Jersey..189494
504  Pennsylvania    125407  3641    129048
505  Virginia    108767  4863    113630
506  West_Virginia   9097    175 9272
507  ;
508  proc print data=FormatInput
509  run;
510  data ColumnInput;
511      infile datalines;
512      input Jurisdiction $ Confirmed_Cases Probable_Cases Total_Cases;
513      datalines;
514  Cases 49-60
515  Delaware    15930   1012    16942
516  Washington_DC..13590
517  Maryland..104669
518  New_Jersey..189494
519  Pennsylvania    125407  3641    129048
520  Virginia    108767  4863    113630
521  West_Virginia   9097    175 9272
522  ;
523  proc print data=FormatInput
524  run;
525  data ColumnInput;
526      infile datalines;
527      input Jurisdiction $ Confirmed_Cases Probable_Cases Total_Cases;
528      datalines;
529  Cases 49-60
530  Delaware    15930   1012    16942
531  Washington_DC..13590
532  Maryland..104669
533  New_Jersey..189494
534  Pennsylvania    125407  3641    129048
535  Virginia    108767  4863    113630
536  West_Virginia   9097    175 9272
537  ;
538  proc print data=FormatInput;
539  run;
540  data ColumnInput;
541      infile datalines;
542      input Jurisdiction $ Confirmed_Cases Probable_Cases Total_Cases;
543      datalines;
544  Cases 49-60
545  Delaware    15930   1012    16942
546  Washington_DC..13590
547  Maryland..104669
548  New_Jersey..189494
549  Pennsylvania    125407  3641    129048
550  Virginia    108767  4863    113630
551  West_Virginia   9097    175 9272
552  ;
553  proc print data=ColumnInput;
554  run;
555  data ColumnInput;
556      infile datalines;
557      input Jurisdiction $ Confirmed_Cases Probable_Cases Total_Cases;
558      datalines;
559  Cases 49-60
560  Delaware    15930   1012    16942
561  Washington_DC..13590
562  Maryland..104669
563  New_Jersey..189494
564  Pennsylvania    125407  3641    129048
565  Virginia    108767  4863    113630
566  West_Virginia   9097    175 9272
567  ;
568  proc print data=ColumnInput;
569  run;
570  data ColumnInput;
571      infile datalines;
572      input Jurisdiction $ Confirmed_Cases Probable_Cases Total_Cases;
573      datalines;
574  Delaware    15930   1012    16942
575  Washington_DC..13590
576  Maryland..104669
577  New_Jersey..189494
578  Pennsylvania    125407  3641    129048
579  Virginia    108767  4863    113630
580  West_Virginia   9097    175 9272
581  ;
582  proc print data=ColumnInput;
583  run;
584  data ListInput;
585      infile datalines;
586      input Jurisdiction $ Confirmed_Cases Probable_Cases Total_Cases;
587      datalines;
588  Delaware    15930   1012    16942
589  Washington_DC..13590
590  Maryland..104669
591  New_Jersey..189494
592  Pennsylvania    125407  3641    129048
593  Virginia    108767  4863    113630
594  West_Virginia   9097    175 9272
595  ;
596  proc print data=ListInput;
597  run;
598  data ListInput;
599      infile datalines;
600      input Jurisdiction $ Confirmed_Cases Probable_Cases Total_Cases;
601      datalines;
602  Delaware    15930   1012    16942
603  Washington_DC . . 13590
604  Maryland . . 104669
605  New_Jersey . . 189494
606  Pennsylvania 125407 3641    129048
607  Virginia    108767  4863    113630
608  West_Virginia   9097    175 9272
609  ;
610  proc print data=ListInput;
611  run;
612  data ColumnInput;
613      infile datalines;
614      input Jurisdiction $1-13 Confirmed_Cases Probable_Cases Total_Cases;
615      datalines;
616  Delaware    15930   1012    16942
617  Washington_DC . . 13590
618  Maryland . . 104669
619  New_Jersey . . 189494
620  Pennsylvania 125407 3641    129048
621  Virginia    108767  4863    113630
622  West_Virginia   9097    175 9272
623  ;
624  run;
625  data ColumnInput;
626      infile datalines;
627      length Jurisdiction $13 Confirmed_Cases 6 Probable_Cases 5 Total_Cases 6;
628      input Jurisdiction $1-13 Confirmed_Cases Probable_Cases Total_Cases;
629      datalines;
630  Delaware    15930   1012    16942
631  Washington_DC . . 13590
632  Maryland . . 104669
633  New_Jersey . . 189494
634  Pennsylvania 125407 3641    129048
635  Virginia    108767  4863    113630
636  West_Virginia   9097    175 9272
637  ;
638  run;
639  data ColumnInput;
640      infile datalines;
641      length Jurisdiction $13 Confirmed_Cases 6 Probable_Cases 5 Total_Cases 6;
642      input Jurisdiction $1-13 Confirmed_Cases Probable_Cases Total_Cases;
643      datalines;
644  Delaware    15930   1012    16942
645  Washington_DC . . 13590
646  Maryland . . 104669
647  New_Jersey . . 189494
648  Pennsylvania 125407 3641    129048
649  Virginia    108767  4863    113630
650  West_Virginia   9097    175 9272
651  ;
652  proc print data=work.columninput;
653  run;
654  data ColumnInput;
655      infile datalines;
656      length Jurisdiction $13 Confirmed_Cases 6 Probable_Cases 5 Total_Cases 6;
657      input Jurisdiction $1-13 Confirmed_Cases Probable_Cases Total_Cases;
658      datalines;
659  Delaware    15930   1012    16942
660  Washington_DC . . 13590
661  Maryland . . 104669
662  New_Jersey . . 189494
663  Pennsylvania 125407 3641    129048
664  Virginia    108767  4863    113630
665  West_Virginia   9097    175 9272
666  ;
667  proc print data=work.columninput noobs label;
668  run;
669  data ColumnInput;
670      infile datalines;
671      length Jurisdiction $13 Confirmed_Cases 6 Probable_Cases 5 Total_Cases 6;
672      length Washington_DC $13
673      input Jurisdiction $1-13 Confirmed_Cases Probable_Cases Total_Cases;
674      datalines;
675  Delaware    15930   1012    16942
676  Washington_DC . . 13590
677  Maryland . . 104669
678  New_Jersey . . 189494
679  Pennsylvania 125407 3641    129048
680  Virginia    108767  4863    113630
681  West_Virginia   9097    175 9272
682  ;
683  proc print data=work.columninput noobs label;
684  run;
685  data ColumnInput;
686      infile datalines;
687      length Jurisdiction $13 Confirmed_Cases 6 Probable_Cases 5 Total_Cases 6;
688      length Washington_DC $13
689      input Jurisdiction $1-13 Confirmed_Cases Probable_Cases Total_Cases;
690      datalines;
691  Delaware    15930   1012    16942
692  Washington_DC . . 13590
693  Maryland . . 104669
694  New_Jersey . . 189494
695  Pennsylvania 125407 3641    129048
696  Virginia    108767  4863    113630
697  West_Virginia   9097    175 9272
698  ;
699  proc print data=work.columninput noobs label;
700  run;
701  data ColumnInput;
702      infile datalines;
703      length Jurisdiction : $13. Confirmed_Cases : 6. Probable_Cases : 5. Total_Cases : 6.;
704      input Jurisdiction $1-13 Confirmed_Cases Probable_Cases Total_Cases;
705      datalines;
706  Delaware    15930   1012    16942
707  Washington_DC . . 13590
708  Maryland . . 104669
709  New_Jersey . . 189494
710  Pennsylvania 125407 3641    129048
711  Virginia    108767  4863    113630
712  West_Virginia   9097    175 9272
713  ;
714  proc print data=work.columninput noobs label;
715  run;
716  data ColumnInput;
717      infile datalines;
718      length Jurisdiction $13 Confirmed_Cases 6 Probable_Cases 5 Total_Cases 6;
719      input Jurisdiction : $1-13. Confirmed_Cases Probable_Cases Total_Cases;
720      datalines;
721  Delaware    15930   1012    16942
722  Washington_DC . . 13590
723  Maryland . . 104669
724  New_Jersey . . 189494
725  Pennsylvania 125407 3641    129048
726  Virginia    108767  4863    113630
727  West_Virginia   9097    175 9272
728  ;
729  proc print data=work.columninput noobs label;
730  run;
731  data ColumnInput;
732      infile datalines;
733      length Jurisdiction $13 Confirmed_Cases 6 Probable_Cases 5 Total_Cases 6;
734      input Jurisdiction : $13. Confirmed_Cases Probable_Cases Total_Cases;
735      datalines;
736  Delaware    15930   1012    16942
737  Washington_DC . . 13590
738  Maryland . . 104669
739  New_Jersey . . 189494
740  Pennsylvania 125407 3641    129048
741  Virginia    108767  4863    113630
742  West_Virginia   9097    175 9272
743  ;
744  proc print data=work.columninput noobs label;
745  run;
746  data ColumnInput;
747      infile datalines;
748      length Jurisdiction $13 Confirmed_Cases 6 Probable_Cases 5 Total_Cases 6;
749      informat Jurisdiction $13.;
750      input Jurisdiction : $13. Confirmed_Cases Probable_Cases Total_Cases;
751      datalines;
752  Delaware    15930   1012    16942
753  Washington_DC . . 13590
754  Maryland . . 104669
755  New_Jersey . . 189494
756  Pennsylvania 125407 3641    129048
757  Virginia    108767  4863    113630
758  West_Virginia   9097    175 9272
759  ;
760  proc print data=work.columninput noobs label;
761  run;
762  data ColumnInput;
763      infile datalines;
764      informat Jurisdiction $13.;
765      input Jurisdiction : $13. Confirmed_Cases Probable_Cases Total_Cases;
766      datalines;
767  Delaware    15930   1012    16942
768  Washington_DC . . 13590
769  Maryland . . 104669
770  New_Jersey . . 189494
771  Pennsylvania 125407 3641    129048
772  Virginia    108767  4863    113630
773  West_Virginia   9097    175 9272
774  ;
775  proc print data=work.columninput noobs label;
776  run;
777  data ColumnInput;
778      infile datalines;
779      length Jurisdiction $20 Confirmed_Cases 6 Probable_Cases 5 Total_Cases 6;
780      informat Jurisdiction $20.
781      input Jurisdiction : $20. Confirmed_Cases Probable_Cases Total_Cases;
782      datalines;
783  Delaware    15930   1012    16942
784  Washington_DC . . 13590
785  Maryland . . 104669
786  New_Jersey . . 189494
787  Pennsylvania 125407 3641    129048
788  Virginia    108767  4863    113630
789  West_Virginia   9097    175 9272
790  ;
791  proc print data=work.columninput noobs label;
792  run;
793  data ColumnInput;
794      infile datalines;
795      length Jurisdiction $20 Confirmed_Cases 6 Probable_Cases 5 Total_Cases 6;
796      informat Jurisdiction $20.;
797      input Jurisdiction : $20. Confirmed_Cases Probable_Cases Total_Cases;
798      datalines;
799  Delaware    15930   1012    16942
800  Washington_DC . . 13590
801  Maryland . . 104669
802  New_Jersey . . 189494
803  Pennsylvania 125407 3641    129048
804  Virginia    108767  4863    113630
805  West_Virginia   9097    175 9272
806  ;
807  proc print data=work.columninput noobs label;
808  run;


data ColumnInput; infile datalines; length Jurisdiction $20 Confirmed_Cases 6 Probable_Cases 5 Total_Cases 6; informat Jurisdiction $20.; input Jurisdiction : $20. Confirmed_Cases Probable_Cases Total_Cases; datalines; Delaware 15930 1012 16942 Washington_DC . . 13590 Maryland . . 104669 New_Jersey . . 189494 Pennsylvania 125407 3641 129048 Virginia 108767 4863 113630 West_Virginia 9097 175 9272

ballardw · Posted 09-16-2020 06:14 PM

Lets start with the first case:

172  data NewData;
173      length Name $ 16;
174      input Jurisdiction $ ConfirmedCases ProbableCases TotalCases;
175      datalines;

NOTE: Variable Name is uninitialized.
NOTE: Invalid data for ConfirmedCases in line 176 17-25.
NOTE: Invalid data for ProbableCases in line 176 27-31.
NOTE: Invalid data for TotalCases in line 176 33-40.
RULE:      ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0
176        Jurisdiction    Confirmed Cases Probable Cases  Total Cases
Name=  Jurisdiction=Jurisdic ConfirmedCases=. ProbableCases=. TotalCases=. _ERROR_=1 _N_=1
NOTE: Invalid data for ConfirmedCases in line 177 13-18.
NOTE: Invalid data for ProbableCases in line 177 21-25.
NOTE: Invalid data for TotalCases in line 177 29-34.
177        Delaware    15,930  1,012   16,942
Name=  Jurisdiction=Delaware ConfirmedCases=. ProbableCases=. TotalCases=. _ERROR_=1 _N_=2

To get the RED line of data you placed the variable names in the data lines. So when you try to read the numeric ConfirmedCases variable the text "Confirmed" is read as numeric, and ERRORS.

Note that you value for Jurisdiction has been truncate to 8 characters. That is the result of using a simple $ informat on the input statement. This will only read 8 characters.

The BLUE line has numbers with commas in them. Since the comma can have several different meanings in numeric values you have to tell SAS by using a proper INFORMAT that will read them. I suspect that COMMA12. would work but I don't know the range of your values.

So for this bit you might have your input statement look something like:

input Jurisdiction :$15. ConfirmedCases :Comma12. ProbableCases  :Comma12. TotalCases  :Comma12.;

But you likely have yet another issue lurking: State names with embedded spaces like New York or North Carolina. The list input statement you are using will read each space separate value as the next variable. So "York" would attempt to be read into Confirmed Cases.

At which point the actual structure of the text becomes pretty critical for reading properly.

This one

259  data ListInput;
260      length Jurisdiction $ 14
261      input Jurisdiction $ Confirmed Cases Probable Cases Total Cases;

The Length statement is missing a ; to end it so there are lots of problems following. Regardless of the assigned length an Input like Jurisdication $ still only reads 8 characters. The spaces in the variable names mean that read the variable "Cases" 3 times and almost certainly never actually match the layout.

494  proc print data=FormatInput'
495  run;
496  data ColumnInput;
497      infile cards;
498      input Jurisdiction $ Confirmed_Cases Probable_Cases Total_Cases;
499      datalines;

The PROC PRINT ends with quote symbol, not a semicolon. From that point SAS expects a matching quote to close the first one. So none of the code from that point on runs at all because the quote and appropriate statements were not found at all. Depending what else you may have done you may have some fun getting SAS to recognize submitted code for awhile and may have to save your code and restart the SAS session.

SAS Innovate 2025: Save the Date