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!
Take a look here:https://communities.sas.com/t5/SAS-Programming/Importing-a-CSV-file-from-R-with-NA-s-as-missing/td-p...
and see if this solves the problem you're having.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: