Hi Sir, Sorry for the miscommunication, i am trying to learn SAS base. I have created the sample data using datalines, data outdata; infile datalines delimiter=','; input Name $ CAT $ Count_no; datalines; SIVA,SSC,1 SIVA,HSC,1 SIVA,BSC,1 SIVA,MSC,1 RAJA,SSC,1 RAJA,HSC,1 RAJA,BSC,1 GIRI,SSC,1 GIRI,HSC,1 DOR,SSC,1 RAM,SSC,1 RAM,HSC,1 SUBA,SSC,1 SUBA,HSC,1 SUBA,BSC,1 SUBA,MSC,1 MOJ,SSC,1 MOJ,HSC,1 MOJ,BSC,1 ; run; Also, I am trying to create the summary report but summary column its not summed up into single value. PROC TABULATE DATA=WORK.OUTDATA; VAR Count_no; CLASS Name / ORDER=UNFORMATTED MISSING; CLASS CAT / ORDER=UNFORMATTED MISSING; TABLE Name *CAT all = 'Total',(Count_no * Sum={LABEL="Sum"} ); RUN;
... View more
