Hi Vince, Question: when you say "have" and "want" below (bold), do I replace those with the same data names ? namely, the data set I am working from? or how does it work? also, when you mean "first query" are you referring to the "sum" in the first paragraph and by "second query" are you referring to the sum in the second paragraph? How does using the CREATE TABLE AS statement affect data integrity? Thanks, N. proc sql; create table want as select study_numb, sum(day1_hosp) as day1_hosp, sum(day15_hosp) as day15_hosp, sum(day25_hosp) as day25_hosp from have group by study_numb; /* actual counts for day1, day15, day25 */ select sum(day1_hosp), sum(day15_hosp), sum(day25_hosp) from want; quit;
... View more