About jcapua2

jcapua2 · ‎09-14-2018

Hello, I have a dataset filled with character variables. data have; patient infection_1 infection_2 infection_3 abc virus xyz fungus virus lmn bacteria fungus virus I want to produce one frequency table to find all occurrences in the variable: any infection virus 3 fungus 2 bacteria 1 Is there a shorter way in SAS to do this? Thank you!

jcapua2 · ‎01-03-2018

Hello, data have; patient_num Procedure_Date Organ Multiorgan patient33 1/24/2000 Heart No patient33 5/13/2003 Kidney Yes patient33 5/13/2003 Skin Yes patient34 5/7/2007 Lung No patient34 5/27/2009 Heart No data want; patient_num Procedure_Date Organ Multiorgan Previous_organ patient33 1/24/2000 Heart No No patient33 5/13/2003 Kidney Yes Yes patient33 5/13/2003 Skin Yes Yes patient34 5/7/2007 Lung No No patient34 5/27/2009 Heart No Yes I want to create a new variable that flags whether a particular patient has had a previous organ procedure. For example, patient34 has 2 different Procedure_date, with a later Procedure_date that occurred with a different organ, flagging that later row with Previous_organ='Yes' but the prior row (the first Procedure_date) Previous_organ='No.' Also, for patient33, with 3 Procedure_date, but the last 2 dates occurred on the same date but with different organs. It flags the last 2 dates as Previous_organ='Yes' but the prior row (the first Procedure_date) Previous_organ='No.' Is there any way to do this in SQL or SAS data step?

jcapua2 · ‎01-03-2018

Hello, I want to calculate the difference between dates in days using the same variable date [Procedure_Date] in the same patient, among only those with the same Status=Alive. data have; patient_num Procedure_Date Status_Date Status patient33 03/07/2002 02/23/2004 Alive patient33 02/23/2004 10/01/2014 Alive patient50 05/07/2007 12/02/2014 Alive patient50 05/27/2009 10/08/2015 Dead data want; patient_num Procedure_Date Status_Date Status Days_Between_Procedure patient33 03/07/2002 02/23/2004 Alive 718 patient33 02/23/2004 10/01/2014 Alive 718 patient50 05/07/2007 12/02/2014 Alive . patient50 05/27/2009 10/08/2015 Dead . So for example, the difference in days of patient33's first Procedure_Date and second Procedure_Date, which equals to 718 days (same Status="Alive") and appears in the both rows. Is there a way to do it in SAS datastep or in SQL? Thank you!

jcapua2 · ‎01-02-2018

Thank you! It works!

jcapua2 · ‎01-02-2018

Hello, data have; patient_num Procedure Date Status Date Organ patient11 03/07/2002 02/23/2004 Heart patient11 02/23/2004 10/01/2014 Lung patient12 04/23/2006 10/13/2014 Heart patient13 10/21/2007 10/10/2016 Bone patient14 05/06/2009 04/30/2017 Liver patient14 05/09/2010 07/15/2017 Liver data want; patient_num Procedure Date Status Date Organ Multiorgan patient11 03/07/2002 02/23/2004 Heart Yes patient11 02/23/2004 10/01/2014 Lung Yes patient12 04/23/2006 10/13/2014 Heart No patient13 10/21/2007 10/10/2016 Bone No patient14 05/06/2009 04/30/2017 Liver No patient14 05/09/2010 07/15/2017 Liver No I want to flag rows where a patient has multiple organ procedures. So for patient 11, he/she has both heart and lung surgeries. So new variable Multiorgan='Yes'. Is there a way to do this in data step? Or proc SQL? Thank you!

jcapua2 · ‎01-02-2018

Hello, data have; patient_num Procedure Date Patient Re-Admitted Status Date Days Until Graft Failure patient32 03/07/2002 No 02/23/2004 718 patient32 02/23/2004 Yes 10/01/2014 3873 data want; patient_num Procedure Date Patient Re-Admitted Status Date Days Until Graft Failure Days Until Graft Failure if Re-Admitted patient32 03/07/2002 No 02/23/2004 718 . patient32 02/23/2004 Yes 10/01/2014 3873 4591 For the variable "Days Until Graft Failure if Re-Admitted," I want to calculate the days using the earliest procedure date instead of the procedure date corresponding to that row for anyone who was "Patient Re-Admitted"='Yes'. Is there way to calculate this in SAS datastep? Thank you!

jcapua2 · ‎12-20-2017

because diabetes='Yes', cholesterol='Yes', and Hep B='Yes.' Only patients where either HIV='Yes' or cancer='Yes' and everything else='No.'

jcapua2 · ‎12-20-2017

Hello. I need help with producing 2 separate tables from the original table, where one table contains observations with specific variables=Yes, but only those variables='Yes.' For example, I only want patients who have HIV='Yes' or cancer='Yes', and nothing else='Yes'. data have; patient diabetes cholesterol HIV cancer Hep B patient_1 Yes Yes No Yes Yes patient_2 Yes No Yes No No patient_3 No No No No Yes patient_4 No No Yes No No patient_5 No Yes No No Yes patient_6 No No Yes Yes No patient_7 No No No Yes No /*only patients where HIV='Yes' or cancer='Yes' and everything else='No'*/ data want1; set have; patient diabetes cholesterol HIV cancer Hep B patient_4 No No Yes No No patient_6 No No Yes Yes No patient_7 No No No Yes No /*everyone else*/ data want2; set have; patient diabetes cholesterol HIV cancer Hep B patient_1 Yes Yes No Yes Yes patient_2 Yes No Yes No No patient_3 No No No No Yes patient_5 No Yes No No Yes Is there a way to do it in SQL or SAS datastep? Thank you!

jcapua2 · ‎12-15-2017

I have data set: PX BMI SMOKE Patient_1 YES NO Patient_1 NO YES And I want: PX BMI SMOKE Patient_1 YES YES Is there a way to make Patient_1 in just one row instead of having multiple rows?

jcapua2 · ‎12-07-2017

It worked! Thank you very much!

jcapua2 · ‎12-05-2017

I'm creating a new variable test_result_all based on test_result_1, test_result_2, and test_result_3. Each variable contains 4 categories: positive, negative, indeterminate, and Not Done. For any positive result in the 3 variables, test_result_all='positive'. For any test result with negative but not positive, the result is negative. For all results with Not Done=Not Done. For all results with indeterminate=indeterminate. Otherwise (mixed between indeterminate and Not Done, or missing), it's missing. How should I code that? I was thinking of doing an if-then but it seems complicated to do it. I started the following but couldn't figure out what's next: if test_result_1='P' or test_result_2='P' or test_result_3='P' then test_result_all='P'; else if...

jcapua2 · ‎11-08-2017

I have a dataset with patient_type=living and patient_type=deceased, as well as a column for match_ID. I want to keep only observations where patient_type=living and patient_type=deceased have the same match_ID, and exclude everything else. For example, Key Px_Type Match_ID 1115 L 0001a 1116 D 0001a 1117 D 0004b 1118 L 0003b I want to keep observations 1115 (L) and 1116 (D) since they have the same match_ID. Is there a way to approach this in SAS?

Online Status	Offline
Date Last Visited	‎09-14-2018 04:28 PM

count the number of character occurrences throughout the data

Creating a Variable using Dates

Calculating difference in dates using the same date variable

Re: Use Earliest Date For Calculation

Flag items with same unique ID but different categories for a variable

Use Earliest Date For Calculation

Re: Create table to meet certain conditions

Create table to meet certain conditions

Make a unique observation in one row

Re: Create new variable with a combination of categories

Re: count the number of character occurrences throughout the data

Re: Calculating difference in dates using the same date variable

Re: Calculating difference in dates using the same date variable

Re: Calculating difference in dates using the same date variable

Re: Flag items with same unique ID but different categories for a vari...

count the number of character occurrences throughout the data

Creating a Variable using Dates

Calculating difference in dates using the same date variable

Re: Use Earliest Date For Calculation

Flag items with same unique ID but different categories for a variable

Use Earliest Date For Calculation

Re: Create table to meet certain conditions

Create table to meet certain conditions

Make a unique observation in one row

Re: Create new variable with a combination of categories

Create new variable with a combination of categories

Only keep matching values