I want to find the relative risk and risk difference and their corresponding 95% CIs to compare adverse events in a treatment group compared to a placebo group.  What 95% CI can handle zero counts using PROC FREQ (or a different procedure)? I was going to use Wald and Agresti-Caffo, respectively, but it looks like Wald can't handle zero counts and since we have a small sample size (n<10), perhaps that's not the best option in general... ... View more

How can I change this macro to create all the variables in one data set? I want  First_ADD and Second_ADD in the out flag data set. I want to do this for multiple varibles using the macro but it keeps overwriting itself and keeping the last flag that was created by the macro. Thank you!   %MACRO FLAG(VAR1,VAR2,FLAGNAME); DATA FLAG; SET RULE1; &FLAGNAME=0; DO _N_=1 to countw(&VAR1,',') while(&FLAGNAME=0); word=scan(&VAR1,_N_,','); if word=' ' then continue; if indexw(trim(&VAR2),trim(word),',') then &FLAGNAME=1; end; drop word; run; %MEND FLAG; %FLAG(Addresses1,Addresses2,First_ADD); %FLAG(Addresses1,Addresses3,Second_ADD); ... View more

Hi all, I'm running ZINB via PROC GENMOD. Most models have run smoothly but I am running into an issue with one of my models. I'm using various child characteristics to predict zero-inflated behavioral and emotional count outcomes. Most IVs are continuous except for medication status (yes vs no). For one particular outcome, the logit portion of the model does not produce a p-value for my categorical variable, and produces the same value for the estimate and CIs; I'm not receiving any error messages. My online searches have yielded results predominately re: missing values.   Here is my code and output for the logit model. Any resources/thoughts would be greatly appreciated!   TITLE 'ZINB, DV = Anger Emo log'; PROC GENMOD DATA = datafile; CLASS Meds; MODEL Emotion_anger = meds time x1 x2 x3 / link = log dist = zinb offset = log_var; ZEROMODEL meds time x1 x2 x3; RUN;   Logit Model Output: Analysis Of Maximum Likelihood Zero Inflation Parameter EstimatesParameter  Estimate; SE; Wald 95% CI; Wald Chi-Square; p-value  Intercept; df = 1 -25.4554 0.7635 -26.9518 -23.9591 1111.72 <.0001 Meds yes; df = 0 24.4313 0.0000 24.4313 24.4313 . . Meds no; df = 0 0.0000 0.0000 0.0000 0.0000 . . time; df = 1 0.0725 0.1813 -0.2828 0.4279 0.16 0.6891 x1; df = 1 5.3979 1.9872 1.5031 9.2927 7.38 0.0066 x2; df = 1 4.1286 1.5235 1.1425 7.1146 7.34 0.0067 x3; df = 1 -0.1602 0.0610 -0.2798 -0.0406 6.89 0.0087   ... View more

Brand new to SAS.   I'm doing something that I expect is relatively easy, but I'm struggling to get it right.  The requirement is basic - I'm reading in a long file with many rows, if a record matches a criteria I want it to be shipped to a different "bypass" file that I'll work on in a later process, but it should be removed from the original read-in file. Environment is zOS - input file is defined and passed in via JCL (all working). I get the following errors if I remove my actual logic - if I leave the FILENAME statement in without referencing it there's no errors. ERROR: Invalid logical name. ERROR: Error in the FILENAME statement. ERROR: Invalid file, BYPASS_FILE.   FILENAME BYPASS_FILE BYPASS1; /***********************************************************/ /* READ FILE */ /***********************************************************/ DATA DATAIN; INFILE DATAIN; INPUT @ 00001 RECORD_NUMBER $CHAR8. @ 01769 COMPONENT_STATUS $CHAR1. ; /*******************************************************************/ /* CREATE BYPASS FILE - USED TO STORE RECORDS WHICH HAVE AN */ /* INACTIVE COMPONENT: COMPONENT_STATUS = I */ /*******************************************************************/ IF COMPONENT_STATUS = 'I' THEN DO; FILE BYPASS_FILE; PUT; DELETE; END;     ... View more

I am using the SAS elarning courses in my institution course, and assigning as homework the Virtual lab-based demos and/or activities.  I want the students to be able to save their final product work of an activity/demo and upload it in the dropbox of the brightspace D2L LMS. Are there options that enable the user to do so?  if so, what is the best/easiest option?  Thanks. Kaddour ... View more