Date: Fri, 19 Dec 2008 07:13:11 -0800
Reply-To: "jingtailan@gmail.com" <jingtailan@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "jingtailan@gmail.com" <jingtailan@GMAIL.COM>
Organization: http://groups.google.com
Subject: how to use line statement to add a text string -proc report
Content-Type: text/plain; charset=ISO-8859-1
CURRENT REPORT
Number of Subjects
Screened
301
Number of Subjects Not Eligible for Treatment
Period 144 ( 46.5)
Pretreatment Event / Adverse
Event
1 ( 0.3)
Major Protocol
Deviation
1 ( 0.3)
Lost to Follow-
Up
3 ( 1.0)
Voluntary
Withdrawal
8 ( 2.6)
Did Not Meet Entrance
Criteria
126 (40.6)
Other
5 ( 1.6)
Number of Subjects Eligible for Treatment
Period 157 ( 50.6)
==============================================================================
GOAL: Primary Reason Subject Not Eligible for Treatment Period----??
I need to add this line, how to add it ???
Number of Subjects
Screened
301
Number of Subjects Not Eligible for Treatment
Period 144 ( 46.5)
Primary Reason Subject Not Eligible for Treatment Period----?? I
need to add this line, how to add it ???
Pretreatment Event / Adverse
Event
1 ( 0.3)
Major Protocol
Deviation
1 ( 0.3)
Lost to Follow-
Up
3 ( 1.0)
Voluntary
Withdrawal
8 ( 2.6)
Did Not Meet Entrance
Criteria
126 (40.6)
Other
5 ( 1.6)
Number of Subjects Eligible for Treatment
Period 157 ( 50.6)
=================================================================================
Current data set:
Obs
col1
ord ord2 col2
1 Number of Subjects
Screened 10 301
2 Number of Subjects Not Eligible for Treatment Period
20 144 ( 46.5)
3 Pretreatment Event / Adverse
Event 20 1 1 ( 0.3)
4 Major Protocol
Deviation 20
2 1 ( 0.3)
5 Lost to Follow-
Up 20
3 3 ( 1.0)
6 Voluntary
Withdrawal 20
4 8 ( 2.6)
7 Did Not Meet Entrance
Criteria 20 9 126
( 40.6)
8
Other
20 99 5 ( 1.6)
9 Number of Subjects Eligible for Treatment Period
30 157 ( 50.6)
===============================================================================
CODE:
proc report data=final center headline headskip missing nowd split='|'
spacing=2;
column ord ord2 col1 col2;
define ord / order order=internal noprint;
define ord2 / order order=internal noprint;
define col1 / width=90 " ";
define col2 / width=37 " Results N (%)";
compute after ord;
line ' ' ;
endcomp;
/*
compute before ord2;
if ord2=1 then do;
line @1 'Primary Reason Subject Not Eligible for
Treatment Period;
end;
endcomp;
*/
run;