Proc Import CSV, remove missing data

sasuser12321 — Tue, 28 Jan 2020 17:40:13 GMT

Hi all!

So, I'm trying to import some datasets in SAS and join them, the only problem is that I get this error after joining them -

proc import datafile='filepath/datasetA.csv'
out = dataA
dbms= csv
replace;
run;


proc import datafile='filepath\datasetB.csv'
out = dataB
dbms= csv
replace;
run;



/* combine them all into one dataset*/


data DataC;
set &dataA. &dataB;

run;



ERROR: Variable column_k has been defined as both character and numeric.

The column in question looks something like this in both of the data sets that I'm trying to join -

column_k

etc..

Basically, I would like to import the NA data in that column as 'missing', if that's possible? I need the entire column to remain numeric as I'm planning on doing some mathematical stuff with the data in that column further down the line.

Thanks for your help!

Re: Proc Import CSV, remove missing data

unison — Tue, 28 Jan 2020 18:24:05 GMT

Take a look here:https://communities.sas.com/t5/SAS-Programming/Importing-a-CSV-file-from-R-with-NA-s-as-missing/td-p/492765

and see if this solves the problem you're having.

topic Re: Proc Import CSV, remove missing data in SAS Procedures

Proc Import CSV, remove missing data

Re: Proc Import CSV, remove missing data