Happy new year.
I would appreciate if someone helps me with the SAS code to read the following 29 records correctly.
73 data env;
74 input id$ job idchem lung;
75 datalines;
NOTE: Invalid data for idchem in line 76 16-17.
NOTE: Invalid data for lung in line 76 19-22.
RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0
76 OSa06 3210701 Ca cont
id=OSa06 job=3210701 idchem=. lung=. _ERROR_=1 _N_=1
NOTE: Invalid data for job in line 77 7-14.
NOTE: Invalid data for idchem in line 77 16-17.
NOTE: Invalid data for lung in line 77 19-22.
77 CHAR OSa13 1.210701 Ca case
ZONE 45633230333333246266762222222222222222222222222222222222222222222222222222222222
NUMR F3113019210701031031350000000000000000000000000000000000000000000000000000000000
id=OSa13 job=. idchem=. lung=. _ERROR_=1 _N_=2
NOTE: Invalid data for job in line 78 7-14.
NOTE: Invalid data for idchem in line 78 16-17.
NOTE: Invalid data for lung in line 78 19-22.
78 CHAR OSa13 1.990021 Ca case
ZONE 45633230333333246266762222222222222222222222222222222222222222222222222222222222
NUMR F3113019990021031031350000000000000000000000000000000000000000000000000000000000
id=OSa13 job=. idchem=. lung=. _ERROR_=1 _N_=3
NOTE: Invalid data for job in line 79 7-14.
NOTE: Invalid data for idchem in line 79 16-17.
NOTE: Invalid data for lung in line 79 19-22.
79 CHAR OSa13 3.210701 Ca case
ZONE 45633230333333246266762222222222222222222222222222222222222222222222222222222222
NUMR F3113039210701031031350000000000000000000000000000000000000000000000000000000000
id=OSa13 job=. idchem=. lung=. _ERROR_=1 _N_=4
NOTE: Invalid data for job in line 80 7-14.
NOTE: Invalid data for idchem in line 80 16-17.
NOTE: Invalid data for lung in line 80 19-22.
80 CHAR OSa13 3.990005 Ca case
ZONE 45633230333333246266762222222222222222222222222222222222222222222222222222222222
NUMR F3113039990005031031350000000000000000000000000000000000000000000000000000000000
id=OSa13 job=. idchem=. lung=. _ERROR_=1 _N_=5
NOTE: Invalid data for job in line 81 7-14.
NOTE: Invalid data for idchem in line 81 16-17.
NOTE: Invalid data for lung in line 81 19-22.
81 CHAR OSa13 3.990021 Ca case
ZONE 45633230333333246266762222222222222222222222222222222222222222222222222222222222
NUMR F3113039990021031031350000000000000000000000000000000000000000000000000000000000
id=OSa13 job=. idchem=. lung=. _ERROR_=1 _N_=6
NOTE: Invalid data for job in line 82 7-14.
NOTE: Invalid data for idchem in line 82 16-17.
NOTE: Invalid data for lung in line 82 19-22.
RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0
82 CHAR OSa29 2.990005 Ca cont
ZONE 45633230333333246266672222222222222222222222222222222222222222222222222222222222
NUMR F312902999000503103FE40000000000000000000000000000000000000000000000000000000000
id=OSa29 job=. idchem=. lung=. _ERROR_=1 _N_=7
NOTE: Invalid data for job in line 83 7-14.
NOTE: Invalid data for idchem in line 83 16-17.
NOTE: Invalid data for lung in line 83 19-22.
83 CHAR OSa29 4.210701 Ca cont
ZONE 45633230333333246266672222222222222222222222222222222222222222222222222222222222
NUMR F312904921070103103FE40000000000000000000000000000000000000000000000000000000000
id=OSa29 job=. idchem=. lung=. _ERROR_=1 _N_=8
NOTE: Invalid data for job in line 84 7-14.
NOTE: Invalid data for idchem in line 84 16-17.
NOTE: Invalid data for lung in line 84 19-22.
84 CHAR OSa29 4.990021 Ca cont
ZONE 45633230333333246266672222222222222222222222222222222222222222222222222222222222
NUMR F312904999002103103FE40000000000000000000000000000000000000000000000000000000000
id=OSa29 job=. idchem=. lung=. _ERROR_=1 _N_=9
NOTE: Invalid data for job in line 85 7-14.
NOTE: Invalid data for idchem in line 85 16-17.
NOTE: Invalid data for lung in line 85 19-22.
85 CHAR OSa30 1.990021 Ca case
ZONE 45633230333333246266762222222222222222222222222222222222222222222222222222222222
NUMR F3130019990021031031350000000000000000000000000000000000000000000000000000000000
id=OSa30 job=. idchem=. lung=. _ERROR_=1 _N_=10
NOTE: Invalid data for job in line 86 7-14.
NOTE: Invalid data for idchem in line 86 16-17.
NOTE: Invalid data for lung in line 86 19-22.
86 CHAR OSa30 3.210701 Ca case
ZONE 45633230333333246266762222222222222222222222222222222222222222222222222222222222
NUMR F3130039210701031031350000000000000000000000000000000000000000000000000000000000
id=OSa30 job=. idchem=. lung=. _ERROR_=1 _N_=11
NOTE: Invalid data for job in line 87 7-14.
NOTE: Invalid data for idchem in line 87 16-17.
NOTE: Invalid data for lung in line 87 19-22.
87 CHAR OSa30 3.990005 Ca case
ZONE 45633230333333246266762222222222222222222222222222222222222222222222222222222222
NUMR F3130039990005031031350000000000000000000000000000000000000000000000000000000000
id=OSa30 job=. idchem=. lung=. _ERROR_=1 _N_=12
NOTE: Invalid data for job in line 88 7-14.
NOTE: Invalid data for idchem in line 88 16-17.
NOTE: Invalid data for lung in line 88 19-22.
88 CHAR OSa30 3.990021 Ca case
ZONE 45633230333333246266762222222222222222222222222222222222222222222222222222222222
NUMR F3130039990021031031350000000000000000000000000000000000000000000000000000000000
id=OSa30 job=. idchem=. lung=. _ERROR_=1 _N_=13
NOTE: Invalid data for job in line 89 7-14.
NOTE: Invalid data for idchem in line 89 16-18.
NOTE: Invalid data for lung in line 89 20-23.
RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0
89 CHAR OSa54 3.210701 Pop cont
ZONE 45633230333333256726667222222222222222222222222222222222222222222222222222222222
NUMR F315403921070100F003FE4000000000000000000000000000000000000000000000000000000000
id=OSa54 job=. idchem=. lung=. _ERROR_=1 _N_=14
NOTE: Invalid data for job in line 90 7-14.
NOTE: Invalid data for idchem in line 90 16-18.
NOTE: Invalid data for lung in line 90 20-23.
90 CHAR OSa73 3.990005 Pop cont
ZONE 45633230333333256726667222222222222222222222222222222222222222222222222222222222
NUMR F317303999000500F003FE4000000000000000000000000000000000000000000000000000000000
id=OSa73 job=. idchem=. lung=. _ERROR_=1 _N_=15
NOTE: Invalid data for job in line 91 7-14.
NOTE: Invalid data for idchem in line 91 16-17.
NOTE: Invalid data for lung in line 91 19-22.
91 CHAR OSa86 3.990005 Ca cont
ZONE 45633230333333246266672222222222222222222222222222222222222222222222222222222222
NUMR F318603999000503103FE40000000000000000000000000000000000000000000000000000000000
id=OSa86 job=. idchem=. lung=. _ERROR_=1 _N_=16
NOTE: Invalid data for job in line 92 7-14.
NOTE: Invalid data for idchem in line 92 16-18.
NOTE: Invalid data for lung in line 92 20-23.
92 CHAR OSa93 3.210701 Pop cont
ZONE 45633230333333256726667222222222222222222222222222222222222222222222222222222222
NUMR F319303921070100F003FE4000000000000000000000000000000000000000000000000000000000
id=OSa93 job=. idchem=. lung=. _ERROR_=1 _N_=17
NOTE: Invalid data for job in line 93 7-14.
NOTE: Invalid data for idchem in line 93 16-18.
NOTE: Invalid data for lung in line 93 20-23.
93 CHAR OSa93 3.990005 Pop cont
ZONE 45633230333333256726667222222222222222222222222222222222222222222222222222222222
NUMR F319303999000500F003FE4000000000000000000000000000000000000000000000000000000000
id=OSa93 job=. idchem=. lung=. _ERROR_=1 _N_=18
NOTE: Invalid data for job in line 94 7-14.
NOTE: Invalid data for idchem in line 94 16-18.
NOTE: Invalid data for lung in line 94 20-23.
94 CHAR OSa93 4.990005 Pop cont
ZONE 45633230333333256726667222222222222222222222222222222222222222222222222222222222
NUMR F319304999000500F003FE4000000000000000000000000000000000000000000000000000000000
id=OSa93 job=. idchem=. lung=. _ERROR_=1 _N_=19
NOTE: Invalid data for job in line 95 7-14.
NOTE: Invalid data for idchem in line 95 16-17.
NOTE: Invalid data for lung in line 95 19-22.
WARNING: Limit set by ERRORS= option reached. Further errors of this type will not be printed.
95 CHAR OSb12 1.210701 Ca cont
ZONE 45633230333333246266672222222222222222222222222222222222222222222222222222222222
NUMR F321201921070103103FE40000000000000000000000000000000000000000000000000000000000
id=OSb12 job=. idchem=. lung=. _ERROR_=1 _N_=20
NOTE: The data set WORK.ENV has 29 observations and 4 variables.
NOTE: DATA statement used (Total process time):
real time 0.02 seconds
cpu time 0.02 seconds
105 ;
106
107
108 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
120
Thanks in advance.
ak.