Help using Base SAS procedures

PROC REPORT : separate dataset for summary variables

Accepted Solution Solved
Reply
Regular Contributor
Posts: 194
Accepted Solution

PROC REPORT : separate dataset for summary variables

Hi All,

I have two datasets : the first one, A, contains some variables, say X, Y, Z and

the second one, B, is a one row dataset containing summary values for some of

the variables of A e.g. SX, SY.

The summary functions used to build dataset B are not simple sums or means but

use some specific rules.

Can I, using PROC REPORT, generate a table displaying data from dataset A and, on

an additional row, the summary values extracted from dataset B ?

Thanks


Accepted Solutions
Solution
‎01-17-2014 09:08 AM
Super User
Super User
Posts: 6,499

Re: PROC REPORT : separate dataset for summary variables

No, but you could just run PROC REPORT against a view that does combine them.

data c / view=c ;

set a(in=in1) b(in=in2);

group = in2 ;

run;

proc report data=c ... ;

  column group .... ;

  define group / group noprint ;

  ...

run;

View solution in original post


All Replies
Solution
‎01-17-2014 09:08 AM
Super User
Super User
Posts: 6,499

Re: PROC REPORT : separate dataset for summary variables

No, but you could just run PROC REPORT against a view that does combine them.

data c / view=c ;

set a(in=in1) b(in=in2);

group = in2 ;

run;

proc report data=c ... ;

  column group .... ;

  define group / group noprint ;

  ...

run;

Regular Contributor
Posts: 194

Re: PROC REPORT : separate dataset for summary variables

OK I will try that

Thank You Tom  for your time and feedback.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 176 views
  • 0 likes
  • 2 in conversation