I don't know how you can in SQL, as mentioned before, a multilabel format within proc means is better in my opinion. Usually you won't summarize just by apple, you'll want all 3 with subtotals and then an overall total. Really it depends on what you're trying to do with it. Just guessing, but it may be better to create a summarized table that summarizes all fruits with a total and then filter that for a report. ... View more

Thanks Art. This is what i expected and yeah proc sort was not required here. Thanks again. ... View more

Hard to make a good diagnosis without more information, but it sounds more like a problem for PROC SUMMARY.  You can use CLASS statement and generate summaries for many combinations in a single pass. ... View more

You may be able to get what you want by using ODS.  E.g., ODS Output OneWayFreqs = stud_freq ;   proc freq  data=sashelp.class;   tables sex age / list; run; ODS Listing ; ... View more

You are mixing up macro logic and data step logic. The reason that the %PUT is getting an error is that it is compiled BEFORE the data step runs.  So the CALL SYMPUT function has not been called yet. In a macro use the %LET statement to assign a value to a macro variable. %macro doit(m,n);   %do i=&m %to &n;     %let st&i=%eval(&i+1);   %end; %mend doit; %doit(1,2); In a data step use the DO statement to loop. %let m=1; %let n=2; data _null_;   do i=&m to &n;     call symputx(cats('ST',i),i+1);   end; run; PS: Do not use DO as the name of a macro as %DO is already a macro statement. ... View more

Try adding the option MOD onto the 2nd file statement.  Otherwise, you are overwriting the file. ... View more