Hello,   I am calculating confidence intervals for the mean of a few variables and I want to find a way to turn the CI results in to a variable on my final dataset.    For example:   I have a variable HAV_Complete, with a mean of 0.90817. I calculate the 95% CI using proc univariate:   proc univariate data=standard cibasic; var hib_complete; run;   In my output, the 95% CI is 0.893-0.922. Is there any way to dynamically turn this in to a variable in my final dataset? What I would like to see is:     record_id     hav_complete   hav_complete_mean    lower_limit    upper_limit   1                       0.903                    0.90817                 0.893              0.922   2                       1.00                      0.90817                 0.893              0.922   3                       0.87                      0.90817                 0.893              0.922     Any insight would be helpful. Thank you!  ... View more

I have a macro that is not calculating correctly. I want to take a variable, date0, and create the macro, datecount out of it.  date0 is formatted as a numeric mmddyy10. in the dataset report    proc sql noprint; select date0 into :datecount from report; quit;   when i %put &datecount I can tell that the macro is not working. I am unsure if it is due to the formatting (i also tried formatting date0 as date9. and that did not seem to work either) or if there's something else i'm doing incorrectly. Ultimately, I want to call the macro in a different macro:   %let date2MO=%sysfunc(intnx(day, "&datecount"d, 91,e));  where I calculate whatever date is 91 days after datecount.   any insight is helpful!  ... View more

I have a dataset where I am comparing multiple dates. Depending on the first date (date0), I want to create a different value for the variables status_2mo, status_6mo, status_12mo:   date2 should be between 0-90 days of date0; if date2 is missing then:    *if today is between 0-30 days of date0  then status= coming due   *if today is between 30-90 days of date0  then status= due   *if today is > 90 days of date0  then status = overdue   date6 should be between 150 and 240 days of date0; if date6 is missing then:   *if today is between 150-180 of date0  then status = coming due   *if today is between 180-240 of date0  then status = due   *if date6 is > 240 of date0  then status = due overdue   date12 should be between 330 and 390 days of date0; id date12 is missing then:   *if today is between 330-360 of date0  then status = coming due   *if today is between 360-390 of date0  then status= due   *if today is > 390 of date0   then status = overdue    Below is a snippet of my dateset:   PIN    DATE0           DATE2        DATE6    DATE12     STATUS_2mo   STATUS_6mo  STATUS_12mo 1      20190615 2      20190711 3      20190410         4      20190105      20190310     I would expect Status_2mo to be "coming due" for pins 1-2 I would expect status_2mo to be "overdue" for pin 3 I would expect status_6mo to be "due" for pin 4     here is a snippet of my code: %let today = %sysfunc(date(),YYMMDDN8.); /*2 MONTH CHECK-IN*/ If date2=. then do; If (&today. > date0) and (&today. < date0 + 30) then status_2mo= "coming due"; if status_2mo ne "coming due" and (&today. > date0 + 30) and (&today. < date0 + 90) then status_2mo= "due"; if status_2mo ne "coming due" and status_2mo ne "due" and (&today. > date0 +90) then status_2mo= "overdue"; end; run;   What i'm getting instead is that every value, regardless of if date2 is missing, is being marked as "overdue". Any insight helps! Thank you! ... View more

i have a dataset of dummy variables (0,1, .) that I want to use to determine the value of a new variable, "source". I have the below array and cannot figure out why it is saying array out of range. any suggestions are appreciated.   DATA DATA.SOURCE_CHECK4 (DROP=I); SET DATA.SOURCE_CHECK3; FORMAT SOURCE $10.; ARRAY DTP [8] DTPSRC1-DTPSRC8; ARRAY OPV [8] OPVSRC1-OPVSRC8; ARRAY MMR [8] MMRSRC1-MMRSRC8; ARRAY HIB [6] HIBSRC1-HIBSRC6; ARRAY HBV [7] HBVSRC2-HBVSRC8; /*GETTING RID OF BIRTHDOSE HBV*/ ARRAY VAX [8] VAXSRC1-VAXSRC8; ARRAY STP [8] STPSRC1-STPSRC8; ARRAY FLU [8] FLUSRC1-FLUSRC8; ARRAY HAV [8] HAVSRC1-HAVSRC8; ARRAY RTV [6] RTVSRC1-RTVSRC6;   DO I= 1 TO 75;   IF (DTP[I] = 1 OR DTP[I]=.) AND (OPV[I] = 1 OR OPV[I]=.) AND (MMR[I] = 1 OR MMR[I]=.) AND (HIB[I] = 1 OR HIB[I]=.) AND (HBV[I] = 1 OR HBV[I]=.) AND (VAX[I] = 1 OR VAX[I]=.) AND (STP[I] = 1 OR STP[I]=.) AND (FLU[I] = 1 OR FLU[I]=.) AND (HAV[I] = 1 OR HAV[I]=.) AND (RTV[I] = 1 OR RTV[I]=.) THEN SOURCE="HD ONLY"; ELSE IF (DTP[I] = 0 OR DTP[I]=.) AND (OPV[I] = 0 OR OPV[I]=.) AND (MMR[I] = 0 OR MMR[I]=.) AND (HIB[I] = 0 OR HIB[I]=.) AND (HBV[I] = 0 OR HBV[I]=.) AND (VAX[I] = 0 OR VAX[I]=.) AND (STP[I] = 0 OR STP[I]=.) AND (FLU[I] = 0 OR FLU[I]=.) AND (HAV[I] = 0 OR HAV[I]=.) AND (RTV[I] = 0 OR RTV[I]=.) THEN SOURCE="MED ONLY"; ELSE IF (DTP[I]=.) AND (OPV[I]=.) AND (MMR[I]=.) AND (HIB[I]=.) AND (HBV[I]=.) AND (VAX[I]=.) AND (STP[I]=.) AND (FLU[I]=.) AND (HAV[I]=.) AND (RTV[I]=.) THEN SOURCE="MISSING"; ELSE SOURCE="BOTH"; END; RUN; ... View more

Hello,   I have a data set with variables that I want to compare using an array, but currently have an if-then statement.    Data set:   dtp1 dtp1src dtp2 dtp2src dtp3 dtp3src dtp4 dtp4src dtp5 dtp5src dtp6 dtp6src dtp7 dtp7src dtp8 dtp8src 1/1/2016 M                             2/22/2016 M 5/10/2016 M 7/19/2016 M 7/14/2017 M                   U 5/10/2016 M 7/7/2016 M 5/1/2017 M                 4/1/2016 M 4/5/2017 M 5/3/2017 M   U                 3/9/2016 M   M 7/8/2016 M 7/20/2017 M                 4/4/2016 H 7/11/2016 H 9/26/2016 H 4/24/2017 H                   Each "src" column refers to the column before it (where dtp1src is the vaccination source for the dtp1 vaccination date). What I want to end up with is a error variable of any vaccination date (DTP1-DTP8) that does not have a source (DTP1SRC-DTP8SRC) and any source (DTP1-DTP8) that does not have a vaccination date (DTP1-DTP8). Below is the code I currently have. It works fine, but I feel like there is a more elegant way to flag these using an array/do loop. Any suggestions are greatly appreciated!   DATA CLEANING.DTP_ERROR; SET CLEANING.VALID; IF DTP1 NE . AND DTP1src=' ' OR DTP1=. AND DTP1SRC NE ' ' THEN ERROR= 'SOURCECHECK'; IF DTP2 NE . AND DTP2src=' ' OR DTP2=. AND DTP2SRC NE ' ' THEN ERROR= 'SOURCECHECK'; IF DTP3 NE . AND DTP3src=' ' OR DTP3=. AND DTP3SRC NE ' ' THEN ERROR= 'SOURCECHECK'; IF DTP4 NE . AND DTP4src=' ' OR DTP4=. AND DTP4SRC NE ' ' THEN ERROR= 'SOURCECHECK'; IF DTP5 NE . AND DTP5src=' ' OR DTP5=. AND DTP5SRC NE ' ' THEN ERROR= 'SOURCECHECK'; IF DTP6 NE . AND DTP6src=' ' OR DTP6=. AND DTP6SRC NE ' ' THEN ERROR= 'SOURCECHECK'; IF DTP7 NE . AND DTP7src=' ' OR DTP7=. AND DTP7SRC NE ' ' THEN ERROR= 'SOURCECHECK'; IF DTP8 NE . AND DTP8src=' ' OR DTP8=. AND DTP8SRC NE ' ' THEN ERROR= 'SOURCECHECK'; RUN;   ... View more

Hello,   I am comparing a subset of data and want to create an error message depending on certain criteria. I want to ignore missing values however, and currently SAS is reading the missing values in my if then statement. Is there a do-loop or array that can ignore these missing values?   For example,   I have a dataset containing:   DOB              DTP1             DTP2               DTP3               DTP4         2/24/2016      2/24/2016      4/25/2016       8/24/2016         6/26/2017 1/13/2016      01/16/2016    4/15/2016            .                         .   and I want to create variable ERROR = "DTP_ERROR" when any DTP1-DTP4 are less than 6 weeks after DOB. Currently, below is my coding. However, it seems like SAS is ignoring my first "IF/THEN/DO" statement and counting missing variables as less than my , creating false errors.   DATA CLEANING.DATECOMPARE; SET CLEANING.ALLVAX; DATE6WK = HS_DOB + 42; FORMAT DATE6WK DATE9.; RUN;   DATA CLEANING.DATE_DTP; SET CLEANING.DATECOMPARE; IF DTP1-DTP4 NE . THEN DO; IF DTP1 < DATE6WK THEN ERROR = 'DTP_DOSE'; IF DTP2 < DATE6WK THEN ERROR = 'DTP_DOSE'; IF DTP3 < DATE6WK THEN ERROR = 'DTP_DOSE'; IF DTP4 < DATE6WK THEN ERROR = 'DTP_DOSE'; END; IF ERROR NE " " THEN OUTPUT; RUN; ... View more