For some reason the QUERY SQL was not outputting, I changed my settings and now it is outputting correctly, with the proper titles and without the trailing zeros
This is how the code ended, I deleted the previously used PROC PRINT as now I got the output from the SQL.
PROC SQL;
Title "Within Treatment Group Differences on The First Visit";
CREATE TABLE diffweight as
select patient,
gender,
v_date as First_visit,
avg(weight) as mean label='Group_Average',
weight-CALCULATED mean as within label='Within_Group_Diff'
from stat.clinical
where visit=1
group by group
order by v_date
;
QUIT;
20
21 PROC SQL;
22
23 Title "Within Treatment Group Differences on The First Visit";
24 CREATE TABLE diffweight as
25 select patient,
26 gender,
27 v_date as First_visit,
28 avg(weight) as mean label='Group_Average',
29 weight-CALCULATED mean as within label='Within_Group_Diff'
30
31 from stat.clinical
32
33 where visit=1
34 group by group
35 order by v_date
36
37 ;
NOTE: The query requires remerging summary statistics back with the original data.
NOTE: Table WORK.DIFFWEIGHT created, with 24 rows and 5 columns.
38 QUIT;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.02 seconds
cpu time 0.00 seconds
This is what I was getting with the print
This is what I was looking for
... View more
