topic Re: Reading data SAS 1999 -> Now in SAS Procedures

Reading data SAS 1999 -> Now

delsshel — Fri, 03 Apr 2015 16:58:20 GMT

Hi SAS community,

I am working with SAS code that this probably out of date (written circa 2005) using a SAS version from 1999. I am attempting to run some new analyses, but have received several errors, especially ones stating my data is invalid like this one NOTE: Invalid data for Tiger in line 82 1-93. I have pasted a sample of my code below. I appreciate any help you can offer me and I appreciate your patience getting me reacquainted with SAS.

Thanks,

delsshel

Data try;

input Tiger area1 area2 area3 area4 area5

manipu NPS PP pacing loco MT vocal

PP2 pace2 lying sit stand lick

scrat eating gnaw ASD IOT PS PS2

EOW OOS other sniff area6 fight

Enrich time day month feed Day2 Temp

WTR Pop;

biggnaw=gnaw+manipu;

bigIOT=ASD+IOT;

if enrich<19 then enrich=1;

if enrich> 39 and enrich<49 then enrich=40;

if enrich=93 then enrich=40;

if enrich=95 then enrich=40;

if enrich=99 then enrich=30;

if enrich=32 then enrich=30;

if enrich=33 then enrich=30;

if enrich=70 then delete;

if enrich=80 then delete;

if enrich=90 then delete;

if enrich=50 then delete;

if enrich=60 then delete;

cards;

1 0 0 5400 0 0 0 0 0 0 0 0 0 0 0 5400 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 11 2.30 20 6 1 1 83 0 2

2 0 0 0 5400 0 0 0 0 0 0 0 0 0 0 5400 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 11 2.30 20 6 1 1 83 0 2

1 5378.3 0 57.95 0 0 0 0 0 0 50.13 3 5 0 0 5135.16 37.83 89.69 54.64 0 85.24 0 0 0 0 0 0 0 0 0 0 0 11 10.00 20 6 1 1 83 0 2

2 5400 0 0 0 0 0 0 0 0 62.5 0 0 0 0 5371.99 2.47 23.13 98.55 0 0 0 0 0 0 0 0 0 0 0 0 0 11 10.00 20 6 1 1 83 0 2

1 0 0 5400 0 0 0 0 0 0 0 0 0 0 0 5392.81 2.63 4.56 3.9 1.26 0 0 0 41.53 0 0 0 0 0 0 0 0 11 4.00 20 6 1 1 83 0 2

2 0 0 2599.95 2436.16 0 0 0 0 78.77 126.86 0 0 0 1 4717.28 0 19.34 17.03 0 0 0 0 39.66 0 0 0 181.36 0 0 0 0 11 4.00 20 6 1 1 83 0 2

1 4856.25 35.1 212.67 163.11 52.79 1.7 0 0 0 440.84 15 12 0 0 4307.14 51.74 303.25 109.33 3.62 81.03 0 20.87 1287.29 0 0 18.62 0 0 90.18 0 0 30 10.00 21 6 2 2 84 0 3

2 3062.25 0 227.22 219.82 18.34 0 0 0 0 234.32 7 1 0 0 4396.73 80.69 264.79 261.14 0 134.9 0 0 1172.28 0 0 28.34 17.57 3.46 86.45 0 0 30 10.00 21 6 2 2 84 0 3

1 4994.48 0 36.19 37.96 71.89 0 0 0 0 71.89 0 0 0 0 5216.06 16.1 69.15 54.87 4.83 0 0 0 3.41 0 0 14.99 0 0 0 0 0 30 11.30 21 6 2 2 84 0 3

2 4614.52 0 61.78 110.13 612.14 0 0 0 0 190.86 14 1 0 0 5116.53 0 60.24 33 0.82 17.36 0 0 8.51 23.18 0 23.12 0 0 33.34 0 0 30 11.30 21 6 2 2 84 0 3

1 0 0 0 0 5400 0 0 0 0 0 0 0 0 0 5400 0 0 23.57 0 0 0 0 99.63 0 0 0 0 0 0 0 0 30 2.30 21 6 2 2 84 0 3

2 0 0 0 0 5400 0 0 0 0 0 0 0 0 0 5400 0 0 1.16 0 0 0 0 94.69 0 0 0 0 0 0 0 0 30 2.30 21 6 2 2 84 0 3

;

proc sort;

by Enrich;

run;

proc npar1way;

class Enrich;

var IOT;

run;

proc npar1way;

class Enrich;

var ASD;

run;

proc sort;

by Enrich;

run;

proc glm;

class Enrich;

model IOT=Enrich;

means Enrich/duncan;

run;

proc glm;

class Enrich;

model ASD=Enrich;

means Enrich/duncan;

run;

Re: Reading data SAS 1999 -> Now

data_null__ — Fri, 03 Apr 2015 17:13:21 GMT

I copied your entire program and ran it in SAS and got no data errors or errors of any kind.

With regards, to the NOTE: SAS should have also displayed the data line it is referring to: line 82. 1-93 is referring to the columns being read.

Can you show the rest of the log? Related to the data issue.

Re: Reading data SAS 1999 -> Now

Reeza — Fri, 03 Apr 2015 17:35:39 GMT

I don't see anything that would have changed from the SAS version in 1999 to today

Perhaps it's a data import problem instead?

Is your data actually provided via a CARDS statement or an infile?

Re: Reading data SAS 1999 -> Now

Tom — Fri, 03 Apr 2015 17:58:49 GMT

TIGER is the first variable in the INPUT statement. Most likely the spaces are not spaces so that numbers do not look like numbers.

Your program editor probably converted some of the spaces to tabs or possible micro-soft non-breaking spaces ('A0'X).

Re: Reading data SAS 1999 -> Now

delsshel — Fri, 03 Apr 2015 18:06:07 GMT

Hi data_null:

Yes, my log is below. I should add that I am running the code on SAS studio. Thank you for your help with this.

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

58 Data try;

59 input Tiger area1 area2 area3 area4 area5

60 manipu NPS PP pacing loco MT vocal

61 PP2 pace2 lying sit stand lick

62 scrat eating gnaw ASD IOT PS PS2

63 EOW OOS other sniff area6 fight

64 Enrich time day month feed Day2 Temp

65 WTR Pop;

66 biggnaw=gnaw+manipu;

67 bigIOT=ASD+IOT;

68 if enrich<19 then enrich=1;

69 if enrich> 39 and enrich<49 then enrich=40;

70 if enrich=93 then enrich=40;

71 if enrich=95 then enrich=40;

72 if enrich=99 then enrich=30;

73 if enrich=32 then enrich=30;

74 if enrich=33 then enrich=30;

75 if enrich=70 then delete;

76 if enrich=80 then delete;

77 if enrich=90 then delete;

78 if enrich=50 then delete;

79 if enrich=60 then delete;

81 cards;

NOTE: Invalid data for Tiger in line 82 1-93.

NOTE: Invalid data for area1 in line 83 1-93.

NOTE: Invalid data for area2 in line 84 1-123.

NOTE: Invalid data for area3 in line 85 1-111.

NOTE: Invalid data for area4 in line 86 1-111.

NOTE: Invalid data for area5 in line 87 1-131.

NOTE: Invalid data for manipu in line 88 1-165.

NOTE: Invalid data for NPS in line 89 1-158.

NOTE: Invalid data for PP in line 90 1-137.

NOTE: Invalid data for pacing in line 91 1-147.

NOTE: Invalid data for loco in line 92 1-101.

NOTE: Invalid data for MT in line 93 1-100.

NOTE: Invalid data for vocal in line 94 1-147.

NOTE: Invalid data for PP2 in line 95 1-152.

NOTE: Invalid data for pace2 in line 96 1-158.

NOTE: Invalid data for lying in line 97 1-116.

NOTE: Invalid data for sit in line 98 1-109.

NOTE: Invalid data for stand in line 99 1-105.

NOTE: Invalid data for lick in line 100 1-187.

NOTE: Invalid data for scrat in line 101 1-189.

NOTE: Invalid data for eating in line 102 1-125.

NOTE: Invalid data for gnaw in line 103 1-106.

NOTE: Invalid data for ASD in line 104 1-120.

NOTE: Invalid data for IOT in line 105 1-134.

NOTE: Invalid data for PS in line 106 1-139.

NOTE: Invalid data for PS2 in line 107 1-110.

NOTE: Invalid data for EOW in line 108 1-165.

NOTE: Invalid data for OOS in line 109 1-172.

NOTE: Invalid data for other in line 110 1-168.

NOTE: Invalid data for sniff in line 111 1-159.

NOTE: Invalid data for area6 in line 112 1-120.

NOTE: Invalid data for fight in line 113 1-117.

NOTE: Invalid data for Enrich in line 114 1-162.

NOTE: Invalid data for time in line 115 1-147.

NOTE: Invalid data for day in line 116 1-142.

NOTE: Invalid data for month in line 117 1-126.

NOTE: Invalid data for feed in line 118 1-179.

NOTE: Invalid data for Day2 in line 119 1-177.

NOTE: Invalid data for Temp in line 120 1-193.

NOTE: Invalid data for WTR in line 121 1-187.

NOTE: Invalid data for Pop in line 122 1-181.

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

122 CHAR 1.478.08.583.53.1786.77.2656.44.258.38.0.52.62.0.968.28.1630.94.21.0.0.23.2799.7.129.02.236.49.246.4

ZONE 3033323303332330333323303333233033323303033233030333233033332330330303033033332303332330333233033323

NUMR 19478E089583E5391786E7792656E449258E3890952E62909968E2891630E94921909092392799E79129E029236E499246E4

101 5.3.3.17.08.0.0.50.3.0.0.43.51.0.341.78.247.61.1018.26.0.18.2.30.25.6.6.6.84.0.5.

ZONE 3032303323303030332303030332330303332330333233033332330303303233033030303033030302222222222222222222

NUMR 593E3917E089090950E39090943E51909341E789247E6191018E269091892E30925969696984909590000000000000000000

201

NOTE: Invalid data errors for file CARDS occurred outside the printed range.

NOTE: Increase available buffer lines with the INFILE n= option.

Tiger=. area1=. area2=. area3=. area4=. area5=. manipu=. NPS=. PP=. pacing=. loco=. MT=. vocal=. PP2=. pace2=. lying=. sit=. stand=.

lick=. scrat=. eating=. gnaw=. ASD=. IOT=. PS=. PS2=. EOW=. OOS=. other=. sniff=. area6=. fight=. Enrich=1 time=. day=. month=.

feed=. Day2=. Temp=. WTR=. Pop=. biggnaw=. bigIOT=. _ERROR_=1 _N_=1

NOTE: Invalid data for Tiger in line 123 1-166.

NOTE: Invalid data for area1 in line 124 1-108.

NOTE: Invalid data for area2 in line 125 1-124.

NOTE: Invalid data for area3 in line 126 1-138.

NOTE: Invalid data for area4 in line 127 1-158.

NOTE: Invalid data for area5 in line 128 1-160.

NOTE: Invalid data for manipu in line 129 1-119.

NOTE: Invalid data for NPS in line 130 1-154.

NOTE: Invalid data for PP in line 131 1-102.

NOTE: Invalid data for pacing in line 132 1-183.

NOTE: Invalid data for loco in line 133 1-156.

NOTE: Invalid data for MT in line 134 1-169.

NOTE: Invalid data for vocal in line 135 1-164.

NOTE: Invalid data for PP2 in line 136 1-127.

NOTE: Invalid data for pace2 in line 137 1-105.

NOTE: Invalid data for lying in line 138 1-139.

NOTE: Invalid data for sit in line 139 1-131.

NOTE: Invalid data for stand in line 140 1-119.

NOTE: Invalid data for lick in line 141 1-101.

NOTE: Invalid data for scrat in line 142 1-151.

NOTE: Invalid data for eating in line 143 1-149.

NOTE: Invalid data for gnaw in line 144 1-165.

NOTE: Invalid data for ASD in line 145 1-147.

NOTE: Invalid data for IOT in line 146 1-138.

NOTE: Invalid data for PS in line 147 1-114.

NOTE: Invalid data for PS2 in line 148 1-186.

NOTE: Invalid data for EOW in line 149 1-192.

NOTE: Invalid data for OOS in line 150 1-157.

NOTE: Invalid data for other in line 151 1-152.

NOTE: Invalid data for sniff in line 152 1-161.

NOTE: Invalid data for area6 in line 153 1-143.

NOTE: Invalid data for fight in line 154 1-177.

NOTE: Invalid data for Enrich in line 155 1-177.

NOTE: Invalid data for time in line 156 1-170.

NOTE: Invalid data for day in line 157 1-173.

NOTE: Invalid data for month in line 158 1-169.

NOTE: Invalid data for feed in line 159 1-167.

NOTE: Invalid data for Day2 in line 160 1-174.

NOTE: Invalid data for Temp in line 161 1-153.

NOTE: Invalid data for WTR in line 162 1-179.

NOTE: Invalid data for Pop in line 163 1-175.

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

163 CHAR 2.323.34.609.95.815.05.3509.13.190.1.64.87.294.89.165.76.0.1298.69.15.21.1.0.3233.78.95.4.305.28.189

ZONE 3033323303332330333233033332330333230332330333233033323303033332330330330303033332330332303332330333

NUMR 29323E349609E959815E0593509E139190E1964E879294E899165E769091298E69915921919093233E78995E49305E289189

101 .16.0.1.42.0.6.81.44.06.3.02.1.0.0.0.114.86.6.26.0.99.4.00.30.6.4.11.87.0.3

ZONE 2330303233030323303323303233030303030333233032330303303233033030303303303032222222222222222222222222

NUMR E169091E429096E81944E0693E02919090909114E8696E269099994E00930969491198790930000000000000000000000000

201

NOTE: Invalid data errors for file CARDS occurred outside the printed range.

NOTE: Increase available buffer lines with the INFILE n= option.

Tiger=. area1=. area2=. area3=. area4=. area5=. manipu=. NPS=. PP=. pacing=. loco=. MT=. vocal=. PP2=. pace2=. lying=. sit=. stand=.

lick=. scrat=. eating=. gnaw=. ASD=. IOT=. PS=. PS2=. EOW=. OOS=. other=. sniff=. area6=. fight=. Enrich=1 time=. day=. month=.

feed=. Day2=. Temp=. WTR=. Pop=. biggnaw=. bigIOT=. _ERROR_=1 _N_=2

NOTE: Invalid data for Tiger in line 164 1-158.

NOTE: Invalid data for area1 in line 165 1-169.

NOTE: Invalid data for area2 in line 166 1-151.

NOTE: Invalid data for area3 in line 167 1-129.

NOTE: Invalid data for area4 in line 168 1-119.

NOTE: Invalid data for area5 in line 169 1-130.

NOTE: Invalid data for manipu in line 170 1-178.

NOTE: Invalid data for NPS in line 171 1-122.

NOTE: Invalid data for PP in line 172 1-141.

NOTE: Invalid data for pacing in line 173 1-129.

NOTE: Invalid data for loco in line 174 1-172.

NOTE: Invalid data for MT in line 175 1-145.

NOTE: Invalid data for vocal in line 176 1-113.

NOTE: Invalid data for PP2 in line 177 1-93.

NOTE: Invalid data for pace2 in line 178 1-171.

NOTE: Invalid data for lying in line 179 1-165.

NOTE: Invalid data for sit in line 180 1-189.

NOTE: Invalid data for stand in line 181 1-183.

NOTE: Invalid data for lick in line 182 1-158.

NOTE: Invalid data for scrat in line 183 1-148.

NOTE: Invalid data for eating in line 184 1-154.

NOTE: Invalid data for gnaw in line 185 1-97.

NOTE: Invalid data for ASD in line 186 1-153.

NOTE: Invalid data for IOT in line 187 1-134.

NOTE: Invalid data for PS in line 188 1-140.

NOTE: Invalid data for PS2 in line 189 1-151.

NOTE: Invalid data for EOW in line 190 1-98.

NOTE: Invalid data for OOS in line 191 1-97.

NOTE: Invalid data for other in line 192 1-171.

NOTE: Invalid data for sniff in line 193 1-166.

NOTE: Invalid data for area6 in line 194 1-115.

NOTE: Invalid data for fight in line 195 1-139.

NOTE: Invalid data for Enrich in line 196 1-165.

NOTE: Invalid data for time in line 197 1-93.

NOTE: Invalid data for day in line 198 1-159.

NOTE: Invalid data for month in line 199 1-97.

NOTE: Invalid data for feed in line 200 1-178.

NOTE: Invalid data for Day2 in line 201 1-134.

NOTE: Invalid data for Temp in line 202 1-175.

NOTE: Invalid data for WTR in line 203 1-180.

NOTE: Invalid data for Pop in line 204 1-190.

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

204 CHAR 1.1264.8.53.22.2634.44.1150.64.227.17.83.36.0.0.45.36.1055.31.12.12.0.1.3312.73.32.72.634.26.248.39.

ZONE 3033332303323303333233033332330333233033233030303323303333233033033030303333233033233033323303332330

NUMR 191264E8953E2292634E4491150E649227E17983E369090945E3691055E31912912909193312E73932E729634E269248E399

101 4.72.75.07.1308.71.0.92.83.0.0.42.73.156.32.3.19.51.74.863.76.0.20.8.30.6.7.3.17.89.0.02.2

ZONE 3233033233033332330303323303030332330333233032330332330333233030330323303030303303303233032222222222

NUMR 4E72975E0791308E7190992E839090942E739156E3293E19951E749863E769092098E3096979391798990E02920000000000

201

NOTE: Invalid data errors for file CARDS occurred outside the printed range.

NOTE: Increase available buffer lines with the INFILE n= option.

Tiger=. area1=. area2=. area3=. area4=. area5=. manipu=. NPS=. PP=. pacing=. loco=. MT=. vocal=. PP2=. pace2=. lying=. sit=. stand=.

lick=. scrat=. eating=. gnaw=. ASD=. IOT=. PS=. PS2=. EOW=. OOS=. other=. sniff=. area6=. fight=. Enrich=1 time=. day=. month=.

feed=. Day2=. Temp=. WTR=. Pop=. biggnaw=. bigIOT=. _ERROR_=1 _N_=3

NOTE: Invalid data for Tiger in line 205 1-178.

NOTE: Invalid data for area1 in line 206 1-158.

NOTE: Invalid data for area2 in line 207 1-149.

NOTE: Invalid data for area3 in line 208 1-193.

NOTE: Invalid data for area4 in line 209 1-182.

NOTE: Invalid data for area5 in line 210 1-187.

NOTE: Invalid data for manipu in line 211 1-196.

NOTE: Invalid data for NPS in line 212 1-134.

NOTE: Invalid data for PP in line 213 1-100.

NOTE: Invalid data for pacing in line 214 1-113.

NOTE: Invalid data for loco in line 215 1-117.

NOTE: Invalid data for MT in line 216 1-183.

NOTE: Invalid data for vocal in line 217 1-186.

NOTE: Invalid data for PP2 in line 218 1-179.

NOTE: Invalid data for pace2 in line 219 1-166.

NOTE: Invalid data for lying in line 220 1-181.

NOTE: Invalid data for sit in line 221 1-140.

NOTE: Invalid data for stand in line 222 1-100.

NOTE: Invalid data for lick in line 223 1-97.

NOTE: Invalid data for scrat in line 224 1-125.

NOTE: Invalid data for eating in line 225 1-107.

NOTE: Invalid data for gnaw in line 226 1-118.

NOTE: Invalid data for ASD in line 227 1-105.

NOTE: Invalid data for IOT in line 228 1-168.

NOTE: Invalid data for PS in line 229 1-169.

NOTE: Invalid data for PS2 in line 230 1-179.

NOTE: Invalid data for EOW in line 231 1-182.

NOTE: Invalid data for OOS in line 232 1-151.

NOTE: Invalid data for other in line 233 1-146.

NOTE: Invalid data for sniff in line 234 1-161.

NOTE: Invalid data for area6 in line 235 1-162.

NOTE: Invalid data for fight in line 236 1-178.

NOTE: Invalid data for Enrich in line 237 1-153.

NOTE: Invalid data for time in line 238 1-94.

NOTE: Invalid data for day in line 239 1-94.

NOTE: Invalid data for month in line 240 1-167.

NOTE: Invalid data for feed in line 241 1-187.

NOTE: Invalid data for Day2 in line 242 1-167.

NOTE: Invalid data for Temp in line 243 1-172.

NOTE: Invalid data for WTR in line 244 1-106.

NOTE: Invalid data for Pop in line 245 1-95.

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

245 CHAR 2.0.0.5400.0.0.0.0.0.0.0.0.0.0.0.5400.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.20.11.30.24.7.7.34.82.0.5

ZONE 3030303333030303030303030303030303333030303030303030303030303030303030330332330330303033033030322222

NUMR 290909540090909090909090909090909540090909090909090909090909090909090920911E309249797934982909500000

101

201

NOTE: Invalid data errors for file CARDS occurred outside the printed range.

NOTE: Increase available buffer lines with the INFILE n= option.

Tiger=. area1=. area2=. area3=. area4=. area5=. manipu=. NPS=. PP=. pacing=. loco=. MT=. vocal=. PP2=. pace2=. lying=. sit=. stand=.

lick=. scrat=. eating=. gnaw=. ASD=. IOT=. PS=. PS2=. EOW=. OOS=. other=. sniff=. area6=. fight=. Enrich=1 time=. day=. month=.

feed=. Day2=. Temp=. WTR=. Pop=. biggnaw=. bigIOT=. _ERROR_=1 _N_=4

NOTE: Invalid data for Tiger in line 246 1-128.

NOTE: Invalid data for area1 in line 247 1-136.

NOTE: Invalid data for area2 in line 248 1-149.

NOTE: Invalid data for area3 in line 249 1-151.

NOTE: Invalid data for area4 in line 250 1-157.

NOTE: Invalid data for area5 in line 251 1-175.

NOTE: Invalid data for manipu in line 252 1-175.

NOTE: Invalid data for NPS in line 253 1-164.

NOTE: Invalid data for PP in line 254 1-155.

NOTE: Invalid data for pacing in line 255 1-126.

NOTE: Invalid data for loco in line 256 1-146.

NOTE: Invalid data for MT in line 257 1-139.

NOTE: Invalid data for vocal in line 258 1-120.

NOTE: Invalid data for PP2 in line 259 1-110.

NOTE: Invalid data for pace2 in line 260 1-161.

NOTE: Invalid data for lying in line 261 1-149.

NOTE: Invalid data for sit in line 262 1-171.

NOTE: Invalid data for stand in line 263 1-131.

NOTE: Invalid data for lick in line 264 1-162.

NOTE: Invalid data for scrat in line 265 1-107.

NOTE: Invalid data for eating in line 266 1-175.

NOTE: Invalid data for gnaw in line 267 1-168.

NOTE: Invalid data for ASD in line 268 1-126.

NOTE: Invalid data for IOT in line 269 1-112.

NOTE: Invalid data for PS in line 270 1-163.

NOTE: Invalid data for PS2 in line 271 1-148.

NOTE: Invalid data for EOW in line 272 1-101.

NOTE: Invalid data for OOS in line 273 1-98.

NOTE: Invalid data for other in line 274 1-170.

NOTE: Invalid data for sniff in line 275 1-175.

NOTE: Invalid data for area6 in line 276 1-135.

NOTE: Invalid data for fight in line 277 1-141.

NOTE: Invalid data for Enrich in line 278 1-128.

NOTE: Invalid data for time in line 279 1-128.

NOTE: Invalid data for day in line 280 1-168.

NOTE: Invalid data for month in line 281 1-98.

NOTE: Invalid data for feed in line 282 1-171.

NOTE: Invalid data for Day2 in line 283 1-100.

NOTE: Invalid data for Temp in line 284 1-97.

NOTE: Invalid data for WTR in line 285 1-156.

NOTE: Invalid data for Pop in line 286 1-127.

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

286 CHAR 1.0.2.19.24.66.4710.73.0.0.0.0.0.16.92.0.0.0.0.4703.49.0.0.0.0.0.0.0.0.0.0.0.665.81.2.08.0.668.72.0.

ZONE 3030323303323303333233030303030303323303030303033332330303030303030303030303033323303233030333233030

NUMR 19092E19924E6694710E739090909090916E929090909094703E4990909090909090909090909665E8192E08909668E72909

101 20.5.30.20.7.3.30.83.0.28.2

ZONE 3303233033030303303303233032222222222222222222222222222222222222222222222222222222222222222222222222

NUMR 2095E30920979393098390E28920000000000000000000000000000000000000000000000000000000000000000000000000

201

NOTE: Invalid data errors for file CARDS occurred outside the printed range.

NOTE: Increase available buffer lines with the INFILE n= option.

Tiger=. area1=. area2=. area3=. area4=. area5=. manipu=. NPS=. PP=. pacing=. loco=. MT=. vocal=. PP2=. pace2=. lying=. sit=. stand=.

lick=. scrat=. eating=. gnaw=. ASD=. IOT=. PS=. PS2=. EOW=. OOS=. other=. sniff=. area6=. fight=. Enrich=1 time=. day=. month=.

feed=. Day2=. Temp=. WTR=. Pop=. biggnaw=. bigIOT=. _ERROR_=1 _N_=5

NOTE: Invalid data for Tiger in line 287 1-97.

NOTE: Invalid data for area1 in line 288 1-187.

NOTE: Invalid data for area2 in line 289 1-179.

NOTE: Invalid data for area3 in line 290 1-128.

NOTE: Invalid data for area4 in line 291 1-98.

NOTE: Invalid data for area5 in line 292 1-155.

NOTE: Invalid data for manipu in line 293 1-98.

NOTE: Invalid data for NPS in line 294 1-174.

NOTE: Invalid data for PP in line 295 1-152.

NOTE: Invalid data for pacing in line 296 1-162.

NOTE: Invalid data for loco in line 297 1-115.

NOTE: Invalid data for MT in line 298 1-165.

NOTE: Invalid data for vocal in line 299 1-147.

NOTE: Invalid data for PP2 in line 300 1-178.

NOTE: Invalid data for pace2 in line 301 1-150.

NOTE: Invalid data for lying in line 302 1-167.

NOTE: Invalid data for sit in line 303 1-186.

NOTE: Invalid data for stand in line 304 1-134.

NOTE: Invalid data for lick in line 305 1-134.

NOTE: Invalid data for scrat in line 306 1-164.

NOTE: Invalid data for eating in line 307 1-154.

NOTE: Invalid data for gnaw in line 308 1-117.

NOTE: Invalid data for ASD in line 309 1-134.

NOTE: Invalid data for IOT in line 310 1-163.

NOTE: Invalid data for PS in line 311 1-148.

NOTE: Invalid data for PS2 in line 312 1-97.

NOTE: Invalid data for EOW in line 313 1-120.

NOTE: Invalid data for OOS in line 314 1-101.

NOTE: Invalid data for other in line 315 1-103.

NOTE: Invalid data for sniff in line 316 1-180.

NOTE: Invalid data for area6 in line 317 1-149.

NOTE: Invalid data for fight in line 318 1-165.

NOTE: Invalid data for Enrich in line 319 1-162.

NOTE: Invalid data for time in line 320 1-105.

NOTE: Invalid data for day in line 321 1-108.

NOTE: Invalid data for month in line 322 1-156.

NOTE: Invalid data for feed in line 323 1-144.

NOTE: Invalid data for Day2 in line 324 1-101.

NOTE: Invalid data for Temp in line 325 1-98.

NOTE: Invalid data for WTR in line 326 1-161.

NOTE: Invalid data for Pop in line 327 1-128.

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

327 CHAR 2.0.0.20.26.4774.56.0.0.0.0.0.7.31.0.0.0.0.4063.62.711.44.1.97.0.0.0.0.0.0.0.0.0.597.64.0.0.607.31.0

ZONE 3030303323303333233030303030303233030303030333323303332330323303030303030303030303332330303033323303

NUMR 29090920E2694774E56909090909097E319090909094063E629711E4491E979090909090909090909597E6490909607E3190

101 .15.1.00.13.7.3.24.85.0.09.1

ZONE 0330323303303030330330323303222222222222222222222222222222222222222222222222222222222222222222222222

NUMR 91591E00913979392498590E0991000000000000000000000000000000000000000000000000000000000000000000000000

201

NOTE: Invalid data errors for file CARDS occurred outside the printed range.

NOTE: Increase available buffer lines with the INFILE n= option.

Tiger=. area1=. area2=. area3=. area4=. area5=. manipu=. NPS=. PP=. pacing=. loco=. MT=. vocal=. PP2=. pace2=. lying=. sit=. stand=.

lick=. scrat=. eating=. gnaw=. ASD=. IOT=. PS=. PS2=. EOW=. OOS=. other=. sniff=. area6=. fight=. Enrich=1 time=. day=. month=.

feed=. Day2=. Temp=. WTR=. Pop=. biggnaw=. bigIOT=. _ERROR_=1 _N_=6

NOTE: Invalid data for Tiger in line 328 1-161.

NOTE: Invalid data for area1 in line 329 1-131.

NOTE: Invalid data for area2 in line 330 1-100.

NOTE: Invalid data for area3 in line 331 1-97.

NOTE: Invalid data for area4 in line 332 1-143.

NOTE: Invalid data for area5 in line 333 1-96.

NOTE: Invalid data for manipu in line 334 1-170.

NOTE: Invalid data for NPS in line 335 1-169.

NOTE: Invalid data for PP in line 336 1-168.

NOTE: Invalid data for pacing in line 337 1-178.

NOTE: Invalid data for loco in line 338 1-180.

NOTE: Invalid data for MT in line 339 1-180.

NOTE: Invalid data for vocal in line 340 1-152.

NOTE: Invalid data for PP2 in line 341 1-108.

NOTE: Invalid data for pace2 in line 342 1-97.

NOTE: Invalid data for lying in line 343 1-147.

NOTE: Invalid data for sit in line 344 1-163.

NOTE: Invalid data for stand in line 345 1-128.

NOTE: LOST CARD.

346 ;

NOTE: Invalid data errors for file CARDS occurred outside the printed range.

NOTE: Increase available buffer lines with the INFILE n= option.

Tiger=. area1=. area2=. area3=. area4=. area5=. manipu=. NPS=. PP=. pacing=. loco=. MT=. vocal=. PP2=. pace2=. lying=. sit=. stand=.

lick=. scrat=. eating=. gnaw=. ASD=. IOT=. PS=. PS2=. EOW=. OOS=. other=. sniff=. area6=. fight=. Enrich=. time=. day=. month=.

feed=. Day2=. Temp=. WTR=. Pop=. biggnaw=. bigIOT=. _ERROR_=1 _N_=7

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

NOTE: Missing values were generated as a result of performing an operation on missing values.

Each place is given by: (Number of times) at (Line):(Column).

6 at 66:13 6 at 67:11

NOTE: The data set WORK.TRY has 6 observations and 43 variables.

NOTE: DATA statement used (Total process time):

real time 0.10 seconds

user cpu time 0.07 seconds

system cpu time 0.05 seconds

memory 593.71k

OS Memory 23708.00k

Timestamp 04/03/2015 05:59:27 PM

Step Count 7 Switch Count 1391

Page Faults 0

Page Reclaims 255

Page Swaps 0

Voluntary Context Switches 5526

Involuntary Context Switches 310

Block Input Operations 0

Block Output Operations 264

346 ;

347 proc sort;

348 by Enrich;

349 run;

NOTE: There were 6 observations read from the data set WORK.TRY.

NOTE: The data set WORK.TRY has 6 observations and 43 variables.

NOTE: PROCEDURE SORT used (Total process time):

real time 0.00 seconds

user cpu time 0.00 seconds

system cpu time 0.00 seconds

memory 832.75k

OS Memory 24224.00k

Timestamp 04/03/2015 05:59:27 PM

Step Count 8 Switch Count 31

Page Faults 0

Page Reclaims 170

Page Swaps 0

Voluntary Context Switches 70

Involuntary Context Switches 4

Block Input Operations 0

Block Output Operations 272

350 proc npar1way;

351 class Enrich;

352 var IOT;

353 run;

NOTE: No data to analyze.

NOTE: There were 6 observations read from the data set WORK.TRY.

NOTE: PROCEDURE NPAR1WAY used (Total process time):

real time 0.00 seconds

user cpu time 0.00 seconds

system cpu time 0.01 seconds

memory 694.90k

OS Memory 24224.00k

Timestamp 04/03/2015 05:59:27 PM

Step Count 9 Switch Count 34

Page Faults 0

Page Reclaims 474

Page Swaps 0

Voluntary Context Switches 81

Involuntary Context Switches 1

Block Input Operations 0

Block Output Operations 264

354 proc npar1way;

355 class Enrich;

356 var ASD;

357 run;

NOTE: No data to analyze.

NOTE: There were 6 observations read from the data set WORK.TRY.

NOTE: PROCEDURE NPAR1WAY used (Total process time):

real time 0.00 seconds

user cpu time 0.00 seconds

system cpu time 0.00 seconds

memory 687.87k

OS Memory 24224.00k

Timestamp 04/03/2015 05:59:27 PM

Step Count 10 Switch Count 38

Page Faults 0

Page Reclaims 76

Page Swaps 0

Voluntary Context Switches 97

Involuntary Context Switches 0

Block Input Operations 0

Block Output Operations 264

358 proc sort;

359 by Enrich;

360 run;

NOTE: Input data set is already sorted, no sorting done.

NOTE: PROCEDURE SORT used (Total process time):

real time 0.00 seconds

user cpu time 0.00 seconds

system cpu time 0.00 seconds

memory 387.00k

OS Memory 23964.00k

Timestamp 04/03/2015 05:59:27 PM

Step Count 11 Switch Count 28

Page Faults 0

Page Reclaims 38

Page Swaps 0

Voluntary Context Switches 56

Involuntary Context Switches 1

Block Input Operations 0

Block Output Operations 0

361 proc npar1way;

362 class Enrich;

363 var bigIOT;

364 run;

NOTE: No data to analyze.

NOTE: There were 6 observations read from the data set WORK.TRY.

NOTE: PROCEDURE NPAR1WAY used (Total process time):

real time 0.00 seconds

user cpu time 0.00 seconds

system cpu time 0.00 seconds

memory 688.75k

OS Memory 24224.00k

Timestamp 04/03/2015 05:59:27 PM

Step Count 12 Switch Count 34

Page Faults 0

Page Reclaims 74

Page Swaps 0

Voluntary Context Switches 81

Involuntary Context Switches 0

Block Input Operations 0

Block Output Operations 264

365 proc sort;

366 by Enrich;

367 run;

NOTE: Input data set is already sorted, no sorting done.

NOTE: PROCEDURE SORT used (Total process time):

real time 0.00 seconds

user cpu time 0.00 seconds

system cpu time 0.00 seconds

memory 387.00k

OS Memory 23964.00k

Timestamp 04/03/2015 05:59:27 PM

Step Count 13 Switch Count 28

Page Faults 0

Page Reclaims 36

Page Swaps 0

Voluntary Context Switches 56

Involuntary Context Switches 0

Block Input Operations 0

Block Output Operations 0

368 proc npar1way;

369 class Enrich;

370 var PS;

371 run;

NOTE: No data to analyze.

NOTE: There were 6 observations read from the data set WORK.TRY.

NOTE: PROCEDURE NPAR1WAY used (Total process time):

real time 0.00 seconds

user cpu time 0.01 seconds

system cpu time 0.01 seconds

memory 688.75k

OS Memory 24224.00k

Timestamp 04/03/2015 05:59:27 PM

Step Count 14 Switch Count 34

Page Faults 0

Page Reclaims 71

Page Swaps 0

Voluntary Context Switches 81

Involuntary Context Switches 0

Block Input Operations 0

Block Output Operations 264

372 proc npar1way;

373 class Enrich;

374 var fight;

375 run;

NOTE: No data to analyze.

NOTE: There were 6 observations read from the data set WORK.TRY.

NOTE: PROCEDURE NPAR1WAY used (Total process time):

real time 0.00 seconds

user cpu time 0.00 seconds

system cpu time 0.00 seconds

memory 686.75k

OS Memory 24224.00k

Timestamp 04/03/2015 05:59:27 PM

Step Count 15 Switch Count 38

Page Faults 0

Page Reclaims 72

Page Swaps 0

Voluntary Context Switches 98

Involuntary Context Switches 0

Block Input Operations 0

Block Output Operations 264

376 proc npar1way;

377 class Enrich;

378 var pacing;

379 run;

NOTE: No data to analyze.

NOTE: There were 6 observations read from the data set WORK.TRY.

NOTE: PROCEDURE NPAR1WAY used (Total process time):

real time 0.00 seconds

user cpu time 0.00 seconds

system cpu time 0.00 seconds

memory 688.75k

OS Memory 24224.00k

Timestamp 04/03/2015 05:59:27 PM

Step Count 16 Switch Count 34

Page Faults 0

Page Reclaims 71

Page Swaps 0

Voluntary Context Switches 82

Involuntary Context Switches 0

Block Input Operations 0

Block Output Operations 264

380 proc npar1way;

381 class Enrich;

382 var pp;

383 run;

NOTE: No data to analyze.

NOTE: There were 6 observations read from the data set WORK.TRY.

NOTE: PROCEDURE NPAR1WAY used (Total process time):

real time 0.00 seconds

user cpu time 0.00 seconds

system cpu time 0.01 seconds

memory 688.75k

OS Memory 24224.00k

Timestamp 04/03/2015 05:59:27 PM

Step Count 17 Switch Count 34

Page Faults 0

Page Reclaims 71

Page Swaps 0

Voluntary Context Switches 82

Involuntary Context Switches 0

Block Input Operations 0

Block Output Operations 264

384 proc npar1way;

385 class Enrich;

386 var biggnaw;

387 run;

NOTE: No data to analyze.

NOTE: There were 6 observations read from the data set WORK.TRY.

NOTE: PROCEDURE NPAR1WAY used (Total process time):

real time 0.00 seconds

user cpu time 0.01 seconds

system cpu time 0.00 seconds

memory 688.75k

OS Memory 24224.00k

Timestamp 04/03/2015 05:59:27 PM

Step Count 18 Switch Count 34

Page Faults 0

Page Reclaims 72

Page Swaps 0

Voluntary Context Switches 81

Involuntary Context Switches 0

Block Input Operations 0

Block Output Operations 264

388

389 proc sort;

390 by Enrich;

391 run;

NOTE: Input data set is already sorted, no sorting done.

NOTE: PROCEDURE SORT used (Total process time):

real time 0.00 seconds

user cpu time 0.00 seconds

system cpu time 0.00 seconds

memory 387.00k

OS Memory 23964.00k

Timestamp 04/03/2015 05:59:27 PM

Step Count 19 Switch Count 28

Page Faults 0

Page Reclaims 36

Page Swaps 0

Voluntary Context Switches 56

Involuntary Context Switches 1

Block Input Operations 0

Block Output Operations 0

392 proc glm;

393 class Enrich;

394 model IOT=Enrich;

395 means Enrich/duncan;

396 run;

ERROR: One or more variables are missing or freq or weight is zero on every observation.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE GLM used (Total process time):

real time 0.00 seconds

user cpu time 0.00 seconds

system cpu time 0.01 seconds

memory 704.00k

OS Memory 24224.00k

Timestamp 04/03/2015 05:59:27 PM

Step Count 20 Switch Count 47

Page Faults 0

Page Reclaims 134

Page Swaps 0

Voluntary Context Switches 132

Involuntary Context Switches 1

Block Input Operations 0

Block Output Operations 264

397 proc glm;

398 class Enrich;

399 model ASD=Enrich;

400 means Enrich/duncan;

401 run;

ERROR: One or more variables are missing or freq or weight is zero on every observation.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE GLM used (Total process time):

real time 0.00 seconds

user cpu time 0.00 seconds

system cpu time 0.00 seconds

memory 704.00k

OS Memory 24224.00k

Timestamp 04/03/2015 05:59:27 PM

Step Count 21 Switch Count 41

Page Faults 0

Page Reclaims 71

Page Swaps 0

Voluntary Context Switches 108

Involuntary Context Switches 4

Block Input Operations 0

Block Output Operations 264

402 proc sort;

403 by Enrich;

404 run;

NOTE: Input data set is already sorted, no sorting done.

NOTE: PROCEDURE SORT used (Total process time):

real time 0.00 seconds

user cpu time 0.00 seconds

system cpu time 0.00 seconds

memory 387.00k

OS Memory 23964.00k

Timestamp 04/03/2015 05:59:27 PM

Step Count 22 Switch Count 30

Page Faults 0

Page Reclaims 36

Page Swaps 0

Voluntary Context Switches 49

Involuntary Context Switches 2

Block Input Operations 0

Block Output Operations 0

405 proc glm;

406 class Enrich;

407 model bigIOT=Enrich;

408 means Enrich/duncan;

409 run;

ERROR: One or more variables are missing or freq or weight is zero on every observation.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE GLM used (Total process time):

real time 0.00 seconds

user cpu time 0.00 seconds

system cpu time 0.00 seconds

memory 704.00k

OS Memory 24224.00k

Timestamp 04/03/2015 05:59:27 PM

Step Count 23 Switch Count 43

Page Faults 0

Page Reclaims 71

Page Swaps 0

Voluntary Context Switches 117

Involuntary Context Switches 0

Block Input Operations 0

Block Output Operations 264

410 proc sort;

411 by Enrich;

412 run;

NOTE: Input data set is already sorted, no sorting done.

NOTE: PROCEDURE SORT used (Total process time):

real time 0.00 seconds

user cpu time 0.00 seconds

system cpu time 0.00 seconds

memory 387.00k

OS Memory 23964.00k

Timestamp 04/03/2015 05:59:27 PM

Step Count 24 Switch Count 26

Page Faults 0

Page Reclaims 36

Page Swaps 0

Voluntary Context Switches 48

Involuntary Context Switches 0

Block Input Operations 0

Block Output Operations 0

413 proc glm;

414 class Enrich;

415 model PS=Enrich;

416 means Enrich/duncan;

417 run;

ERROR: One or more variables are missing or freq or weight is zero on every observation.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE GLM used (Total process time):

real time 0.00 seconds

user cpu time 0.00 seconds

system cpu time 0.01 seconds

memory 705.00k

OS Memory 24224.00k

Timestamp 04/03/2015 05:59:27 PM

Step Count 25 Switch Count 43

Page Faults 0

Page Reclaims 71

Page Swaps 0

Voluntary Context Switches 116

Involuntary Context Switches 0

Block Input Operations 0

Block Output Operations 264

418 proc glm;

419 class Enrich;

420 model fight=Enrich;

421 means Enrich/duncan;

422 run;

ERROR: One or more variables are missing or freq or weight is zero on every observation.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE GLM used (Total process time):

real time 0.00 seconds

user cpu time 0.01 seconds

system cpu time 0.00 seconds

memory 704.00k

OS Memory 24224.00k

Timestamp 04/03/2015 05:59:27 PM

Step Count 26 Switch Count 41

Page Faults 0

Page Reclaims 71

Page Swaps 0

Voluntary Context Switches 108

Involuntary Context Switches 0

Block Input Operations 0

Block Output Operations 264

423 proc glm;

424 class Enrich;

425 model pacing=Enrich;

426 means Enrich/duncan;

427 run;

ERROR: One or more variables are missing or freq or weight is zero on every observation.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE GLM used (Total process time):

real time 0.00 seconds

user cpu time 0.00 seconds

system cpu time 0.01 seconds

memory 704.00k

OS Memory 24224.00k

Timestamp 04/03/2015 05:59:27 PM

Step Count 27 Switch Count 45

Page Faults 0

Page Reclaims 71

Page Swaps 0

Voluntary Context Switches 124

Involuntary Context Switches 0

Block Input Operations 0

Block Output Operations 264

428 proc glm;

429 class Enrich;

430 model pp=Enrich;

431 means Enrich/duncan;

432 run;

ERROR: One or more variables are missing or freq or weight is zero on every observation.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE GLM used (Total process time):

real time 0.00 seconds

user cpu time 0.01 seconds

system cpu time 0.00 seconds

memory 704.00k

OS Memory 24224.00k

Timestamp 04/03/2015 05:59:27 PM

Step Count 28 Switch Count 41

Page Faults 0

Page Reclaims 71

Page Swaps 0

Voluntary Context Switches 108

Involuntary Context Switches 2

Block Input Operations 0

Block Output Operations 264

433 proc glm;

434 class Enrich;

435 model biggnaw=Enrich;

436 means Enrich/duncan;

437 run;

ERROR: One or more variables are missing or freq or weight is zero on every observation.

438

439

440

441

442

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE GLM used (Total process time):

real time 0.00 seconds

user cpu time 0.00 seconds

system cpu time 0.01 seconds

memory 705.00k

OS Memory 24224.00k

Timestamp 04/03/2015 05:59:27 PM

Step Count 29 Switch Count 65

Page Faults 0

Page Reclaims 71

Page Swaps 0

Voluntary Context Switches 199

Involuntary Context Switches 32

Block Input Operations 0

Block Output Operations 264

443 proc univariate normal;

444 var bigIOT IOT PS fight ASD pacing pp biggnaw;

445 by Enrich;

446 run;

NOTE: PROCEDURE UNIVARIATE used (Total process time):

real time 0.16 seconds

user cpu time 0.15 seconds

system cpu time 0.01 seconds

memory 2133.81k

OS Memory 25244.00k

Timestamp 04/03/2015 05:59:27 PM

Step Count 30 Switch Count 28

Page Faults 0

Page Reclaims 830

Page Swaps 0

Voluntary Context Switches 80

Involuntary Context Switches 13

Block Input Operations 0

Block Output Operations 24

447 proc sort;

448 by Enrich;

449 run;

NOTE: Input data set is already sorted, no sorting done.

NOTE: PROCEDURE SORT used (Total process time):

real time 0.00 seconds

user cpu time 0.00 seconds

system cpu time 0.00 seconds

memory 387.78k

OS Memory 25244.00k

Timestamp 04/03/2015 05:59:27 PM

Step Count 31 Switch Count 28

Page Faults 0

Page Reclaims 44

Page Swaps 0

Voluntary Context Switches 70

Involuntary Context Switches 3

Block Input Operations 0

Block Output Operations 0

450

451

452

453 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

465

Re: Reading data SAS 1999 -> Now

delsshel — Fri, 03 Apr 2015 18:10:27 GMT

Hi,

Yes, my data is provided by a CARDS statement. I changed the CARDS statement to DATALINES and received the same errors.

Thanks,

Re: Reading data SAS 1999 -> Now

Tom — Fri, 03 Apr 2015 18:11:35 GMT

Yep.'09'x is a tab.

trying adding this line right before the INPUT statement.

infile cards expandtabs ;

Re: Reading data SAS 1999 -> Now

delsshel — Fri, 03 Apr 2015 18:12:00 GMT

Hi Tom,

If the issue is with the spaces-tab conversion. Do you know how I would go about correcting the conversion issue?

Thanks,

Re: Reading data SAS 1999 -> Now

Tom — Fri, 03 Apr 2015 18:17:11 GMT

Use either EXPANDTABS or DLM='09'x on an INFILE statement.

Re: Reading data SAS 1999 -> Now

delsshel — Fri, 03 Apr 2015 20:05:51 GMT

Thank you so much. This worked!

Delia