OK so here is the scenario of the data I am importing. 2020,33860,01,001,020111,0,T,N,DM,59162,46523,122.93,65700,1948,508,697,1008,940 2020,33860,01,001,020111,0,T,N,DM,59162,46523,122.93,65700,1948,508,697,1008,940 2020,33860,01,001,020111,0,T,N,DM,59162,46523,122.93,65700,1948,508,697,1008,940 2020,33860,01,001,020111,0,T,N,DM,59162,46523,122.93,65700,1948,508,697,1008,940 2020,33860,01,001,020111,0,T,N,DM,59162,46523,122.93,65700,1948,508,697,1008,940 The sample is header less CSV file. Metadata for the file is as follows: FieldName Length DataType Import_in_SAS YEAR 4 AN Y MSA 5 AN Y STATE 2 AN Y COUNTY 3 AN Y TRACT 6 AN Y CITY 1 AN Y SMALL_COUNTY 1 AN N TRACT_FLAG 1 AN Y COUNTY_FLAG 1 AN N URBAN_RURAL 1 AN Y INCOME_MSA 8 NUM Y INCOME_FAMILY 8 NUM Y INCOME_TRACT 8 (DECIMAL 6,2) Y INCOME_FFIEC 8 NUM Y TOTAL_PERSONS 8 NUM Y TOTAL_FAMILIES 8 NUM Y TOTAL_HHLDS 8 NUM Y TOTAL_FEMALES 8 NUM Y TOTAL_MALE 8 NUM N In the above data set and metadata of the dataset, I do not want to import certain columns that have ended with N above when I import CSV file into SAS Dataset. There are a total of 19 fields that in the CSV file and I want to name the columns as I mentioned above in the metadata/file format/data types and want to skip importing 4 columns below: FieldName Length DataType Import_in_SAS SMALL_COUNTY 1 AN N COUNTY_FLAG 1 AN N TOTAL_MALE 8 NUM N Believe me I tried my best to import but I couldn't import the CSV file . CSV file itself has not headers so I provided the fieldnames and length and datatype above. The above same of data is a subset of very large file, 1247 columns by 76,000 rows. If this can be imported by your code on your machine and then I can take a look and compare what am I doing wrong on the larger file that I am dealing with. I have 4 files like that that I want to import and keep appending to the same SAS data set. Thanks, SamMad
... View more