I have used the syntax referred in this article for my project but I don't understand the purpose of this step: proc genmod data=data2; class x2 x2 x5; model costp = x1 x2 x5 x3 x4 x4*x1 /dist =normal link=log; output out= y_hatC pred= condpred ; run;   Nowhere in the following steps we use condpred. Please help me better understand the syntax. Thank you ... View more

I agree with Reeza. Most likely, you should use the param=glm option in the class statement. ... View more

In order to create a complex report, First PROC SQL, then PROC TRANSPOSE. proc sql; create table temp as select sex,age,cats(count(*),'(', put( count(*)/(select count(*) from sashelp.class where sex=a.sex) ,percent7.2), ')') as value from sashelp.class as a group by sex,age ; quit; proc transpose data=temp out=want prefix=age; by sex; var value; id age; run; proc print noobs;run; ... View more

Try it and let me know. ... View more

Assuming that multiple-drug treatments are represented as many drugs starting on the same day, for tha same patient, you could do this:   proc sort data=theData; by patId startDate drugName; run; data want0; length drugs $12; do until(last.startDate); set theData; by patId startDate; drugs = catx("+", drugs, drugName); end; run; data want1; set want0; by patId; if first.patId; drop drugName daysSupply; run; ... View more

If you have data for those records make a 'master table' that has the values for the drug/year and then merge the tables on drug/year.    You can probably use PROC STANDARD for this to replace missing values, as long as you're okay with using the mean value of the drugs per year. If not you'll need another method.   http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/viewer.htm#a002473725.htm ... View more

Thanks.  This worked well, and matches up with another step in my analysis.    -Chris   ... View more