Hi, all. I try to create frequency about the total, but the SAS said the 'total' variable is not found. Here's my code proc import datafile="/home/u58991900/sasuser.v94/Rental_credit_Record.csv" dbms=csv out=RRC; RUN; proc import datafile="/home/u58991900/sasuser.v94/Rental_Customer_info.csv" dbms=csv out=RCI; RUN; DATA RRC1; SET RRC; IF STATUS="0" THEN GRADE=1; ELSE IF STATUS="1" THEN GRADE=2; ELSE IF STATUS="2" THEN GRADE=3; ELSE IF STATUS="3" THEN GRADE=4; ELSE IF STATUS="4" THEN GRADE=5; ELSE IF STATUS="5" THEN GRADE=100; ELSE IF STATUS="C" OR STATUS="X" THEN GRADE=0; RUN; proc print data=RRC1; run; proc sql; Select customer_id,sum(GRADE) as total from RRC1 GROUP BY customer_id; quit; title "GraFreq"; proc freq; tables total; run; Is any way I can solve it? ERROR: Variable TOTAL not found.
... View more
