Hello, I tried a simple task to merge two datasets in SAS Studio. One data set is the clinic admittance data (21 observations) in the built-in SASUSER library with SAS BASE. The other data set was created by me (3 observations). I created following to do a simple demonstration of merging to students. It worked well in SAS BASE, but when run in SAS Studio, it generated output as attached. I found two odd things about the output: 1) instead of merging, it's more like SETting the two data sets; 2) actlevel in the created admitDiscount data set has value High printed as Hig. This stays unchanged even with a LENGTH statement before the INPUT in the data step. Any clue and/or suggestions?
Thank you in advance.
data admitDiscount; input actlevel $ DisRate; datalines; HIGH 0.85 MOD 0.95 LOW 1.0 ; proc sort data = admit; by actlevel; proc sort data = admitDiscount; by actlevel; run; data admit2; merge admit admitDis; by actlevel; newfee = fee*DisRate; format newfee 5.2; run; proc print; run;
... View more