About bknitch

bknitch · ‎08-26-2021

@kurtbrmser this actually was the solution! Thank you i just placed it in the incorrect spot.

bknitch · ‎08-26-2021

I've edited the post to reflect the entire code

bknitch · ‎08-26-2021

I'm receiving the following error for the code above: 31 format incdt mmddyy10.; 32 incmonthid = YEAR(disdt_c)*100+MONTH(disdt_c); 33 yr = YEAR(disdt_c); 34 end; ___ 161 35 else do; ____ 160 ERROR 161-185: No matching DO/SELECT statement. ERROR 160-185: No matching IF-THEN clause. Not sure what the issue is.

bknitch · ‎08-26-2021

@maguiremq this worked quite well. Thank you for this. I modified it slightly to include hierarchy. Thank you very much. Both you and another use provided solutions.

bknitch · ‎08-25-2021

So for that I'm only concerned where if Missing is higher in the hierarchy. Meaning, if an A3 was populated in 2019 and not populated in 2020 but an A2 was populated in 2020 and not in 2019 I would exclude this/ or not look at this record. Hope that makes sense...

bknitch · ‎08-25-2021

@PaigeMiller in this case it would be Member= 124 had an A1= 1 in 2019 but an A1=0 in 2020 this qualifies as 'Missing', A2=1 in 2019 and A2=1 in 2020 so this qualifies as 'Match' and A3=0 for 2019 and A3=0 for 2020 so this qualifies as 'NoMatch'. So if a member had an A1 - A3 populated in 2019 and its not populated in 2020 this would be a 'Missing'. If a Member had an A1-A3 populated in 2019 and 2020 then this is a Match and if a Member had an A1-A3 not populated for 2019 and 2020 this is a 'Nomatch'.

bknitch · ‎08-25-2021

I have a dataset where i'm trying to determine fallout/ outliers from a previous year. Here is an example of the table below: Member YR A1 A2 A3 123 2019 1 0 1 123 2020 1 0 1 124 2019 1 1 0 124 2020 0 1 0 125 2019 0 1 1 125 2020 1 1 1 126 2019 0 1 1 126 2020 0 0 1 The A1-A3 are hierarchy based, A1 being most important and A3 being least. I'm trying to identify members and their corresponding A1 - A3 that didn't match from the previous year. So an expected output would be something like below: Member YR A1 A2 A3 124 2020 Missing Found NoMatch 126 2020 NoMatch Missing Found The goal is to find the A1-A3 variable assigned to a member that's missing, matched or has No Match on the previous year. In this case I'm looking at 2019 and matching it to 2020, so I only need 2020 rows/columns back. I've tried building arrays and transposing the data with incld and excld columns for each year to find the missing or Nomatches and i cant seem to get the desired output. Any help would be appreciated.

bknitch · ‎04-09-2021

Thanks @Kurt_Bremser this worked really well. I thought about transposing it back to long and skinny from wide but didn't know the next steps from there. This was very helpful!

bknitch · ‎04-09-2021

@PeterClemmensen Thank you for the code. This actually did not capture the correct scenarios. It did reduce the data set to those ID's with a CC_IND=1 but it identified all of them, no matter if the same ID had a CC = to a CC with a CC_IND=1. Meaning, it identified scenarios where the ID had both a CC_IND= 1 & 0 and a CC1=1 on both records and this codes output gave me that ID.

bknitch · ‎04-09-2021

Hi @PGStats thanks for the Proc SQL example, this actually works very well. Never thought about building a range out as i do something similar to calculate the CC flags. Thanks again!

bknitch · ‎04-09-2021

hi @PeterClemmensen An optimal output would be to identify the header name as the output or an indication of what CC was in the submission identified. Or just retaining the flags where the observation was present on the C_IND=1 and not present on the C_IND=0 ID C_IND CC 123 1 CC2 234 1 CC1 657 1 CC8 Or something like this ID C_IND CC1 CC2 CC6 CC8 CC9 CC10 123 1 0 1 0 0 0 0 234 1 1 0 0 0 0 0 657 1 0 0 0 1 0 0

bknitch · ‎04-09-2021

data have; input ID$ CC_IND CC1 CC2 CC6 CC8 CC9 CC10; cards; 123 0 1 0 0 0 0 1 123 1 0 1 0 0 0 1 124 0 0 0 0 0 0 1 124 1 0 0 0 0 0 1 125 0 1 1 0 0 0 0 125 1 1 1 0 0 1 0 126 0 1 0 1 0 0 0 126 1 0 0 1 0 0 0 ; run; Above is a sample of my table that contains roughly 8,000 IDs with flags indicating the ID has a CC present or not (=1 is present =0 is not present). There is also an indicator (C_IND) that lets me know what type of submission this was. I'd like to find which CC is populated as 1 by ID and CC_IND. Essentially I'm trying to find what CC's are present on ID's with a CC_IND=1 that are not populated on a CC_IND=0. An example would be ID 123 where CC2=1 on the CC_IND=1 record but not present on the CC_IND=0 record.

bknitch · ‎08-28-2020

This worked, thanks for the solution!

bknitch · ‎08-27-2020

DATA TEST1ROUND; set COMPARE; HK_SCR1=round(HK_SCR,0.001); BK_SCR1=round(BK_SCR,0.001); run; data HAVE(Drop=MY_ID); set test1round; ID=MY_ID; ID=1234; if HK_SCR1 <> BK_SCR1 then FLAG=1; ELSE FLAG=0; run; Here is my output, i can't show the ID variables due to privacy so i just renamed them to 1234. These three are all different ID's. ID HK_SCR BK_SCR HK_SCR1 BK_SCR1 FLAG 1234 0.339 0.339 0.339 0.339 1 1234 3.865 3.859 3.865 3.859 1 1234 0.565 0.565 0.565 0.565 1

bknitch · ‎08-27-2020

@PaigeMiller I took a random sample where values were the same and tested the Round function. It did not work unfortunately.

Online Status	Offline
Date Last Visited	‎06-02-2022 01:56 PM

Re: Do/Select statement not working when formatting dates.

Re: Do/Select statement not working when formatting dates.

Do/Select statement not working when formatting dates.

Re: Find Outliers and Matches in dataset

Re: Find Outliers and Matches in dataset

Re: Find Outliers and Matches in dataset

Find Outliers and Matches in dataset

Re: Identifying observations on different submission indicators

Re: Identifying observations on different submission indicators

Re: Identifying observations on different submission indicators

Re: Find Outliers and Matches in dataset

Re: Find Outliers and Matches in dataset

Re: Identifying observations on different submission indicators

Re: Identifying observations on different submission indicators

Re: Identifying observations on different submission indicators

Re: Summarize on changes in ID and Dates

Re: Replacing flags with variable names and removing leading character

Re: Do/Select statement not working when formatting dates.

Re: Do/Select statement not working when formatting dates.

Do/Select statement not working when formatting dates.

Re: Find Outliers and Matches in dataset

Re: Find Outliers and Matches in dataset

Re: Find Outliers and Matches in dataset

Find Outliers and Matches in dataset

Re: Identifying observations on different submission indicators

Re: Identifying observations on different submission indicators

Re: Identifying observations on different submission indicators

Re: Identifying observations on different submission indicators

Identifying observations on different submission indicators

Re: Comparing Numeric Variables by Percentile Difference

Re: Comparing Numeric Variables by Percentile Difference

Re: Comparing Numeric Variables by Percentile Difference