I am trying to infile a csv file into SAS. However in the CSV, an hypen is used to designate values as missing. Obviously, this causes problems because hyphens cannot be read in as missing. So I believe, I need to replace all hyphens in the numeric variables to periods. I am using SAS BASE 9.4 Here are some of my attempts. data fixed_total_genders; set total_genders; array change _numeric_; if change eq '-' then call missing(of change); run; data fixed_total_genders; set total_genders; array(*) _numeric_; do i=1 to dim(a); if a(i) = - then a(i) = .; end; drop i; run;
... View more