proc report

[mano]

Hello all,

Here is my proc report:-

Proc report data=final split='|" headline headlskip;

   columns col1-col3;

define col1 / display "AESOC| reported term" width=60 flow;

define col2 / display "test drug | (N=&n1)" width=25;

define col3 / display "reference drug | (N=&n2)" width=25;

run;

In the column headers of my output, I see leading spaces present for the population count as follows:-

__________________________________________________________

AESOC                                  test drug                   reference drug

reported term                       (N=      188)                  (N=       88)

___________________________________________________________

I have no idea why there are leading spaces.Can any suggest what might be causing the problem.

my code for populatin count is:-

proc sql noprint;

   select count(distinct usubjid) into : n1 from adsl where saffl eq "Y" and trta eq "test";

   select count(distinct usubjid) into : n2 from adsl where saffl eq "Y" and trta eq "Ref";

quit;

[Cynthia_sas · Accepted solution]

Hi, generally, you do sometimes need to strip leading spaces from a macro variable. The simplest way to do that is:

%let n1=&n1;

%let n2=&n2;

AFTER the quit in your SQL step. (There are other ways to trim the spaces, but that is the simplest that will work in all versions of SAS.)

cynthia