About mt88

mt88 · ‎10-01-2024

Hello, I'd have a dataset where I'd like to create a new variable that gives me a count of a specific value for a set of variables across a row of data. For example, in this test dataset I want to create a new variable that that gives me a count of '0' values across variables a, b, c, and d. data test; input a b c d; cards; 1 0 9 1 1 1 0 0 0 9 1 1 0 0 9 1 1 0 9 9 0 1 1 0 1 9 9 1 1 9 0 0 0 0 9 1 9 1 0 0; run; The new variable (newvar) would return the following: newvar 1 2 1 2 1 2 0 2 2 2 Any help is appreciated. I can provide more information if that is helpful. Thanks, Matt

mt88 · ‎04-25-2024

Hello, I used the following code... ods output chisq=tst; proc freq data = combinedIDmanu; tables fentanyl*num_doc_vis_catB/chisq; run; to send this results table: Statistic DF Value Prob Chi-Square 2 0.9499 0.6219 Likelihood Ratio Chi-Square 2 1.7052 0.4263 Mantel-Haenszel Chi-Square 1 0.3486 0.5549 Phi Coefficient 0.0812 Contingency Coefficient 0.081 Cramer's V 0.0812 WARNING: 50% of the cells have expected counts less than 5. Chi-Square may not be a valid test. to a dataset with the following fields: Table Statistic DF Value Prob Table fentanyl * num_doc_vis_catB Chi-Square 2 0.9499 0.6219 Table fentanyl * num_doc_vis_catB Likelihood Ratio Chi-Square 2 1.7052 0.4263 Table fentanyl * num_doc_vis_catB Mantel-Haenszel Chi-Square 1 0.3486 0.5549 Table fentanyl * num_doc_vis_catB Phi Coefficient _ 0.0812 _ Table fentanyl * num_doc_vis_catB Contingency Coefficient _ 0.081 _ Table fentanyl * num_doc_vis_catB Cramer's V _ 0.0812 _ Is there a way to use the ods statement so that this part of the results table: WARNING: 50% of the cells have expected counts less than 5. Chi-Square may not be a valid test. is added to the dataset? Thank you.

mt88 · ‎01-23-2023

Thank you. I've been able to make this work. Is there away to adapt it for multiple variables in one step? In other words, I'd like to get the total count for 'var1', 'var2', etc. by ID.

mt88 · ‎01-23-2023

Hello, I'm looking for a way to create a variable that will give me the total count for another variable for each participant ID. For example, If I have 'var1' in the original dataset: ID var1 1 0 1 . 1 1 1 0 1 1 1 . 1 1 1 0 1 1 1 0 2 0 2 1 2 . 2 0 2 0 2 1 2 1 I'd end up with a new variable 'totalcount': ID var totalcount 1 0 4 1 . 4 1 1 4 1 0 4 1 1 4 1 . 4 1 1 4 1 0 4 1 1 4 1 0 4 2 0 3 2 1 3 2 . 3 2 0 3 2 0 3 2 1 3 2 1 3 Thank you.

mt88 · ‎09-30-2022

Hello, You mentioned that 'You can modify that further to give the dummy variables a missing value as well.' Can you show me that modification? Thank you.

mt88 · ‎01-12-2022

Hello, I'm looking for an efficient way to create dummy variables and I've seen this example online: DATA auto ; LENGTH make $ 20 ; INPUT make $ 1-17 price mpg rep78 ; CARDS; AMC Concord 4099 22 3 AMC Pacer 4749 17 3 Audi 5000 9690 17 5 Audi Fox 6295 23 3 BMW 320i 9735 25 4 Buick Century 4816 20 3 Buick Electra 7827 15 4 Buick LeSabre 5788 18 3 Cad. Eldorado 14500 14 2 Olds Starfire 4195 24 1 Olds Toronado 10371 16 3 Plym. Volare 4060 18 2 Pont. Catalina 5798 18 4 Pont. Firebird 4934 18 1 Pont. Grand Prix 5222 19 3 Pont. Le Mans 4723 19 3 ; RUN; DATA auto2; set auto; ARRAY dummys {*} 3. rep78_1 - rep78_5; DO i=1 TO 5; dummys(i) = 0; END; dummys( rep78 ) = 1; RUN; This has been working for me except when I have missing values (e.g. if rep78 has missing values). Is there a way to adjust this code to account for the missing values or do I need a different solution? Thanks

mt88 · ‎11-22-2020

Thank you for your help and patience.

mt88 · ‎11-20-2020

My datasets were too large to copy and paste so hopefully this smaller set works: data A; input ID Date :date9.; format Date date9.; datalines; ID Date 204356 02/13/2019 204356 03/17/2019 204356 04/20/2019 204356 07/20/2019 204356 09/22/2019 204356 10/19/2019 205352 10/01/2017 205756 01/17/2018 205756 02/07/2018 205756 04/11/2018 205756 05/07/2018 205756 04/27/2018 205756 05/14/2018 205756 07/06/2018 205756 10/15/2018 205756 10/05/2018 205756 10/29/2018 205756 01/18/2019 205756 02/25/2019 205756 05/15/2019 205756 08/18/2019 205756 09/04/2019 205756 11/16/2019 data B; input ID Date :date9.; format Date date9.; datalines; ID Date 204356 02/08/2019 204356 03/22/2019 204356 04/25/2019 204356 07/25/2019 204356 09/27/2019 204356 10/24/2019 205352 10/06/2017 205756 01/22/2018 205756 02/12/2018 205756 04/16/2018 205756 05/02/2018 205756 05/02/2018 205756 05/09/2018 205756 07/11/2018 205756 10/10/2018 205756 10/10/2018 205756 10/24/2018 205756 01/23/2019 205756 02/20/2019 205756 05/20/2019 205756 08/13/2019 205756 09/09/2019 205756 11/11/2019

mt88 · ‎11-20-2020

Hi everyone, I've attached two excel files. Each contains a list of repeated IDs and associated dates. Dataset A is the set that contains the relevant date ranges for each ID. In other words, the first and last dates for each ID would be the date ranges for each ID. Dataset B has a different set of dates for each ID. Earlier, I had said I wanted to merge, but I think that was a mistake. What I'd like is to limit or identify observations for each ID from Dataset B based on the date ranges from Dataset A. Perhaps draycut's response works for this. Let me know if you need anything else. Thanks

mt88 · ‎11-20-2020

If I have different date ranges for each ID, what date would I insert into that code?

mt88 · ‎11-20-2020

Thanks, but the date range is unique for each ID. It doesn't seem like this code captures that aspect.

mt88 · ‎11-20-2020

Hi everyone, I have a separate data set (call it 'set A') for these subjects that has a different set of dates for each ID The first and last date for each ID in 'set A' is the basis for the date range). I guess another way of thinking of it is that, into 'set A', I'd like to merge in only those observations from the current dataset that are within 'set A's' first-to-last date range for each ID. Thanks

mt88 · ‎11-20-2020

Hello everyone, I have a data set with repeated observations that have associated dates. For each ID, I'd like to either exclude observations based on pre-set date ranges or create a new variable that indicates which observations are in the pre-set date range and which are not. For example, let's say I start out with this: ID Date 1 Jan 1 2019 1 Feb 3 2019 1 Mar 15 2019 1 Apr 22 2019 2 Mar 20 2017 2 Apr 1 2017 2 May 15 2018 2 Jun 12 2018 2 Jul 23 2019 3 Jan 15 2019 3 Feb 12 2019 3 Mar 13 2020 3 May 7 2020 and I'd like to restrict the date ranges by ID: For ID 1 - restricted date range: Feb 1 2019 to Mar 30 2019 For ID 2 - restricted date range: Mar 30 2017 to Jun 30 2018 For ID 3 - restricted date range: Jan 20 2019 to Mar 25 2020 I'd like to either end up with data that look like this: ID Date 1 Feb 3 2019 1 Mar 15 2019 2 Apr 1 2017 2 May 15 2018 2 Jun 12 2018 3 Feb 12 2019 3 Mar 13 2020 or this: ID Date indicator 1 Jan 1 2019 0 1 Feb 3 2019 1 1 Mar 15 2019 1 1 Apr 22 2019 0 2 Mar 20 2017 0 2 Apr 1 2017 1 2 May 15 2018 1 2 Jun 12 2018 1 2 Jul 23 2019 0 3 Jan 15 2019 0 3 Feb 12 2019 1 3 Mar 13 2020 1 3 May 7 2020 0 Any help would be appreciated. Thank you.

mt88 · ‎11-17-2020

Thank you all of the help!

mt88 · ‎11-17-2020

Thank you, that worked. As a follow up, I'm wondering how to do something similar when there is missing data present. For example, starting with a similar data set, except I've added in some missings: var1 var2 var3 var4 var5 var6 var7 var8 . 1 7 . 3 5 6 9 4 6 . 15 . 2 10 0 15 22 6 . 2 98 1 . I'd like to end up with a similar results, except where the missing values are not included (relevant values colored for clarity): var1 var2 var3 var4 var5 var6 var7 var8 first last . 1 7 . 3 5 6 9 1 9 4 6 . 15 . 2 10 0 4 0 15 22 6 . 2 98 1 . 15 1 Thank you.

Online Status	Offline
Date Last Visited	‎03-05-2025 06:09 PM

Count of specific value across row

ODS output

Re: Return a total for a given variable by ID

Return a total for a given variable by ID

Re: Creating dummy variables

Creating dummy variables

Re: Excluding a set of IDs based on date ranges

Re: Excluding a set of IDs based on date ranges

Re: Excluding a set of IDs based on date ranges

Re: Excluding a set of IDs based on date ranges

Re: Count of specific value across row

Count of specific value across row

ODS output

Re: Return a total for a given variable by ID

Return a total for a given variable by ID

Re: Creating dummy variables

Creating dummy variables

Re: Excluding a set of IDs based on date ranges

Re: Excluding a set of IDs based on date ranges

Re: Excluding a set of IDs based on date ranges

Re: Excluding a set of IDs based on date ranges

Re: Excluding a set of IDs based on date ranges

Re: Excluding a set of IDs based on date ranges

Excluding a set of IDs based on date ranges

Re: first or last in a row

Re: first or last in a row