Hi, I'm trying to import this and get bunch of errors,
NOTE: Invalid data errors for file CARDS occurred outside the printed range.
NOTE: Increase available buffer lines with the INFILE n= option.
data TempSens; input Hours TempOverall TempWeekday TempWeekend TempOnlyOverall TempOnlyWeekday TempOnlyWeekend; datalines; 0 1181.58 1202 1053.35 1270.79 1274.09 1254.24 1 1084.39 1104.84 928.33 1147.74 1146.98 1142.94 2 958.31 977.69 771.02 1048.51 1047.97 1043.56 3 883.7 875.97 736.7 974.75 977.42 964.86 4 840.9 816.9 662.26 926.5 932.06 910.03 5 727.75 702.67 474.03 906.06 918.84 880.75 6 658.79 615.33 451.39 896.33 914.61 867.25 7 597.46 564.57 486.98 975.3 993.87 928.69 8 726.09 714.17 646.15 1149.74 1166.15 1093.48 9 879.53 915.79 774.62 1317.47 1335.77 1268.14 10 1012.96 1062.58 936.94 1483.5 1491.71 1438.31 11 1034.43 1191.75 1089.25 1608.4 1617.72 1581.41 12 1016.05 1268.26 1189.04 1705.87 1716.57 1693.73 13 1216.37 1386.14 1300.35 1788.65 1789.41 1775.98 14 1268.96 1422.26 1410.39 1831.8 1828.56 1842.75 15 1401.76 1515.02 1440.35 1865.54 1868.93 1857.16 16 1461.36 1537.55 1448.48 1905.01 1911.01 1880.4 17 1482.57 1523.15 1506.55 1918.04 1920.86 1897.27 18 1476.11 1488.32 1515.91 1887.83 1895.68 1864.21 19 1433.55 1425.26 1375.38 1824.3 1838.29 1787.83 20 1248.45 1233.52 1169.79 1713.1 1731.22 1686.07 21 1357.83 1346.15 1280.56 1672.22 1691.01 1647.44 22 1398.25 1355.75 1330.37 1550.74 1557.28 1549.46 23 1336.89 1293.48 1276.3 1415.82 1425.18 1407.35 ; proc print data=TempSens; run;
It looks like your data is using tabs as delimiters, instead of spaces. Tell SAS, by adding this just before the INPUT statement:
infile cards dlm='09'x;
It looks like your data is using tabs as delimiters, instead of spaces. Tell SAS, by adding this just before the INPUT statement:
infile cards dlm='09'x;
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.