cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
TPayne
‎10-11-2020
  • 30 Posts
  • 2 Likes Given
  • 0 Solutions
  • 0 Likes Received

macro not cycling through all values

by Fluorite | Level 6 in SAS Programming
‎10-10-2020 10:11 PM
‎10-10-2020 10:11 PM
Hello! I have a dataset I want to do a series of if/then statements with a series of variables that have a prefix i've assigned to a macro value but the macro isn't cycling how it should be. I don't get any errors in the log (see below) but it only produces a result for my last macro value NER. any insight would be helpful please!   code: %MACRO INTERVALS (REGION); %LET REGION=MCR SCR NER; %do i=1 %to %sysfunc(countw(&REGION)); %LET REGIONS= %SCAN(&REGION,&i); %put &REGIONS; DATA DATA.REGIONALVALUES6; SET DATA.REGIONALVALUES5; IF (&REGIONS._HIB_COMPLETE_UCLM < STATE_HIB_COMPLETE_LCLM) THEN &REGIONS._HIB_SIGNIFICANCE=1; RUN; %END; %MEND INTERVALS; %INTERVALS (MCR SCR NER);   log: 5038 %MACRO INTERVALS (REGION); 5039 5040 %LET REGION=MCR SCR NER; 5041 5042 %do i=1 %to %sysfunc(countw(&REGION)); 5043 %LET REGIONS= %SCAN(&REGION,&i); 5044 %put &REGIONS; 5045 5046 DATA DATA.REGIONALVALUES6; 5047 SET DATA.REGIONALVALUES5; 5048 5049 IF (&REGIONS._HIB_COMPLETE_UCLM < STATE_HIB_COMPLETE_LCLM) THEN 5049! &REGIONS._HIB_SIGNIFICANCE=1; 5050 5051 RUN; 5052 5053 %END; 5054 5055 %MEND INTERVALS; 5056 %INTERVALS (MCR SCR NER); MCR NOTE: There were 1 observations read from the data set DATA.REGIONALVALUES5. NOTE: The data set DATA.REGIONALVALUES6 has 1 observations and 758 variables. NOTE: DATA statement used (Total process time): real time 0.45 seconds cpu time 0.03 seconds SCR NOTE: There were 1 observations read from the data set DATA.REGIONALVALUES5. NOTE: The data set DATA.REGIONALVALUES6 has 1 observations and 758 variables. NOTE: DATA statement used (Total process time): real time 0.08 seconds cpu time 0.03 seconds NER NOTE: There were 1 observations read from the data set DATA.REGIONALVALUES5. NOTE: The data set DATA.REGIONALVALUES6 has 1 observations and 758 variables. NOTE: DATA statement used (Total process time): real time 0.06 seconds cpu time 0.01 seconds   ... View more

SAS Macro Do Loop not looping

by Fluorite | Level 6 in SAS Programming
‎10-09-2020 11:55 PM
‎10-09-2020 11:55 PM
Hello!   I have a simple macro do loop where i'm trying to repeat the same proc summary and print to a dataset for each iteration of my specified variable. The below code is what I have written, it does not produce an error however it stays stuck on the first macro var and repeats over and over again.   %MACRO SUMMARY;   %LET i=1; %LET REGIONVAR=NDR KKR MSR HAM; %LET REGION= %SCAN(&REGIONVAR,&i); %PUT REGION; %DO %WHILE (&REGION NE );   PROC SUMMARY DATA=&REGION;     VAR HIB_COMPLETE HIB2_COMPLETE RTV_COMPLETE DTP_COMPLETE DTP3_COMPLETE OPV_COMPLETE MMR_COMPLETE HBV_COMPLETE       VAX_COMPLETE PCV_COMPLETE PCV2_COMPLETE FLU_COMPLETE FLU3_COMPLETE FLU_6MONTHS HAV_COMPLETE HAV2_COMPLETE COMPLETE431FS314 HBV_BD_COMPLETE;     OUTPUT OUT=CI MEAN= LCLM= UCLM=/AUTONAME; RUN;   DATA &REGION._CI;     IF _N_=1 THEN SET CI(DROP=_TYPE_ _FREQ_);     SET &REGION; RUN;   %END; %MEND SUMMARY; %SUMMARY (NDR KKR MSR HAM);     the log is just this over and over, which is correct, but I also need this result for KKR, MSR, HAM etc. NOTE: There were 192754 observations read from the data set WORK.NDR. NOTE: The data set WORK.CI has 1 observations and 56 variables. NOTE: PROCEDURE SUMMARY used (Total process time): real time 0.12 seconds cpu time 0.51 seconds   NOTE: There were 1 observations read from the data set WORK.CI. NOTE: There were 192754 observations read from the data set WORK.NDR. NOTE: The data set WORK.NDR_CI has 192754 observations and 114 variables. NOTE: DATA statement used (Total process time): real time 0.17 seconds cpu time 0.18 seconds     Any insight would be helpful, thank you!   ... View more

Re: PROC REPORT COMPUTE STATEMENT VARIABLE NOT INITIALIZED

by Fluorite | Level 6 in SAS Programming
‎03-11-2020 10:24 AM
‎03-11-2020 10:24 AM
Hi Paige!    I do not have a variable error_count7 in my report or my compute statement. could you please explain what you meant?   Also, thank you, I did no realize it computes left to right. Rearranging the columns worked! ... View more

PROC REPORT COMPUTE STATEMENT VARIABLE NOT INITIALIZED

by Fluorite | Level 6 in SAS Programming
‎03-11-2020 09:29 AM
‎03-11-2020 09:29 AM
Hello!   I am trying to use a compute statement in my proc report and keep getting the error that the variable error_count is uninitialized, even when included in the proc report. Additionally, my other variables in my compute statements are not changing background in my proc report even if the condition is met. Am I missing something? Thanks so much!     COLUMN VFC_PIN REGION FACILITY_NAME FACILITY_TYPE ERROR_COUNT DTAP EXPECTED_DTAP HEPA EXPECTED_HEPA HIB EXPECTED_HIB POLIO EXPECTED_IPV MMR EXPECTED_MMR PCV EXPECTED_PCV RTV EXPECTED_RTV VARICELLA EXPECTED_VAR ERROR1 ERROR2 ERROR3 ERROR4 ERROR5 ERROR6 ERROR7 ERROR8;   DEFINE VFC_PIN  / CENTER "VFC PIN" STYLE(COLUMN)=[BACKGROUND=WHITE] STYLE={TAGATTR='FORMAT:@'};; DEFINE REGION  / CENTER "REGION" STYLE(COLUMN)=[BACKGROUND=WHITE]; DEFINE FACILITY_NAME / CENTER "FACILITY NAME" STYLE(COLUMN)=[BACKGROUND=WHITE]; DEFINE FACILITY_TYPE / CENTER "FACILITY TYPE" STYLE(COLUMN)=[BACKGROUND=WHITE]; DEFINE ERROR_COUNT / CENTER "# INCORRECT VACCINES" STYLE(COLUMN)=[BACKGROUND=WHITE]; DEFINE DTAP / CENTER "DTP USED" STYLE(COLUMN)=[BACKGROUND=WHITE]; DEFINE EXPECTED_DTAP / CENTER "DTP EXPECTED" STYLE(COLUMN)=[BACKGROUND=WHITE]; DEFINE HEPA / CENTER "HAV USED" STYLE(COLUMN)=[BACKGROUND=WHITE]; DEFINE EXPECTED_HEPA / CENTER "HAV EXPECTED" STYLE(COLUMN)=[BACKGROUND=WHITE]; DEFINE HIB / CENTER "HIB USED" STYLE(COLUMN)=[BACKGROUND=WHITE]; DEFINE EXPECTED_HIB / CENTER "HIB EXPECTED" STYLE(COLUMN)=[BACKGROUND=WHITE]; DEFINE POLIO / CENTER "POLIO USED" STYLE(COLUMN)=[BACKGROUND=WHITE]; DEFINE EXPECTED_IPV / CENTER "POLIO EXPECTED" STYLE(COLUMN)=[BACKGROUND=WHITE]; DEFINE MMR / CENTER "MMR USED" STYLE(COLUMN)=[BACKGROUND=WHITE]; DEFINE EXPECTED_MMR / CENTER "MMR EXPECTED" STYLE(COLUMN)=[BACKGROUND=WHITE]; DEFINE PCV / CENTER "PCV USED" STYLE(COLUMN)=[BACKGROUND=WHITE]; DEFINE EXPECTED_PCV / CENTER "PCV EXPECTED" STYLE(COLUMN)=[BACKGROUND=WHITE]; DEFINE RTV / CENTER "RTV USED" STYLE(COLUMN)=[BACKGROUND=WHITE]; DEFINE EXPECTED_RTV / CENTER "RTV EXPECTED" STYLE(COLUMN)=[BACKGROUND=WHITE]; DEFINE VARICELLA / CENTER "VAR USED" STYLE(COLUMN)=[BACKGROUND=WHITE]; DEFINE EXPECTED_VAR / CENTER "VAR EXPECTED" STYLE(COLUMN)=[BACKGROUND=WHITE]; DEFINE ERROR1 / NOPRINT; DEFINE ERROR2 / NOPRINT; DEFINE ERROR3 / NOPRINT; DEFINE ERROR4 / NOPRINT; DEFINE ERROR5 / NOPRINT; DEFINE ERROR6 / NOPRINT; DEFINE ERROR7 / NOPRINT; DEFINE ERROR8 / NOPRINT; compute error_count; if error_count=7 then call define(_col_,'style','style={background=LIGHTRED}'); endcomp; compute dtap; if error1=1 then call define(_col_,'style','style={background=LIGHTRED}'); endcomp; compute hepa; if error2=1 then call define(_col_,'style','style={background=LIGHTRED}'); endcomp; compute hib; if error3=1 then call define(_col_,'style','style={background=LIGHTRED}'); endcomp; compute polio; if error4=1 then call define(_col_,'style','style={background=LIGHTRED}'); endcomp; compute mmr; if error5=1 then call define(_col_,'style','style={background=LIGHTRED}'); endcomp; compute pcv; if error6=1 then call define(_col_,'style','style={background=LIGHTRED}'); endcomp; compute rtv; if error7=1 then call define(_col_,'style','style={background=LIGHTRED}'); endcomp; compute varicella; if error8=1 then call define(_col_,'style','style={background=LIGHTRED}'); endcomp; run; ODS TAGSETS.EXCELXP CLOSE; ... View more

Re: calculate statistical significance and turn it in to a variable

by Fluorite | Level 6 in SAS Programming
‎12-17-2019 01:52 PM
‎12-17-2019 01:52 PM
Hi Paige,   Thanks for sharing this resource- I am unable to perform this test with the way my data is currently formatted but can manipulate it. Additionally, Is there a way to print the output of the results as a variable in my final dataset? I ultimately will need to perform this many times. ... View more

Re: calculate statistical significance and turn it in to a variable

by Fluorite | Level 6 in SAS Programming
‎12-17-2019 12:03 PM
‎12-17-2019 12:03 PM
Hi Paige!   Thank you for pointing this out - I get these numbers by taking a dataset of boolean variables where each line is a record_id, and 1 is if that record is considered complete for a vaccine or not. I then break that dataset apart by region and run a proc summary for each region, then add that output as a variable to eachbroken apart dataset. I merge datasets back together, transpose, and end up with my originally posted dataset. I will do my best to explain it below:   I start with dataset STANDARD:   record_id region DTaP OPV 1163 REG  1 1 1198 REG  1 1 1560 REG  0 0 1660 REG  1 1 1678 REG  0 0 1163 STATE 1 1 1198 STATE 1 1 1560 STATE 0 1 1660 STATE 1 1 1678 STATE 1 1   and I break it apart to be two datasets: REG and STATE, respectively (based off of region)   I then run a proc summary on each of these datasets to that looks like this:   proc summary data=reg var DTaP OPV; output out=CI MEAN= LCLM= UCLM= /AUTONAME: run;   data reg2; if _n_=1 then set CI(drop= _TYPE_ _FREQ_); set reg; run;   proc summary data=state var DTaP OPV; output out=CI MEAN= LCLM= UCLM= /AUTONAME: run;   data state2; if _n_=1 then set CI(drop= _TYPE_ _FREQ_); set state; run;   data confidenceintervals; set reg2 state2; run;   this creates a final dataset that looks like this:  record_id  region DTaP_Mean DTaP_UCLM DTaP_LCLM OPV_Mean OPV_UCLM OPV_LCLM 1163 REG  0.76521739 0.84385961 0.68657518 0.86956522 0.93205056 0.8070799 1198 REG  0.76521739 0.84385961 0.68657518 0.86956522 0.93205056 0.8070799 1560 REG  0.76521739 0.84385961 0.68657518 0.86956522 0.93205056 0.8070799 1660 REG  0.76521739 0.84385961 0.68657518 0.86956522 0.93205056 0.8070799 1678 REG  0.76521739 0.84385961 0.68657518 0.86956522 0.93205056 0.8070799 1163 STATE 0.80108992 0.82153367 0.78064617 0.91008174 0.92473235 0.8954311 1198 STATE 0.80108992 0.82153367 0.78064617 0.91008174 0.92473235 0.8954311 1560 STATE 0.80108992 0.82153367 0.78064617 0.91008174 0.92473235 0.8954311 1660 STATE 0.80108992 0.82153367 0.78064617 0.91008174 0.92473235 0.8954311 2202 STATE 0.80108992 0.82153367 0.78064617 0.91008174 0.92473235 0.8954311   through a series of transpositions and a few other manipulations, I end up with a dataset that is formatted for the application I ultimately have to upload the information in to. this is the dataset I was referring to earlier. I was thinking I would want to wait until this step to look at statistical significance because I am only curious about results at the regional level, not if a record_id was different than state results or not   Name Value Lower_ Limit Upper_Limit REG_DTP_COMPLETE_Mean 0.87826087 0.81759321 0.938928527 REG_OPV_COMPLETE_Mean 0.869565217 0.80707988 0.932050559 STATE_DTP_COMPLETE_Mean 0.801089918 0.78064617 0.821533667 STATE_OPV_COMPLETE_Mean 0.910081744 0.89543114 0.924732351 ... View more

calculate statistical significance and turn it in to a variable

by Fluorite | Level 6 in SAS Programming
‎12-17-2019 10:24 AM
‎12-17-2019 10:24 AM
Hello,   i have a dataset where regions are listed under the "Name" column, their mean under the "Value" column and their lower limit and upper limit of their confidence interval. I want to take the lower and upper limits of a section of the "Name" column and compare it to another section in the same column to determine statistical significance. The only way I can think of involves way more if/then statements than i'd like to do- I am sure there is a more efficient way. Below is my dataset, where I would like to create a variable "SIGNIFICANCE" that is either 1 if the value of REG_FLU_COMPLETE_MEAN is statistically significantly different than the value of STATE_FLU_COMPLETE_MEAN etc.....   Name Value Lower_ Limit Upper_Limit REG_FLU_COMPLETE_Mean 0.834782609 0.76587853 0.903686689 REG_HIB_COMPLETE_Mean 0.765217391 0.68657518 0.843859607 REG_RTV_COMPLETE_Mean 0.765217391 0.68657518 0.843859607 REG_DTP_COMPLETE_Mean 0.87826087 0.81759321 0.938928527 REG_OPV_COMPLETE_Mean 0.869565217 0.80707988 0.932050559 REG_HBV_COMPLETE_Mean 0.886956522 0.82820701 0.945706036 REG_VAX_COMPLETE_Mean 0.826086957 0.75576202 0.896411889 STATE_FLU_COMPLETE_Mean 0.848092643 0.82971023 0.866475057 STATE_HIB_COMPLETE_Mean 0.801089918 0.78064617 0.821533667 STATE_RTV_COMPLETE_Mean 0.773160763 0.75171283 0.794608698 STATE_DTP_COMPLETE_Mean 0.801089918 0.78064617 0.821533667 STATE_OPV_COMPLETE_Mean 0.910081744 0.89543114 0.924732351 STATE_HBV_COMPLETE_Mean 0.914168937 0.89982306 0.92851481 STATE_VAX_COMPLETE_Mean 0.873297003 0.85626107 0.890332936   Thank you!!! ... View more

Re: Array to set criteria to missing not working

by Fluorite | Level 6 in SAS Programming
‎11-26-2019 03:26 PM
‎11-26-2019 03:26 PM
Hi Paige! that is correct- I just want any dose past date25 to be missing!  ... View more

Re: Array to set criteria to missing not working

by Fluorite | Level 6 in SAS Programming
‎11-26-2019 03:02 PM
‎11-26-2019 03:02 PM
Hi Paige!   I edited my post to contain the correct code:   /*CREATE VARIABLE TO CHECK COMPLETENESS BY 25 MONTH WITH*/ DATA COMPLETE2; SET ALLVAX3; DATE25= HS_DOB + 760; FORMAT DATE25 mmddyy10.; RUN;   /* SET ANY VACCINATIONS OVER 2YR OLD TO MISSING*/ DATA COMPLETE_DATECHECK (DROP=I); SET COMPLETE2; ARRAY DTP(8) DTP1-DTP8; DO I= 1 TO 8; IF DTP[1] > DATE25 > . THEN DTP[I]= .; END; RUN;   For results when I run this, no dates change (i.e. DTP4 for record id 224 and 254 stays the same rather than turning to missing.) The dataset after running the code looks like this:   record_id hs_dob DTP1 DTP2 DTP3 DTP4 DTP5 DTP6 DTP7 DTP8 DATE25 224 1/5/2016 3/31/2016 7/18/2016 5/2/2017 8/8/2018         2/3/2018 227 1/5/2016 3/11/2016 5/20/2016 7/11/2016 4/26/2017         2/3/2018 245 1/4/2016 3/18/2016 5/9/2016 7/11/2016 4/5/2017         2/2/2018 254 1/5/2016 3/4/2016 8/2/2016 10/5/2016 5/11/2018         2/3/2018 ... View more

Re: Array to set criteria to missing not working

by Fluorite | Level 6 in SAS Programming
‎11-26-2019 02:48 PM
‎11-26-2019 02:48 PM
I accidentally copied code in to my post from when I was trouble-shooting the issue. My original code is what you have suggested, but that does not produce the expected results either. ... View more

Array to set criteria to missing not working

by Fluorite | Level 6 in SAS Programming
‎11-26-2019 02:39 PM
‎11-26-2019 02:39 PM
Hello,   I have a dataset that is pulling in vaccination dates. I want to compare these dates to a specific date and set any vaccination dates to missing if they are after the comparison date. I have the following code, but the dates I would expect to be set to missing are not. Any insight would be helpful.   /*CREATE VARIABLE TO CHECK COMPLETENESS BY 25 MONTH WITH*/ DATA COMPLETE2; SET ALLVAX3; DATE25= HS_DOB + 760; FORMAT DATE25 mmddyy10.; RUN;   /* SET ANY VACCINATIONS OVER 2YR OLD TO MISSING*/ DATA COMPLETE_DATECHECK (DROP=I); SET COMPLETE2; ARRAY DTP(8) DTP1-DTP8; DO I= 1 TO 8; IF DTP[1] > DATE25 > . THEN DTP[I]= .; END; RUN;   All dates are formatted mmddyy10.   example dataset:   record_id hs_dob DTP1 DTP2 DTP3 DTP4 DTP5 DTP6 DTP7 DTP8 DATE25 224 1/5/2016 3/31/2016 7/18/2016 5/2/2017 8/8/2018         2/3/2018 227 1/5/2016 3/11/2016 5/20/2016 7/11/2016 4/26/2017         2/3/2018 245 1/4/2016 3/18/2016 5/9/2016 7/11/2016 4/5/2017         2/2/2018 254 1/5/2016 3/4/2016 8/2/2016 10/5/2016 5/11/2018         2/3/2018 In the above table, I would expect DTP4 for records 224 and 254 to be set to missing.   Thank you! ... View more

if/then with index recoding all cases

by Fluorite | Level 6 in SAS Programming
‎10-18-2019 12:04 PM
‎10-18-2019 12:04 PM
Hello!   I have a dataset that is formatted kind of oddly (but must be in this format to output the way i need it to). Because of that, a simple if/then statement to create a different variable won't do. I have attempted to do a findw and an index of the variable I want to scan for and all that happens is the variable gets overwritten to the last if/then statement. What am I missing (seems fairly simple but i'm missing a piece somewhere). any insight helps. Thanks!   What I want: vaccine          mean       goal   dtp_m_w            98          90 dtp_m_e             76         90 opv_m_w           56          80 opv_m_w           75          80   What i'm getting: vaccine          mean       goal   dtp_m_w            98           80 dtp_m_e             76          80 opv_m_w           56          80 opv_m_w           75          80       Code I've tried:   data test; set sample; if index(vaccine, 'dtp') ne "" then do; goal=90; end; if index(vaccine, 'opv') ne "" then do; goal=80; end; run;   i've also tried:   data test; set sample; if findw(vaccine, 'dtp') ne "" then goal=90; if findw(vaccine, 'opv) ne "" then goal=80; run;       ... View more

Re: scan all variables and keep only subset

by Fluorite | Level 6 in SAS Programming
‎10-15-2019 09:26 AM
‎10-15-2019 09:26 AM
That worked- thank you so much ... View more

scan all variables and keep only subset

by Fluorite | Level 6 in SAS Programming
‎10-15-2019 09:00 AM
‎10-15-2019 09:00 AM
Hello,   I have a dataset with over 1000 variables, I want to scan this entire dataset and create a subset of data that contains all variables with the suffix "_MEAN" Any insight would help. Thanks!     cat_mean   cat_toy  dog_mean  dog_toy   bird_mean   bird_toy        7.00           2           0.987          56               1.345       67     What I want:    cat_mean   dog_mean    bird_mean    7.00              0.987           1.345       ... View more

Re: turn proc univariate results into variable

by Fluorite | Level 6 in SAS Programming
‎09-17-2019 03:57 PM
‎09-17-2019 03:57 PM
Hello!   That definitely worked- thanks so much! Is there a way to include multiple variables (when I add more, it only calculates for the first variable)   example: ods output basicintervals=ci; proc univariate data=DATA.STANDARD_NO cibasic; var HIB_COMPLETE THREEDOSECOMP FOURDOSECOMP RTV_COMPLETE run;   This only gives HIB_Complete responses  ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎10-11-2020 01:53 AM
Likes given to
View All
Quick links