Hey everyone! I am trying to import a dataset downloaded from US Census website, in csv format. The file has about 1700 rows and 169 columns. Each row represents a zip code. I want to import the file in a way that each zip code will be repeated 166 times (first three columns are variations of the same zip code) with only one variable that has data values. So the target dataset will have only 5 columns (zip, zip1, zip2, count var, value) and 297,804 rows (~166x1700). Here is the code i am using: filename eddata "C:\Users\path\ACS_12_5YR_B15001_with_ann.csv"; data test; infile eddata dlm="," missover firstobs=3; input zip $ zip1 $ zip2$ @; do var = 1 to 166; input values $ @; output; end; run; I get the correct number of total rows and columns, the values that are read in are alle correct, but almost half of the rows are blank (mostly they have missing values after 83rd iteration of the do loop). The original dataset has no missing values (dataset is attached). I am trying to understand why this is happening but with no luck so far. I would appreciate any advice!! Thanks, Maria
... View more