I have a table designed like this:   ID          HCC_1         HCC_2....      HCC_254 313         0                     1                    1    It has 58k rows and 129 columns. One column is the ID field (the key) and the other 128 columns are binary (1 or 0) indicators.   Essentially I'm trying to figure out the frequency that any two indicators are both 1 for all the records vs. one of them being 0.   If I use the following code my SAS freezes:   PROC FREQ DATA=WORK.HCC_COMBORID_STEP3; TABLES (HCC_1 -- HCC_254) * (HCC_1 -- HCC_254); RUN; I can make this project workable by just doing this:   PROC FREQ DATA=WORK.HCC_COMBORID_STEP3; TABLES (HCC_1) * (HCC_1 -- HCC_254); where hcc_1 = 1; RUN; But that would mean doing that 128 times and that seems wildly inefficient.   Any suggestions for how I can simplify this? ... View more

Hello,   I'm using ODS Excel to output a data table and I've noticed that the output is being altered from the original by eliminating spaces.   Code: ods excel file="\\hne_crms\hsra\RLafond\Quality\QIP\test3\&NAME._&LOB._QIP_Roster_&reportdate..xlsx"; ods excel options(sheet_name="&Name Roster &Month &Year"); PROC PRINT DATA = &NAME._&LOB._STEP2 NOOBS; RUN; ODS excel close; Examples: Source: VBC Group B Output: VBC GroupB   Source: Adult BMI Assessment Output: Adult BMIAssessment   Source: Appropriate Testing for Children with Pharyngitis Output: Appropriate Testingfor Children withPharyngitis   It looks almost like some sort of formatting being done to replicate wrapping in Excel. Any idea why this is happening and how I can stop it? I've included an image showing what it looks like in Excel: ... View more

I'm getting a single instance of duplication in a DATA step that I cannot figure out.   Input data: PatID FromDate ThruDate ProvID 1000 3/3/2017 3/3/2017 222 1000 3/6/2017 3/6/2017 222 1000 3/7/2017 3/7/2017 222 1000 3/8/2017 3/8/2017 222 1000 3/9/2017 3/9/2017 222 1000 3/10/2017 3/10/2017 222 1000 5/8/2017 5/8/2017 222 1000 5/9/2017 5/9/2017 222 1000 5/10/2017 5/10/2017 222 1000 5/11/2017 5/11/2017 222 1000 5/12/2017 5/12/2017 222 1000 5/15/2017 5/15/2017 222 1000 6/27/2017 6/27/2017 999   Code: DATA STEP2; KEEP PATID FromDate_NEW ThruDate ProvID; RENAME FromDate_NEW = FromDate; SET STEP1; BY PATID ProvID; MERGE STEP1 STEP1 (FIRSTOBS=2 KEEP=FromDate RENAME=(FromDate=_NEXT_FROM)); RETAIN FromDate_NEW ThruDate_LAST; FORMAT FromDate_NEW MMDDYY10. ThruDate_LAST MMDDYY10.; IF FIRST.PATID or first.ProvID THEN DO; ThruDate_LAST = .;   FromDate_NEW=FromDate; END; ELSE DO; IF FromDate - ThruDate_LAST > 2 THEN FromDate_NEW = FromDate; END;   ThruDate_LAST=ThruDate; IF LAST.PATID or last.ProvID THEN OUTPUT; if LAST.PATID=0 AND _next_from - ThruDate > 2 THEN OUTPUT; RUN;   Output:   PatID ThruDate ProvID FromDate 1000 3/3/2017 222 3/3/2017 1000 3/10/2017 222 3/6/2017 1000 5/12/2017 222 5/8/2017 1000 5/15/2017 222 5/15/2017 1000 5/15/2017 222 5/15/2017 1000 6/27/2017 999 6/27/2017   Desired output: PatID ThruDate ProvID FromDate 1000 3/3/2017 222 3/3/2017 1000 3/10/2017 222 3/6/2017 1000 5/12/2017 222 5/8/2017 1000 5/15/2017 222 5/15/2017 1000 6/27/2017 999 6/27/2017   Any idea why I'm getting duplication when FromDate = 5/15/17 and ProvID = 222?   Thanks! ... View more

Hello all,   I have a data set setup like this:   ID Date Code 100 5/13/2019 HCC-5 100 5/13/2019 HCC-9 100 5/13/2019 HCC-36 101 4/10/2019 HCC-4 101 4/10/2019 HCC-101   For every combination of ID and Date, I have a variable number of Code values.   For every combination of ID and Date, I need to review the list of Code values present to see if they satisfy a rule. A rule is whether two specific Code values are present for a combination of ID and Date. I have 37 rules total.   If a rule is satisfied, I need to write a new record for that ID and Date with the rule number. Multiple rules can be satisfied for each combination of ID and Date.   EXAMPLE:   Supposed one of my rules is the presence of HCC-9 and HCC-36 = HCC-900.   In the above table, when ID=100 and Date = 5/13/2019, this rule is satisfied. So my new data set should look like this:   ID Date Code 100 5/13/2019 HCC-5 100 5/13/2019 HCC-9 100 5/13/2019 HCC-36 100 5/13/2019 HCC-900 101 4/10/2019 HCC-4 101 4/10/2019 HCC-101   I have not written the rules table yet because I'm not sure what the best way is to compose it (wide? long?).   Any thoughts? Not sure how to approach this.     ... View more

I have a long data set. Here is a sample: ID BaseEventDate Diag1 SURG_IND Discharge_CC 1 7/22/2018 K353 N   2 7/5/2018 E1152 N CC-106 2 7/5/2018 E1152 N CC-108 2 7/5/2018 E1152 N CC-18 3 3/13/2018 A419 N CC-2 I'm using an array to make it wide based on the Discharge_CC column. Each unique instance of ID and BaseEventDate should have a record.   Here is my SAS code:   DATA STEP6; SET WORK.STEP5; BY ID BaseEventDate; ARRAY dcc (3) $ DCC1-DCC3; IF FIRST.ID or FIRST.BaseEventDate THEN i=1; dcc(i) = DISCHARGE_CC; retain dcc1-dcc3; if last.BaseEventDate or last.ID then output; i+1; drop DISCHARGE_CC i; run;   But here is my output: ID BaseEventDate Diag1 SURG_IND DCC1 DCC2 DCC3 1 7/22/2018 K353 N       2 7/5/2018 E1152 N CC-106 CC-108 CC-18 3 3/13/2018 A419 N CC-2 CC-108 CC-18   I don't get why DCC2 and DCC3 from ID 2 are being retained with ID 3. Any ideas? ... View more