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 0 1 5 4 NA NA 4 3 NA 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!
... View more