Recently in the SAS Community Library: SAS' @ADAMPOLLACCHI reveals the importance of making accurate, timely data driven decisions to be competitive in the age of AI--and, to that end, how to build, test and deploy these capabilities in a user friendly and transparent manner.
Hi, I have been searching for a solution to this for a while and my googling hasn't resulted in anything tangible. I hope someone here can help. I have 2 datasets (all data is made up but the gist should be there): 1. Transaction_Tbl - the source dataset that contains transactional data of call reps for selected dates and call durations: Transaction_Tbl ID_NUM EMP_NM DATE CALL_START CALL_END CALL_DUR 000121 Mark 6/4/2023 4:30 PM 4:32 PM 2 000121 Mark 8/15/2023 8:30 AM 8:31 AM 1 000121 Mark 9/6/2023 9:15 AM 9:18 AM 3 000121 Mark 5/6/2024 10:05 AM 10:06 AM 1 000121 Mark 6/10/2024 2:22 PM 2:23 PM 1 000122 Jessie 4/29/2023 8:45 AM 8:55 AM 10 000122 Jessie 11/29/2023 11:15 AM 11:30 AM 15 000122 Jessie 12/8/2023 1:23 PM 1:40 PM 17 000122 Jessie 2/16/2024 1:40 PM 1:55 PM 15 000123 James 2/8/2023 12:10 PM 12:20 PM 10 000123 James 2/22/2023 2:33 PM 2:55 PM 22 000123 James 1/21/2024 4:12 PM 4:19 PM 7 000124 Felicia 5/23/2024 3:42 PM 3:55 PM 13 000127 Henry 1/2/2023 9:02 AM 9:10 AM 8 000127 Henry 3/18/2023 9:50 AM 10:00 AM 10 000127 Henry 4/21/2023 10:05 AM 10:20 AM 15 000127 Henry 10/26/2023 1:22 PM 1:27 PM 5 000127 Henry 11/12/2023 2:00 PM 2:04 PM 4 2. Card_Tbl - The supplemental dataset that shows what "card" the rep held between a certain date range. The card changes annually based on performance and defines the expected call duration at the card level: Card_Tbl ID_NUM EMP_NM EFF_DT END_DT CARD CARD_DESC 000121 Mark 1/1/2020 12/31/2020 GREEN Complete calls within 15 minutes. 000121 Mark 1/1/2021 12/31/2021 BLUE Complete calls within 5 minutes. 000121 Mark 1/1/2022 12/31/2022 ORANGE Complete calls within 8 minutes. 000121 Mark 1/1/2023 12/31/2023 GREEN Complete calls within 15 minutes. 000121 Mark 1/1/2024 12/31/2024 BLUE Complete calls within 5 minutes. 000122 Jessie 1/1/2022 12/31/2022 GREEN Complete calls within 15 minutes. 000122 Jessie 1/1/2023 12/31/2023 GREEN Complete calls within 15 minutes. 000122 Jessie 1/1/2024 12/31/2024 GREEN Complete calls within 15 minutes. 000123 James 7/1/2022 6/30/2023 GREEN Complete calls within 15 minutes. 000123 James 7/1/2023 6/30/2024 ORANGE Complete calls within 8 minutes. 000123 James 7/1/2024 6/30/2025 YELLOW Complete calls within 10 minutes. 000124 Felicia 3/1/2024 2/28/2025 GREEN Complete calls within 15 minutes. 000127 Henry 1/1/2023 12/31/2023 GREEN Complete calls within 15 minutes. 000127 Henry 1/1/2024 12/31/2024 BLUE Complete calls within 5 minutes. I am currently reviewing the rep call duration manually by dumping the data to excel and adding the relevant card color from Card_tbl and determining a pass or fail if the call duration meets expectation. The table i'd like to get by using SAS instead of manual work in excel is this (and complete a full population review vs a manual one): ID_NUM, EMP_NM, DATE, and CALL_DUR from Transaction_Tbl CARD from Card_Tbl based on the date RESULT is new to the want_tbl and will show pass/fail depending on CALL_DUR and CARD value Want_tbl ID_NUM EMP_NM DATE CALL_DUR CARD RESULT 000121 Mark 6/4/2023 2 GREEN PASS 000121 Mark 8/15/2023 1 GREEN PASS 000121 Mark 9/6/2023 3 GREEN PASS 000121 Mark 5/6/2024 1 BLUE PASS 000121 Mark 6/10/2024 1 BLUE PASS 000122 Jessie 4/29/2023 10 GREEN PASS 000122 Jessie 11/29/2023 15 GREEN PASS 000122 Jessie 12/8/2023 17 GREEN FAIL 000122 Jessie 2/16/2024 15 GREEN PASS 000123 James 2/8/2023 10 GREEN PASS 000123 James 2/22/2023 22 GREEN FAIL 000123 James 1/21/2024 7 ORANGE PASS 000124 Felicia 5/23/2024 13 GREEN PASS 000127 Henry 1/2/2023 8 GREEN PASS 000127 Henry 3/18/2023 10 GREEN PASS 000127 Henry 4/21/2023 15 GREEN PASS 000127 Henry 10/26/2023 5 GREEN PASS 000127 Henry 11/12/2023 4 GREEN PASS I cannot figure out how to grab the applicable CARD value from the Card_Tbl as it applies to the ID_NUM/date in the Transaction_Tbl. Thank You for your time and expertise.
... View more
Hello SAs users Im quite adept with PC SAS, but i am now trying to install SAS Viya and teh documentation looks like a nightmare Can anyone help talk me through this - i got the software order form with the details and was expecting to find a simple install button ! any CLEAR guidance on this please thanks ifty
... View more
For the life of me, I can't figure out how to perform pairwise comparisons in SAS following a second-order Rao-Scott chi-square test of independence. I have two categorical variables (NSEX & DEPLVL). NSEX has two levels (1 = male; 2 = female) and DEPLVL has four levels (0 = No symptoms; 1 = 1 symptom; 2 = 2-4 symptoms; 3 = 5-9 symptoms). This is complex survey data with clustering, stratification, and weighting, so I'm limited to procedures which can incorporate these elements/variables: varmethod=taylor, weight audweight, strata varstrat & cluster varunit. I want to know if the percentage of women with: no symptoms is significantly different from the percentage of women with 1 symptom no symptoms is significantly different from the percentage of women with 2-4 symptoms no symptoms is significantly different from the percentage of women with 5-9 symptoms and 2-4 symptoms is significantly different from the percentage of women with 5-9 symptoms I also want to know if there are significant differences among men for the same set of DEPLVL comparisons. I've attached the results of the overall test of independence in the hope that it clarifies my research questions/the answers I'm trying to get at (e.g., for scenario 1 above, I want to know if 45.5227 is significantly different from 46.3432). I'd like to use either the Rao-Scott adjusted Wald test or adjusted F-test for the pairwise comparison (for methodological consistency) with the Holm-Bonferroni multiple comparison adjustment method, but at this point, I'll take anything that gives me adjusted p-values for each of the pairs. I'm trying to avoid the regression route if possible, but I'm just about ready to accept that if it's the only way to get it done. I should note that I'm brand new to SAS and have been trying to use an AI engine to generate code for the pairwise comparisons, so this is definitely not my area of expertise. Nor is statistics to be honest - I'm writing a dissertation for clinical psych. Can anyone lend a hand and help me figure this out? I've been trying to figure it out for 3 weeks now and don't feel like I've made any real progress on what (I would have thought) was a pretty straightforward question/procedure.
... View more