proc report

mano — Fri, 22 Mar 2013 01:36:55 GMT

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;

Re: proc report

Cynthia_sas — Fri, 22 Mar 2013 02:45:04 GMT

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