Hi, I hope to read in a txt file into SAS and some missing values where the original dataset doesn't have appear in my output dataset. And the value which should be in the variable Open moves to the next variable. My code are as below data delivery_stores_2001;
length Market_Name $20. MskdName $8.;
infile "/home/stat440/Delivery_Stores_2001.txt" dlm=' ' firstobs=2;
input IRI_KEY OU $ EST_ACV Market_Name $ Open Clsd MskdName $;
run; I have also paste part of the dataset IRI_KEY OU EST_ACV Market_Name Open Clsd MskdName 200039 GR 9.709999 BUFFALO/ROCHESTER 539 1219 Chain87 200171 GR 27.69099 MILWAUKEE 522 9998 Chain97 200197 GR 11.14 PEORIA/SPRINGFLD. 903 9998 Chain59 200233 GR 7.514999 OKLAHOMA CITY 1122 1150 Chain102 200272 GR 13.173 LOS ANGELES 873 9998 Chain124 200287 GR 7.481998 SAN FRANCISCO 795 9998 Chain94 200297 GR 23.159 PORTLAND,OR 999 9998 Chain79 200334 GR 19.21899 PORTLAND,OR 922 1329 Chain137 200411 GR 18.94199 NEW YORK 1014 9998 Chain66 200439 GR 14.098 WEST TEX/NEW MEX 920 9998 Chain110 200479 GR 18.545 SAN FRANCISCO 559 1362 Chain7 200485 GR 5.781998 OKLAHOMA CITY 490 9998 Chain102 200488 GR 26.06699 BOSTON 519 1325 Chain107 200489 GR 16.02299 HOUSTON 701 9998 Chain34 200492 GR 11.876 LOS ANGELES 473 9998 Chain124 200494 GR 20.028 GREEN BAY 486 1435 Chain115 200499 GR 9.598999 OKLAHOMA CITY 490 9998 Chain102 200501 GR 29.267 SAN FRANCISCO 554 9998 Chain7 200510 GR 31.10899 HARTFORD 473 1210 Chain114 200511 GR 19.21899 WEST TEX/NEW MEX 456 1145 Chain39 Am I using the wrong delimiter? Is there anything I could do to fix the problem? Thanks!
... View more
