topic Re: proc report in SAS Programming

proc report

Ronein — Tue, 21 Jan 2020 09:23:27 GMT

Hello
I want to create a proc report.
In x-axis there will be one categorical var "group"
In Y-axis there will be two categorical variables "date1" "NameDay".
in the cells of the table there will be sum of Y

Please note that in each column I want to have both date and name of day .
I don't want that the name of the day will be on multiple cells.

Data RawTbl;
informat date1 date9.;
format date1 date9.;
input ID date1 Y group $;
NameDay = put(date1,dowName. -l) ;
cards;
1 '15Jan2019'd 10 a
2 '17Jan2019'd 20 a
3 '19Jan2019'd 30 a
4 '21Jan2019'd 40 b
5 '23Jan2019'd 50 b
6 '18Jan2019'd 60 b
7 '17Jan2019'd 70 c
8 '08Jan2019'd 80 c
9 '04Jan2019'd 90 c
;
Run;

Re: proc report

Kurt_Bremser — Tue, 21 Jan 2020 09:39:25 GMT

Do you mean something like this:

proc transpose data=rawtbl out=trans;
by date1 notsorted nameday notsorted;
id group;
var y;
run;

proc report data=trans;
column date1 nameday a b c;
define date1 /group;
define nameday /group;
define a /analysis;
define b /analysis;
define c /analysis;
run;

Re: proc report

Ronein — Tue, 21 Jan 2020 09:55:55 GMT

When for same date there are multiple customers who belong to same group then it give an error

 Data RawTbl;
informat date1 date9.;
format date1 date9.;
input ID date1 Y group $;
NameDay = put(date1,dowName. -l) ;
cards;
1 '17Jan2019'd 10 a
2 '17Jan2019'd 20 a
3 '19Jan2019'd 30 a
4 '21Jan2019'd 40 b
5 '23Jan2019'd 50 b
6 '18Jan2019'd 60 b
7 '17Jan2019'd 70 a
8 '08Jan2019'd 80 c
9 '04Jan2019'd 90 c
;
Run;

proc transpose data=rawtbl out=trans;
by date1 notsorted nameday notsorted;
id group;
var y;
run;

Re: proc report

Ronein — Tue, 21 Jan 2020 09:57:16 GMT

In x-asix (rows) need to have groups (a,b,c)

In y-axis need to have date and under it name of day

Re: proc report

Ronein — Tue, 21 Jan 2020 10:35:07 GMT

Thank you very much.

However, the location of fields should be different.

In rows need to have groups (3 rows for categories: a,b,c)

In columns need to have date and under it name of day

Re: proc report

Kurt_Bremser — Tue, 21 Jan 2020 11:34:13 GMT

Please supply a visual example of the expected report you want to have out of your second example dataset.

Re: proc report

Ronein — Tue, 21 Jan 2020 12:02:42 GMT

Please see my new post .thanks

Re: proc report

PaigeMiller — Tue, 21 Jan 2020 12:10:17 GMT

I don't see a new post, please provide a link.

I see a similar old post of yours, which does NOT provide the requested VISUAL example of what you want.