Including blank values from CSV import

RandoDando — Wed, 21 Apr 2021 14:18:43 GMT

I am importing a CSV file which has blank values in a numeric field. The blanks are in delimited file as simply two sequential commas. I want to read those as . but SAS is skipping over them. I tried the MISSOVER option but it is still going to the next variable. The variable with the missing values is "Rate". It is in the CSV file as percents (with the % signs), so I had to specify the :percent. format option then change it to Percent10.2 after the import. I want blanks to be imported as blanks (which is . for numeric data).


data one;
 infile "\\...MyFile.csv" dlm=',' firstobs=2 missover  ;
 length state county $24;
 input State $ County $ FIPS  Population Total  rate :percent. score  ;
rename county = county_name;
format rate Percent10.2;
run;

Re: Including blank values from CSV import

Reeza — Wed, 21 Apr 2021 14:23:39 GMT

Try the DSD option and TRUNCOVER.

infile "\\...MyFile.csv" DSD firstobs=2 TRUNCOVER;

For your percent you may want an informat instead.

 length state county $24;
  informat rate percent.;
 input State $ County $ FIPS  Population Total  rate  score  ;

@RandoDando wrote:

I am importing a CSV file which has blank values in a numeric field. The blanks are in delimited file as simply two sequential commas. I want to read those as . but SAS is skipping over them. I tried the MISSOVER option but it is still going to the next variable. The variable with the missing values is "Rate". It is in the CSV file as percents (with the % signs), so I had to specify the :percent. format option then change it to Percent10.2 after the import. I want blanks to be imported as blanks (which is . for numeric data).
data one;
 infile "\\...MyFile.csv" dlm=',' firstobs=2 missover  ;
 length state county $24;
 input State $ County $ FIPS  Population Total  rate :percent. score  ;
rename county = county_name;
format rate Percent10.2;
run;

topic Re: Including blank values from CSV import in SAS Programming

Including blank values from CSV import

Re: Including blank values from CSV import