Hi! I am a new-ish SAS user. I am trying to do a one-to-many data merge with two files in my work folder. However, I keep getting this error:
ERROR: Variable Type has been defined as both character and numeric.
However, the varaibles are exactly the same:
I have tried multiplying NUMBER by one to be sure it is numeric or to see if it needed a reset of sorts, but that did not work
my sas code is this:
/* Sorting data and merging */
proc sort data = A; by NUMBER;
proc sort data = B; by NUMBER;
/*One to many data merge - NUMBER is numeric */
merge A (in = aaa) B (in = bbb);
if aaa*bbb = 0 then delete;
I am thinking it may be how I am merging and I have looked online for help but was not able to find it. Help with this would be much appreciated!
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.