PROC REPORT

Ronein — Sun, 25 Aug 2019 04:13:46 GMT

Hello

What wrong with following code that I get duplicate columns of PCTSUM.

The task is to calculate for each product x Region ,SUM(sales) and PCT of Sum(Sales).

proc report data=sashelp.shoes nowd;
  where region in ('Africa', 'Asia','Canada');
  column Product Region, (sales sales=salespct) region=region2, sales=salesPct2 ;

  define product/group;

  define region/across;

  define sales/'SUM sales in USD';

  define salespct/ pctsum 'pctsum%' format=percent9.2;
  define region2 / across;
  define salespct2 / pctsum 'pctsum %' format=percent9.2;

  rbreak after/summarize;
run;

Re: PROC REPORT

PaigeMiller — Sun, 25 Aug 2019 11:29:20 GMT

It seems you are getting a column to appear twice because you asked PROC REPORT to show that column twice.

topic Re: PROC REPORT in SAS Programming

PROC REPORT

Re: PROC REPORT