Create a Report

danwarags — Mon, 16 May 2016 19:44:57 GMT

Hello Everyone,

I have a dataset below showing variables country, salestype and number of sales.

I want the output such that it sums up the sales for each salestype and country and produces a table like below.

Could you please guide me to code this. I tried using proc sql but it did not work the way I wanted.

Re: Create a Report

Astounding — Mon, 16 May 2016 20:54:04 GMT

Here's one way to create a report with the right structure. You can always learn more about PROC TABULATE if you want a fancier report:

proc tabulate data=have;

class country salestype;

var sales;

tables country all, (salestype all) * sales=' ' * sum=' ';

run;