Desktop productivity for business analysts and programmers

data input errors

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 89
Accepted Solution

data input errors

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;

Accepted Solutions
Solution
‎07-03-2018 09:12 AM
Super User
Posts: 6,933

Re: data input errors

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;

View solution in original post


All Replies
Solution
‎07-03-2018 09:12 AM
Super User
Posts: 6,933

Re: data input errors

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;

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 94 views
  • 0 likes
  • 2 in conversation