topic Re: how to add a row with text in PROC report? in New SAS User

how to add a row with text in PROC report?

walterwang — Fri, 28 Sep 2018 07:16:40 GMT

data have;

a=1;

b=2;

c=3;

output;

a=2;

b=1;

c=2;

output;

run;

proc format;

value sex 1="Males" 2="Females" ;

run;

proc report data=have nowd;

define a / display '' format=sex.;

define b / display 'b';

run;

I want add a row before the row "male"

and with text "sex" up "male."

The results is

b c

Males	2	3
Females	1	2

Re: how to add a row with text in PROC report?

andreas_lds — Fri, 28 Sep 2018 09:04:23 GMT

Check the documentation of the line-statement in proc report. Using it has been explained in so many papers and posts, you surely find something appropriate.

Re: how to add a row with text in PROC report?

Ksharp — Fri, 28 Sep 2018 12:40:51 GMT


proc format;
value sex 1="Males" 2="Females" ;
run;

proc report data=have nowd;
define a / display '' format=sex.;
define b / display 'b';
compute before ;
 line @1 'sex';
endcomp;
run;