I checked the code again and i see want_ has £0.00 replacing the missing values of want dataset. Could you please check the output again and let me know if there is any problem in the log. Thanks, Jag ... View more

Hi, Happy New year. Please try the below code, it is producing your desired output. DATA YEAR2012;   INPUT CONTRACT $ PLAN $ STATE $ COUNTY $ ENROLLMENT 12.;   FORMAT ENROLLMENT 12.;   DATALINES; H9999 801 NY SUFFOLK 90 H9999 810 NY SUFFOLK 0 H9999 808 NY SUFFOLK 0 H9999 032 NY SUFFOLK 614 H9999 814 NY SUFFOLK 1324 H9999 021 NY SUFFOLK 1211 H9999 029 NY SUFFOLK 92 H9999 033 NY SUFFOLK 396 H9999 815 NY SUFFOLK 81 ; RUN; proc sort data=YEAR2012(rename=(ENROLLMENT=yr12_ENROLLMENT CONTRACT=yr12_CONTRACT));   by PLAN STATE COUNTY; run; DATA YEAR2013;   INPUT CONTRACT $ PLAN $ STATE $ COUNTY $ ENROLLMENT 12.;   FORMAT ENROLLMENT 12.;   DATALINES; H9999 810 NY SUFFOLK 50 H9999 808 NY SUFFOLK 1000 H9999 032 NY SUFFOLK 600 H9999 814 NY SUFFOLK 1300 H9999 021 NY SUFFOLK 1355 H9999 029 NY SUFFOLK 192 H9999 033 NY SUFFOLK 400 H9999 815 NY SUFFOLK 90 H9999 035 NY SUFFOLK 500 ; RUN; proc sort data=YEAR2013(rename=(ENROLLMENT=yr13_ENROLLMENT CONTRACT=yr13_CONTRACT));   by PLAN STATE COUNTY; run; data yr12_13;   merge YEAR2012(in=a) YEAR2013(in=b);   by PLAN STATE COUNTY;   if yr13_ENROLLMENT ne . and yr12_ENROLLMENT ne . then DIFFERENCE=yr13_ENROLLMENT-yr12_ENROLLMENT;   if yr13_ENROLLMENT eq . and yr12_ENROLLMENT ne . then DIFFERENCE=0-yr12_ENROLLMENT;   if yr13_ENROLLMENT ne . and yr12_ENROLLMENT eq . then DIFFERENCE=yr13_ENROLLMENT-0; run; alternatively by proc sql PROC SQL;    CREATE TABLE yr12_13 AS    SELECT t1.yr12_CONTRACT,           t1.PLAN,           t1.STATE,           t1.COUNTY,           t1.yr12_ENROLLMENT,           t2.yr13_CONTRACT,           t2.PLAN AS PLAN1,           t2.STATE AS STATE1,           t2.COUNTY AS COUNTY1,           t2.yr13_ENROLLMENT,           /* DIFFERENCE */             (coalesce(t2.yr13_ENROLLMENT,0)-coalesce(t1.yr12_ENROLLMENT,0)) AS DIFFERENCE       FROM WORK.YEAR2012 t1            FULL JOIN WORK.YEAR2013 t2 ON (t1.PLAN = t2.PLAN) AND (t1.STATE = t2.STATE) AND (t1.COUNTY = t2.COUNTY); QUIT; Thanks, Jag ... View more

As per the image , i confer that there are two groups senior and new and the ttest is a two sample.The population of new is 26 subjects and senior is 24 with respective means. if we check the  equality of variance (F value) is 0.5320 which is greater than 0.05 so the variance is equal, we have to consider Method "Pooled" with P value 0.6622 which also suggests that there is no difference in variance between new and senior. If the F value was less than 0.05 then we need to consider that the variance are unequal, so the method to look would be "Satterthwaite" Hope this helps. Thanks, Jag ... View more

Please try, PROC SQL;    CREATE TABLE A_B AS    SELECT t2.t,           t1.id,           t1.p       FROM WORK.A t1            FULL JOIN WORK.B t2 ON (t1.id = t2.id); QUIT; Alternatively in datastep data A_B;   merge a(in=a) b(in=b);   by id; run; Thanks, Jag ... View more

Hi, Please try proc sql;   create table want as select distinct claim,max(seq) format=z3. ,dos from have   group by claim,dos; quit; Thanks, Jagadish ... View more

Hi, I have created a dummy dataset by using the macro variable with the values provided and it has created a dataset without any problem. Could you please check the below code and let me know if this is not the way you want to use it. %let cutoff = 90 95 96 96.5; %put &cutoff; data have;   array mac(4) (&cutoff);   do i = 1 to 4;   new=mac(i);   output;   end; run; Thanks, Jag ... View more