Hello - appreciate any help you can give! I'm trying to summarize data and put it into one table. The original layout of the data is: facilityname   facilitytype enrollment   utd_vac1     utd_vac2   utd_vac3 busybeez       pub               100           88                90               50 peter pan       priv                  23           22                11              23 Desired final layout is in percentage using total enrollment for the denominator to determine percentage                     All            Pub       Priv utd_vac1      89.4         88.0       22.0 utd_vac2      82.1         90.0       11.0 utd_vac3      59.3         50.0       23.0 I figured out I can use proc summary: proc sort data=table1; by facilitytype; run; *--to get summary stats by type; proc summary data=table1 (rename= (col1=private col1=public); by facilitytype; var enrollment utd_var1 utd_var2 utd_var3; output out=table1sum (drop=_type_ _freq_) sum=utd_var1 utd_var2 utd_var3; run; *--to get summary stats for all; proc summary data=table2 (rename= (col1=private col1=public); var enrollment utd_var1 utd_var2 utd_var3; output out=table2sum (drop=_type_ _freq_) sum=utd_var1 utd_var2 utd_var3; run; *--transpose table1sum; proc transpose data=table1sum output out=tablesumt (rename=(col1=public  col2=private0); run; *--transpose table2sum; proc transpose data=table2sum output out=table2sum5 (rename = (col1=public col2=private)); run; Then, I could divide the number enrollment to get the percentages.  Then, somehow append them into one table using proc append? But, is there a simpler way? Appreciate any help you can give - Thanks so much! ... View more

    Hi!  I'm a bit far removed from the chi square test and controlling for a variable (which I once must've learned way back when?). I'm trying to see if facility type is a confounding factor in a chi-square analysis where I use: proc freq data=keep tables type*category*missing_doses/chisq; run; I'm was initially trying to see if facilities within a certain category were more likely to have kids missing doses. So I used the above code but without the 'type*'.  And I got a significant chi-sq value (p<.0001) But,  I wanted to make sure that the facility type wasn't causing the significant outcome. So, I added the 'type*' in the above code and when I look at both facility types, the chisq value isn't significant. Does that mean there really is no significant difference and that type is a confounder? I'm so far removed from this that I just don't remember what it means to control for a variable ( I only remember if you don't control for a confounding variable, it can create a false association) And what does it mean that you get a significant result looking at all facility types. But, when you control for facility types, the significant results go away? Any help you can give is greatly appreciated! ... View more

Hi, I'm new to macros and cannot figure out why this doesn't work: I have a bunch of questions I'm running the chi-square test on comparing two groups so I'm trying to create a macro. The question names are: q1_volun q1_sec etc.... I ran the code without the macro and it worked fine using the question names. center pagesize=45 nonumber nodate symbolgen; %macro analysis(question); proc freq data=q1; tables group*&question./chisq; title "&question. - Chi-Sq - verifies info"; run; %mend analysis; %analysis (q1_vol); %analysis (q1_sec); Any help you can give is much appreciated!  Thanks! ... View more

Hello, I'm trying to update admin contact name & email information from the 'PrivAdmins' table into the 'Facilities' table. the 'PrivAdmins' table has more facility codes than the 'Facilities' table. But I only want the contact info for those facility codes that are in Table A updated (I don't want to add the facility codes listed in only listed in Table B but not Table A). PrivAdmins Table FacilityCode  AdminName   AdminEmail                        AdminAdmin   admin@gmail.com       /*this table has facility codes with missing values too*/ 12345              Carla Lan      carlalan@gmail.com     12346              Patrick Miles  pmiles@dmac.org Facilities Table FacilityCode  AdminName   AdminEmail.            FacilityName (more variables)... 12345                                                                     FacilityA 12349             Niger Kopak    nk@cmac.com         FacilityB Desired Result (Adminsp table) FacilityCode AdminName      AdminEmail                   Facility Name (more variables)... 12345           Carla Lan         caralan@gmail.com         FacilityA 12349          Niger Kopak      nk@cmac.com                FacilityB I used this code but it doesn't work. data adminsp; update facilities privadmins; by facilitycode; run; ... View more

Hi, I inherited code which had to be changed since the sampling method was changed (a DOMAIN statement was added).  Prior to the code change, the output to Excel worked. However, though the analysis portion now works and outputs to MS Word but not the output to the MS Excel spreadsheet. Can you help troubleshoot? Thanks! ... View more