This worked beautifully!  Thank you! ... View more

Each projid should have 13 observations/rows.  In the example I show in the screenshot, the original data source does not include a row for observation 10 (for 10 years).  I need to get a blank row added that would be for observation 10 (10 years).   In another example, the projid had 2 observations (baseline and 1 year), so in this case I need to add the blank rows for years 3 through 13.   This code shows how the time variable is formatted.   value timept 0="Baseline" 1="1 year" 2="2 year" 3="3 year" 4="4 year" 5="5 year" 6="6 year" 7="7 year" 8="8 year" 9="9 year" 10="10 year" 11="11 year" 12="12 year" 13="13 year" 14="14 year" 15="15 year" 16="16 year" 17="17 year" 18="18 year" 19="19 year"; Thanks!   ... View more

Thank you!! ... View more

Thank you! That worked 😊 ... View more

Here is the code I am using now.  The temp file is successfully created in another program:   data out; set temp; *OTHER NEUROLOGICAL DISEASES; array xx $ icdx1 icdx2 icdx3; label ond="Oth neurological"; ond=0; do over xx; if xx in: ("B90", "D48", "G04", "G09", "G10", "G11", "G12", "G13", "G24", "G25", "G26", "G32", "G37", "G51", "G52", "G53", "G70", "G71", "G72", "G73", "G80", "G81", "G82", "G83", "G90", "G91", "G93", "G95", "G99", "M47", "Q00", "Q01", "Q02", "Q03", "Q04", "Q05", "Q06", "Q07", "Q76") then ond = 1; *Doing exclusions in this way does not work; if xx in: ("G130", "G131", "G251", "G254", "G256", "G510", "G732", "G733", "G734", "G838") then ond=0; end; run; And here is the SAS log: 1 The SAS System 13:40 Tuesday, May 21, 2024 1 ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; 3 %LET _CLIENTTASKLABEL='Program'; 4 %LET _CLIENTPROCESSFLOWNAME='Process Flow'; 5 %LET 5 ! _ 8 %LET _SASPROGRAMFILE=''; 9 %LET _SASPROGRAMFILEHOST=''; 10 11 ODS _ALL_ CLOSE; 12 OPTIONS DEV=PNG; 13 GOPTIONS XPIXELS=0 YPIXELS=0; 14 %macro HTML5AccessibleGraphSupported; 15 %if %_SAS_VERCOMP_FV(9,4,4, 0,0,0) >= 0 %then ACCESSIBLE_GRAPH; 16 %mend; 17 FILENAME EGRTF TEMP; 18 ODS RTF(ID=EGRTF) FILE=EGRTF 19 ENCODING='utf-8' 20 STYLE=Journal 21 NOGTITLE 22 NOGFOOTNOTE 23 KEEPN 24 STARTPAGE=NO BODYTITLE 25 ; NOTE: Writing RTF Body file: EGRTF 26 FILENAME EGPDF TEMP; 27 ODS PDF(ID=EGPDF) FILE=EGPDF STYLE=Journal NOTOC STARTPAGE=NO; NOTE: Writing ODS PDF(EGPDF) output to DISK destination "EGPDF", printer "PDF". 28 FILENAME EGSR TEMP; 29 ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR 30 STYLE=HTMLBlue 31 NOGTITLE 32 NOGFOOTNOTE 33 GPATH=&sasworklocation 34 ENCODING=UTF8 35 options(rolap="on") 36 ; NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR 37 FILENAME EGXLSSX TEMP; 38 ODS EXCEL(ID=EGXLSSX) FILE=EGXLSSX STYLE=Excel 39 OPTIONS ( 40 EMBEDDED_TITLES="yes" EMBEDDED_FOOTNOTES="yes" 41 ); 42 43 44 45 46 47 48 data out; 49 set temp; 50 51 *OTHER NEUROLOGICAL DISEASES; 52 array xx $ icdx1 icdx2 icdx3; 53 label ond="Oth neurological"; 54 ond=0; 55 do over xx; 56 if xx in: ("B90", "D48", "G04", "G09", "G10", "G11", "G12", 57 "G13", "G24", "G25", "G26", "G32", "G37", "G51", "G52", "G53", 58 "G70", "G71", "G72", "G73", "G80", "G81", "G82", "G83", "G90", 59 "G91", "G93", "G95", "G99", "M47", "Q00", "Q01", "Q02", "Q03", 60 "Q04", "Q05", "Q06", "Q07", "Q76") then ond = 1; 61 *Doing exclusions in this way does not work; 62 if xx in: ("G130", "G131", "G251", "G254", "G256", "G510", "G732", _ 22 202 62 ! "G733", "G734", "G838") then ond=0; ERROR 22-322: Syntax error, expecting one of the following: a quoted string, a numeric constant, a datetime constant, a missing value, iterator, (. ERROR 202-322: The option or parameter is not recognized and will be ignored. 63 end; 64 65 run; NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.OUT may be incomplete. When this step was stopped there were 0 observations and 475 variables. WARNING: Data set WORK.OUT was not replaced because this step was stopped. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 66 67 %LET _CLIENTTASKLABEL=; 68 %LET _CLIENTPROCESSFLOWNAME=; 69 %LET _CLIENTPROJECTPATH=; 70 %LET _CLIENTPROJECTPATHHOST=; 71 %LET _CLIENTPROJECTNAME=; 72 %LET _SASPROGRAMFILE=; 73 %LET _SASPROGRAMFILEHOST=; 74 75 ;*';*";*/;quit;run; 76 ODS _ALL_ CLOSE; NOTE: ODS PDF(EGPDF) printed no output. (This sometimes results from failing to place a RUN statement before the ODS PDF(EGPDF) CLOSE statement.) NOTE: Writing EXCEL(EGXLSSX) file: C:\Users\mlhein\AppData\Roaming\SAS\EnterpriseGuide\EGTEMP\SEG-20684-fc692 816\contents\SAS Temporary Files\_TD4660_NRSG-NB-412L_\#LN01027 77 78 79 QUIT; RUN; 80 ... View more

data out; set temp; *OTHER NEUROLOGICAL DISEASES; array xx $ icdx1 icdx2 icdx3; label ond="Oth neurological"; ond=0; do over xx; if xx in: ("B90", "D48", "G04", "G09", "G10", "G11", "G12", "G13", "G24", "G25", "G26", "G32", "G37", "G51", "G52", "G53", "G70", "G71", "G72", "G73", "G80", "G81", "G82", "G83", "G90", "G91", "G93", "G95", "G99", "M47", "Q00", "Q01", "Q02", "Q03", "Q04", "Q05", "Q06", "Q07", "Q76") then ond = 1; *Doing exclusions in this way does not work; if xx in: ("G130", "G131", "G251", "G254", "G256", "G510", "G732", "G733", "G734", "G838") then ond=0; end; run;   1 The SAS System 13:40 Tuesday, May 21, 2024 1 ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; 3 %LET _CLIENTTASKLABEL='Program'; 4 %LET _CLIENTPROCESSFLOWNAME='Process Flow'; 5 %LET 5 ! _CLIENTPROJECTPATH='\\data.healthcare.uiowa.edu\research\icts\icts-dr 5 ! -chae-research\1682265_Chae\OVPR\SAS\pgm\csamlovpr.egp'; 6 %LET _CLIENTPROJECTPATHHOST='NRSG-NB-412L'; 7 %LET _CLIENTPROJECTNAME='csamlovpr.egp'; 8 %LET _SASPROGRAMFILE=''; 9 %LET _SASPROGRAMFILEHOST=''; 10 11 ODS _ALL_ CLOSE; 12 OPTIONS DEV=PNG; 13 GOPTIONS XPIXELS=0 YPIXELS=0; 14 %macro HTML5AccessibleGraphSupported; 15 %if %_SAS_VERCOMP_FV(9,4,4, 0,0,0) >= 0 %then ACCESSIBLE_GRAPH; 16 %mend; 17 FILENAME EGRTF TEMP; 18 ODS RTF(ID=EGRTF) FILE=EGRTF 19 ENCODING='utf-8' 20 STYLE=Journal 21 NOGTITLE 22 NOGFOOTNOTE 23 KEEPN 24 STARTPAGE=NO BODYTITLE 25 ; NOTE: Writing RTF Body file: EGRTF 26 FILENAME EGPDF TEMP; 27 ODS PDF(ID=EGPDF) FILE=EGPDF STYLE=Journal NOTOC STARTPAGE=NO; NOTE: Writing ODS PDF(EGPDF) output to DISK destination "EGPDF", printer "PDF". 28 FILENAME EGSR TEMP; 29 ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR 30 STYLE=HTMLBlue 31 NOGTITLE 32 NOGFOOTNOTE 33 GPATH=&sasworklocation 34 ENCODING=UTF8 35 options(rolap="on") 36 ; NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR 37 FILENAME EGXLSSX TEMP; 38 ODS EXCEL(ID=EGXLSSX) FILE=EGXLSSX STYLE=Excel 39 OPTIONS ( 40 EMBEDDED_TITLES="yes" EMBEDDED_FOOTNOTES="yes" 41 ); 42 43 44 data out; 45 set temp; 46 47 *OTHER NEUROLOGICAL DISEASES; 48 array xx $ icdx1 icdx2 icdx3; 49 label ond="Oth neurological"; 50 ond=0; 51 do over xx; 52 if xx in: ("B90", "D48", "G04", "G09", "G10", "G11", "G12", 53 "G13", "G24", "G25", "G26", "G32", "G37", "G51", "G52", "G53", 54 "G70", "G71", "G72", "G73", "G80", "G81", "G82", "G83", "G90", 55 "G91", "G93", "G95", "G99", "M47", "Q00", "Q01", "Q02", "Q03", 56 "Q04", "Q05", "Q06", "Q07", "Q76") then ond = 1; 57 *Doing exclusions in this way does not work; 58 if xx in: ("G130", "G131", "G251", "G254", "G256", "G510", "G732", _ 22 202 58 ! "G733", "G734", "G838") then ond=0; ERROR 22-322: Syntax error, expecting one of the following: a quoted string, a numeric constant, a datetime constant, a missing value, iterator, (. ERROR 202-322: The option or parameter is not recognized and will be ignored. 59 end; 60 61 run; NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.OUT may be incomplete. When this step was stopped there were 0 observations and 475 variables. NOTE: DATA statement used (Total process time): real time 0.04 seconds cpu time 0.00 seconds 62 63 %LET _CLIENTTASKLABEL=; 64 %LET _CLIENTPROCESSFLOWNAME=; 65 %LET _CLIENTPROJECTPATH=; 66 %LET _CLIENTPROJECTPATHHOST=; 67 %LET _CLIENTPROJECTNAME=; 68 %LET _SASPROGRAMFILE=; 69 %LET _SASPROGRAMFILEHOST=; 70 71 ;*';*";*/;quit;run; 72 ODS _ALL_ CLOSE; NOTE: ODS PDF(EGPDF) printed no output. (This sometimes results from failing to place a RUN statement before the ODS PDF(EGPDF) CLOSE statement.) NOTE: Writing EXCEL(EGXLSSX) file: C:\Users\mlhein\AppData\Roaming\SAS\EnterpriseGuide\EGTEMP\SEG-20684-fc692 816\contents\SAS Temporary Files\_TD4660_NRSG-NB-412L_\#LN00551 73 74 75 QUIT; RUN; 76 ... View more

Thanks! ... View more

Thanks! ... View more

This worked for me, thanks! ... View more

The variables are all binary, with values of 0 or 1.  Numeric variables.   Each variable is for a different medical diagnosis category.  1=Yes (patient has that disease), 0=No (patient does not have that disease)   I need to find the most common disease pairings that co-occur in patients.   Here is code that I wrote for 5 variables (see below), but I need to do this for all possible pairings of 60 variables.   if v1=1 and v2=1 then v1v2=1; if v1=1 and v3=1 then v1v3=1; if v1=1 and v4=1 then v1v4=1; if v1=1 and v5=1 then v1v5=1;   if v2=1 and v3=1 then v1v3=1; if v2=1 and v4=1 then v1v4=1; if v2=1 and v5=1 then v1v5=1;   if v3=1 and v4=1 then v1v4=1; if v3=1 and v5=1 then v1v5=1;   if v4=1 and v5=1 then v1v5=1;   Thanks! ... View more

The variables are all binary, with values of 0 or 1. Numeric variables. Each variable is for a different medical diagnosis category. 1=Yes (patient has that disease) 0=No (patient does not have that disease) I need to find the most common disease pairings that co-occur in patients. ... View more