Hello, I have a dataset shown below. I would like to get mean/median/IQR/sum/sum_percent in each "Lab/Pham/Diag"  group, excluding the missing values.  Please let me know how to approach, thanks. data Bill; length caseid $10 Lab 3 Pham 4 Diag 4; infile datalines delimiter=','; input Caseid Lab Pham Diag; datalines; EC1R00002,200,6000,5500, AC1R00012,100, , 7000, EC1R00013,50,3800, , BH1U00185, ,4600,1500, EN1R01252,700,9000,2900, CY1K01251, ,500, , BH1U99185,900,5600,8500, OP1R00252,360,9900,8900, PCHK01401,770,, , ; ... View more

Hello,   I use the Proc Freq to get Chisq value from Row percent and Column percent.  I found the result came back the same, why? proc freq data=have; table Insurance * PT_class / chisq nopercent norow; where PT_class in (1,2) and insurance in (1,2,4); run; proc freq data=have; table Insurance * PT_class / chisq nopercent nocol; where PT_class in (1,2) and insurance in (1,2,4); run; ... View more

Hello, I would like to use the current date to generate an output file.  However, I don't see the output date in my export file name.  I continue getting a '&tdate.' in the end.  Where did I do wrong?  Thanks.   data _null_; call symput('tdate',put(year("&sysdate"d),4.)||'_'||put(month("&sysdate"d),z2.)||'_'||put(day("&sysdate"d),z2.)); run; %put &tdate; ods rtf file = 'Pathwat\AUD1619_RTY_Clinic_&tdate..rtf'; ods rtf close; ... View more

Hello, Is there a way to simplify the Proc Freq coding below?  I have extra 8 variables similar to sex and age.  If I do one single step each, I have to do 16 steps to get the results.   proc freq data=Have; table Gender * RSV / chisq nopercent nocol out=Dataout_sex1; where RSV in (1,2); format RSV RSV. Gender Gender. ; run; proc freq data=Have; table Gender * RSV / chisq nopercent nocol out=Dataout_sex2; where RSV in (3,4); format RSV RSV. Gender Gender. ; run; proc freq data=Have; table Age * RSV / chisq nopercent nocol out=Dataout_age1; where RSV in (1,2); format RSV RSV. Age Age. ; run; proc freq data=Have; table Age * RSV / chisq nopercent nocol out=Dataout_age2; where RSV in (3,4); format RSV RSV. Age Age. ; run; ... View more

Hello, There are  _TYPE_ and _FREQ_ columns shown in the Proc summary output dataset.  How to remove them? Do I have do it in the next data step? Proc summary data=Have nway; class id; var Line_Total_Charge; output out=Want sum=; format class class.; run; ... View more

Hello, I ran two different programs Proc univariate and Proc summary to compare, and I found out the sum and the p90 are different.  Did I do something wrong? proc univariate data = datain; var Charge; output out = dataout1 pctlpts = 90 pctlpre = p_; run; Proc summary data=datain nway; var Charge; output out=dataout2 p90(Charge)=y_p90 sum=; run; ... View more