BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
walterwang
Obsidian | Level 7

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
Males23
Females1

2

1 ACCEPTED SOLUTION

Accepted Solutions
Ksharp
Super User

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;

View solution in original post

2 REPLIES 2
andreas_lds
Jade | Level 19

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.

Ksharp
Super User

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;