I have two datasets, A and B. A has 15353 cases and B has 15234 cases. I used the following code to merge these two datasets proc sort data=A; by ID form testdate ; run; proc sort data=B; by ID form testdate; run;   data ck; merge A(in=in1) B(in=in2); by  ID form testdate; if in1=1; run;   In  dataset A, I created a variable inA, assigned value "Y" to indicate all cases in dataset A.  In dataset B, I created a variable inB, assigned  value "Y" to indicate all cases in dataset B. Theoretically A is supposed to have all cases of B, so in the merged dataset ck, the variable inB is either "Y" or empty. Then I want to get cases that in A but not in B. I used the following code   data ck1; set ck; if inB=""; run;   It turned out ck1 has 137 cases. But the case difference between A and B should be 15353-15234=119. where I was wrong? please help. thanks!       ... View more

Hello, I used the following SAS code to get cumulative count   proc freq data=have ; tables pass2013/OUTCUM list missing out=want; run;   then I used the following to sort by descending of cumulative count   proc sort data=want; by CUM_FREQ descending; run;   But got error message of "Variable NAME not found" as following ERROR: Variable NAME not found. ERROR 22-322: Syntax error, expecting one of the following: a name, _ALL_, _CHARACTER_, _CHAR_, _NUMERIC_.   Please help.   thanks!           ... View more

As attached, my data named "try" was generated by "proc summary" in previous step. Now I want to use "proc transpose" to reformat the data using the following code   proc sort data=try; by level id year; run; proc transpose data=try out=try1; var nclass; by level id year; run;   But got the result as the attached data try1.    I seems there is issue of  my "try" data. please help.   thanks! ... View more