cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
GAL1986
‎03-25-2022
  • 10 Posts
  • 1 Likes Given
  • 0 Solutions
  • 1 Likes Received

Re: 1:1 matching only using controls once

by Fluorite | Level 6 in SAS Programming
‎03-26-2022 02:27 PM
‎03-26-2022 02:27 PM
Thank you, I will take a look at that reference. ... View more

1:1 matching only using controls once

by Fluorite | Level 6 in SAS Programming
‎03-25-2022 05:19 PM
1 Like
‎03-25-2022 05:19 PM
1 Like
Hi all,    I am trying to do 1:1 matching while only using controls subjects once. I found the following code in a published paper  ( https://support.sas.com/resources/papers/proceedings/proceedings/sugi29/173-29.pdf  ) and I have adapted it for my project. I am able to identify matching based on my matching criteria BUT, the code allows controls to be used more than once. Can someone show me how to adapt this code for 1:1 matching without duplicating controls? PROC SQL; CREATE table possmatch as select one.del_id as case_id, two.del_id as control_id, one.case_preg_num as study_parity, two.parity_control as control_parity, one.case_age as study_age, two.control_age as control_age, one.gender as study_gender, two.gender_control as control_gender, one.insurance as study_insurance, two.insurance_control as control_insurance, one.case_year as study_year, two.control_year as year_control, one.rand_num as rand_num from cases one, controls two where ((one.case_year between two.year_low and two.year_high)and one.gender=two.gender_control and one.insurance=two.insurance_control and one.case_age=two.control_age and one.case_preg_num=two.parity_control); run; * count the number of control subjects for each case subject; proc sort data=possmatch; by case_id; run; data possmatch2(keep=case_id num_controls); set possmatch; by case_id; retain num_controls; if first.case_id then num_controls=1; else num_controls=num_controls+1; if last.case_id then output; run; * now merge the counts back into the dataset; data possmatch3; merge possmatch possmatch2; by case_id; run; * now order the rows to select the first matching control; proc sort data=possmatch3; by control_id num_controls rand_num; run; proc sort data=possmatch3 nodup; by control_id case_id; run; data possmatch4; set possmatch3; by control_id case_id; if first.control_id then output; run;   /*Now, as before, randomly select the fixed number of control subjects for each case.*/ proc sort data=possmatch ; by case_id rand_num; run; data possmatch2 not_enough; set possmatch; by case_id ; retain num; if first.case_id then num=1; if num le 2 then do; output possmatch2; num=num+1; end; if last.case_id then do; if num le 2 then output not_enough; end; ... View more

Re: Formatting date variables

by Fluorite | Level 6 in SAS Programming
‎10-08-2020 11:28 AM
‎10-08-2020 11:28 AM
Thank you! I will try this today! ... View more

Formatting date variables

by Fluorite | Level 6 in SAS Programming
‎10-08-2020 10:53 AM
‎10-08-2020 10:53 AM
I am trying to create a unique ID that is a combination of an ID variable and a date.  In both datasets I have an ID variable which is a numeric variable with a length of 8 and format Best12. In one dataset I have delivery_date which is length 8, format MMDDYY10. and informat date9. In the other I have new_delivery_date which has the same characteristics.   The code I am using is ID2=put(ID, 8.); del_date2=put(delivery_date, 9.); Del_ID = strip(ID2)||strip(del_date2);   And   ID2=put(ID, 8.); del_date2=put(new_del_date, 9.); Del_ID = strip(ID2)||strip(del_date2);   Here is an example of the del_ID for one patient in both datasets. Do you have any idea why the Del_IDs would not match in the datasets if the variables are all formatted the same way?   Dataset1: ID 1001958  Del_ID 100195819038  new_del_date 02/15/2012 Dataset 2:  ID 1001958  Del_ID 100195819039  new_del_date 02/15/2012   Why does one Del_ID end in 8 and the other in 9 if the dates are formated the same way? ... View more

Re: Create new lab variables based on day-of-life

by Fluorite | Level 6 in SAS Programming
‎07-12-2019 04:50 PM
‎07-12-2019 04:50 PM
Also, here is some very long code that I know gives me what I need, but I am trying to condense as I have to do this for over 100 lab variables   The following code gives me these variables  HYDROXYPROGESTERONE_1-HYDROXYPROGESTERONE_1 where 1=normal range 0=Low and 2=high and HYDROXYPROGESTERONE_VALUE_1-HYDROXYPROGESTERONE_VALUE_7 which equal the actual numeric lab result variable. The _number at the end of the variables indicate the day-of-life at which the lab test was performed.   I am trying to condense this code and I just can't figure out how to do it!      IF LAB_NAME IN ('17-HYDROXYPROGESTERONE') AND 106>=LAB_RESULT2=>7 and day_of_life=1 THEN HYDROXYPROGESTERONE_1=1/*NORMAL*/; IF LAB_NAME IN ('17-HYDROXYPROGESTERONE') AND 106>=LAB_RESULT2=>7 and day_of_life=2 THEN HYDROXYPROGESTERONE_2=1/*NORMAL*/; IF LAB_NAME IN ('17-HYDROXYPROGESTERONE') AND 106>=LAB_RESULT2=>7 and day_of_life=3 THEN HYDROXYPROGESTERONE_3=1/*NORMAL*/; IF LAB_NAME IN ('17-HYDROXYPROGESTERONE') AND 106>=LAB_RESULT2=>7 and day_of_life=4 THEN HYDROXYPROGESTERONE_4=1/*NORMAL*/; IF LAB_NAME IN ('17-HYDROXYPROGESTERONE') AND 106>=LAB_RESULT2=>7 and day_of_life=5 THEN HYDROXYPROGESTERONE_5=1/*NORMAL*/; IF LAB_NAME IN ('17-HYDROXYPROGESTERONE') AND 106>=LAB_RESULT2=>7 and day_of_life=6 THEN HYDROXYPROGESTERONE_6=1/*NORMAL*/; IF LAB_NAME IN ('17-HYDROXYPROGESTERONE') AND 106>=LAB_RESULT2=>7 and day_of_life>6 THEN HYDROXYPROGESTERONE_7=1/*NORMAL*/; IF LAB_NAME IN ('17-HYDROXYPROGESTERONE') AND LAB_RESULT2<7 and day_of_life=1 THEN HYDROXYPROGESTERONE_1=0/*LOW*/; IF LAB_NAME IN ('17-HYDROXYPROGESTERONE') AND LAB_RESULT2<7 and day_of_life=2 THEN HYDROXYPROGESTERONE_2=0/*LOW*/; IF LAB_NAMEIN ('17-HYDROXYPROGESTERONE') AND LAB_RESULT2<7 and day_of_life=3 THEN HYDROXYPROGESTERONE_3=0/*LOW*/; IF LAB_NAME IN ('17-HYDROXYPROGESTERONE') AND LAB_RESULT2<7 and day_of_life=4 THEN HYDROXYPROGESTERONE_4=0/*LOW*/; IF LAB_NAME IN ('17-HYDROXYPROGESTERONE') AND LAB_RESULT2<7 and day_of_life=5 THEN HYDROXYPROGESTERONE_5=0/*LOW*/; IF LAB_NAMEIN ('17-HYDROXYPROGESTERONE') AND LAB_RESULT2<7 and day_of_life=6 THEN HYDROXYPROGESTERONE_6=0/*LOW*/; IF LAB_NAMEIN ('17-HYDROXYPROGESTERONE') AND LAB_RESULT2<7 and day_of_life>6 THEN HYDROXYPROGESTERONE_7=0/*LOW*/; IF LAB_NAME IN ('17-HYDROXYPROGESTERONE') AND LAB_RESULT2>106 and day_of_life=1 THEN HYDROXYPROGESTERONE_1=3/*HIGH*/; IF LAB_NAME IN ('17-HYDROXYPROGESTERONE') AND LAB_RESULT2>106 and day_of_life=2 THEN HYDROXYPROGESTERONE_2=3/*HIGH*/; IF LAB_NAME IN ('17-HYDROXYPROGESTERONE') AND LAB_RESULT2>106 and day_of_life=3 THEN HYDROXYPROGESTERONE_3=3/*HIGH*/; IF LAB_NAME IN ('17-HYDROXYPROGESTERONE') AND LAB_RESULT2>106 and day_of_life=4 THEN HYDROXYPROGESTERONE_4=3/*HIGH*/; IF LAB_NAME IN ('17-HYDROXYPROGESTERONE') AND LAB_RESULT2>106 and day_of_life=5 THEN HYDROXYPROGESTERONE_5=3/*HIGH*/; IF LAB_NAME IN ('17-HYDROXYPROGESTERONE') AND LAB_RESULT2>106 and day_of_life=6 THEN HYDROXYPROGESTERONE_6=3/*HIGH*/; IF LAB_NAME IN ('17-HYDROXYPROGESTERONE') AND LAB_RESULT2>106 and day_of_life>6 THEN HYDROXYPROGESTERONE_7=3/*HIGH*/; if HYDROXYPROGESTERONE_1 in (0,1,2) then HYDROXYPROGESTERONE_VALUE_1=lab_result2; if HYDROXYPROGESTERONE_1 in (0,1,2) then HYDROXYPROGESTERONE_VALUE_2=lab_result2; if HYDROXYPROGESTERONE_1 in (0,1,2) then HYDROXYPROGESTERONE_VALUE_3=lab_result2; if HYDROXYPROGESTERONE_1 in (0,1,2) then HYDROXYPROGESTERONE_VALUE_4=lab_result2; if HYDROXYPROGESTERONE_1 in (0,1,2) then HYDROXYPROGESTERONE_VALUE_5=lab_result2; if HYDROXYPROGESTERONE_1 in (0,1,2) then HYDROXYPROGESTERONE_VALUE_6=lab_result2; if HYDROXYPROGESTERONE_1 in (0,1,2) then HYDROXYPROGESTERONE_VALUE_7=lab_result2; ... View more

Re: Create new lab variables based on day-of-life

by Fluorite | Level 6 in SAS Programming
‎07-12-2019 04:18 PM
‎07-12-2019 04:18 PM
hi,  Thanks for the response, hope this clarifies things.  From the contents of your data set , i.e values of variables that exist now, how do we tell which is a bilirubin_reference or bilirubin_result variable? By the variable names listed in the original data I provided.... lab_result will turn into the NAMEofLAB_Result, in this case, Bilirubin_Result and the lab_reference_range to NameofLab_reference.  I need to go through and create the reference ranges myself based on the numeric lab values like follows if lab name =' BILIRUBIN TOTAL' and 12>=LAB_RESULT2>=0 then lab_reference_range=1 Where 1="within normal range". If I can get code to do this without having to type it out the long way, that would be great What is supposed to happen with the other variables in the data set? Is your current lab_result variable character or numeric? What happens with that '>30' value? . I have turned them into numeric values where I could. The >30 won't be coded because I know it's not numeric. Pretend they are all numeric for this example.    data WORK.TEST_FOR_HELP; infile datalines dsd truncover; input lab_name:$59. baby_id:BEST12. lab_result:$302. Day_of_life:32.; format baby_id BEST12.; datalines; AMINO ACID DISORDERS 268856296 IN RANGE 2 BILIRUBIN TOTAL 268856296 7.9 2 BILIRUBIN TOTAL 268856296 10.0 3 BIOTINIDASE DEFICIENCY 268856296 >30 2 CONGENITAL ADRENAL HYPERPLASIA 268856296 7 2 ;;;; ... View more

Create new lab variables based on day-of-life

by Fluorite | Level 6 in SAS Programming
‎07-12-2019 02:50 PM
‎07-12-2019 02:50 PM
Hi everyone,    I am trying to manipulate lab following data and create individual lab variables based on baby day-of-life that the lab test was performed.  In the following data, Bilirubin is a good example of what I am trying to manipulate, though I want to do this for all lab results.    baby_id lab_name lab_result lab_reference_range Day_of_life 123 AMINO ACID DISORDERS IN RANGE Within normal range 2 123 BILIRUBIN TOTAL 10.0 Within normal range 3 123 BILIRUBIN TOTAL 7.9 Within normal range 2 123 BIOTINIDASE DEFICIENCY >30 Within normal range 2   I want the following variables in the final dataset bilirubin_reference_2 (for day-of-life 2)=1 (1=Normal range)  bilirubin_result_2=7.9  bilirubin_reference_3=1 bilirubin_result_3=10   I am trying to do this for a very large dataset and I can't figure out how to get this done in one step. Any help would be appreciated!  Thanks   ... View more

Re: Keeping highest value per ID for all values

by Fluorite | Level 6 in New SAS User
‎06-28-2019 05:56 PM
‎06-28-2019 05:56 PM
So sorry it took me so long to reply- THANK YOU! This worked perfectly!!! ... View more

Keeping highest value per ID for all values

by Fluorite | Level 6 in New SAS User
‎05-08-2019 04:54 PM
‎05-08-2019 04:54 PM
Hi Everyone,  Thanks in advance for the help! I have a dataset with 827,304 observations and over 170 yes(1)/no(0) variables and I am trying to get one line per baby, per visit type, for each of the 170 different diagnoses.  This is a sample of what I have Baby_ID Visit_ID Type of visit Dx_date DX_Jaundice DX_Zoster DX_Sepsis DX_Hepatitis DX_Well_baby 123 1 Delivery 4/20/2019 1 0 0 0 0 123 1 Delivery 4/20/2019 0 0 1 0 0 123 3 Ever 5/8/2019 0 0 0 1 0 123 2 Postnatal 4/25/2019 0 1 0 0 0 And this is what I want the data to look like Baby_ID Visit_ID Type of visit Dx_date DX_Jaundice DX_Zoster DX_Sepsis DX_Hepatitis DX_Well_baby 123 1 Delivery 4/20/2019 1 0 1 0 0 123 3 Ever 5/8/2019 0 0 0 1 0 123 2 Postnatal 4/25/2019 0 1 0 0 0 I would usually transpose the variables of interest to get one line per ID, but with over 170 variables, that doesn't seem feasible. And    I think I am going down the wrong track here, but I have tried to use RETAIN data Test_retain; set test; by baby_id; retain highest; if first.baby_id then highest=.; highest=max(highest,DX_Jaundice); if last.baby_ID then output; run;   and some SQL code   Proc sql; Create table Max as Select baby_ID, Type_of_visit, DX_date, visit_ID, max(DX_Baby_Hear_Screen_Fail) as DX_Baby_Hear_Screen_Fail, max(DX_Baby_Single_Live) as DX_Baby_Single_Live, max(DX_baby_Hep_Vaccination) as DX_baby_Hep_Vaccination From test2 Group by visit_ID ; Quit;   If someone could point me in the right direction it would be greatly appreciated!  ... View more

Re: Output of Proc Compare get only differences

by Fluorite | Level 6 in SAS Programming
‎12-07-2017 01:10 PM
‎12-07-2017 01:10 PM
Hi,    I would like to create a dataset that shows the values produced by OUTBASE and OUTCOMP but only for people with unequal values. Is there a way to do this? The following code, even with OUTNOEQUAL, shows the values for all observations.    proc compare base=HLA_internal_test comp=HLA_external_test out=dif2 outbase outcomp outnoequal; ID PID; run;   Thank you in advance!  ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎03-25-2022 09:04 PM
Likes given to
View All
Likes from
View All
Quick links