About hanahch

hanahch · ‎08-01-2023

Hello SAS expert, I have the following SAS program that uses macro variables to retrieve the folder name for individual cases and processes the data within each case folder. Currently, the program processes one case at a time, and since there are 100 case folders, it becomes impractical to manually select each case. How can I modify the program so that it automatically retrieve the next case and repeat the process until all 100 cases have been handled. Your help is much appreciated. Thank you! Sample of case folder names: %LET id=1001B; /** individual case folder name */ %LET folder=C:\DDS; LIBNAME ddsdata "&folder"; options dlcreatedir; libname newdir "&folder/OUTPUT"; /creates folder where processed data will be stored */ * the following lines run DDS programs; %INCLUDE "&folder\dssformat.sas"; %INCLUDE "&folder\dssINPUT.SAS"; %INCLUDE "&folder\ngaINPUT.SAS"; %INCLUDE "&folder\ddsmain.SAS";

hanahch · ‎08-22-2022

Hello, I'd like to separate alphanumeric string into numeric and character variables like below: Data have: Data want - how do I get the output like this: I really appreciate your help! Thank you!

hanahch · ‎08-24-2021

I revised the dataset by adding correct unit in each dose field. I hope this helps and it should take care of the correct unit to dose issue. What I need help with is how to determine a new med added if it hasn't been taking in the previous encounters. An example of ID 109 shows med mtx taken since enc=1 and continued till enc 3, new med ssz added at enc 3 that has not been taken previously, and med_toc stopped at enc 3, so the note at enc 3 should indicate "Taking MTX 25 mg, added SSZ 2000 mg, stopped TOC". data have; infile datalines dsd truncover; input id:$11. enc:32. mtx:32. mtx_dose:$15. ssz:32. ssz_dose:$15. lef:32. lef_dose:$15. rtx:32. rtx_dose:$15. toc:32. toc_dose:$15.; datalines4; 102,1,0,,0,,0,,1,400 mg/m^,0, 102,2,0,,0,,0,,1,,0, 102,3,0,,0,,0,,1,400 mg/m^,0, 102,4,0,,0,,0,,2,,0, 102,5,,,,,,,,,, 106,1,0,,0,,1,20 mg,0,,0, 106,2,,,,,,,,,, 106,3,,,,,,,,,, 106,4,0,,1,2000 mg,1,20 mg,0,,0, 106,5,,,,,,,,,, 107,1,0,,0,,1,20 mg,1,400 mg/m^,0, 107,2,,,,,,,,,, 107,3,0,,0,,1,20 mg,1,400 mg/m^,0, 107,4,0,,0,,1,20 mg,1,200 mg/m^,0, 107,5,,,,,,,,,, 108,1,0,,0,,0,,0,,0, 108,2,0,,0,,0,,0,,0, 108,3,0,,0,,0,,0,,0, 108,4,0,,0,,0,,0,,0, 108,5,,,,,,,,,, 109,1,1,25 mg,0,,0,,0,,1,50 mg/kg 109,2,,,,,,,,,, 109,3,1,25 mg,1,2000 mg,0,,0,,2, 109,4,,,,,,,,,, 109,5,,,,,,,,,, ;;;; run; data want; set have; array c (*) mtx ssz lef rtx toc ; array d (*) mtx_dose ssz_dose lef_dose rtx_dose toc_dose ; array n (5) $ 25 _temporary_ ("MTX","SSZ","LEF","RTX","TOC"); length notes $ 200; if max(of c(*)) = 0 then notes="No current meds"; Else do i=1 to dim(c); if c[i]=1 then notes=catx(',',notes,catx(' ',"Taking",n[i],d[i])); if c[i]=2 then notes=catx(',',notes,catx(' ',"Stopped",n[i])); end; run; Thanks!

hanahch · ‎08-24-2021

Hi SAS community, I have a dataset that keeps track of medication (mtx,ssz, lef, rtx, toc, etc) taken at each encounter (enc). The code for each medication is 0=not currently taking, 1=currently taking, and 2= stopped med. The unit for mtx_dose, ssz_dose, and lef_dose is in mg, rtx_dose in mg/m^ and toc_dose in mg/kg. I would like to add a note column that summarizes the change in medcations at each encounter by comparing the current meds to the meds in the previous encounters. The program below works fine except that when a new med is added, I want to check if it hasn't been taken previously. The note should show the current meds and new meds with their correct corresponding dose units, and stopped meds. An example of ID 109 shows med mtx taken since enc=1 and continued till enc 3, new med ssz added at enc 3 that has not been taken previously, and med_toc stopped at enc 3, so the note at enc 3 should indicate "Taking MTX 25 mg, added SSZ 2000 mg, stopped TOC". Another example of id 106 enc 4, the unit is incorrect for LEF and it should indicate "Taking SSZ 2000 mg,Taking LEF 20 mg/m^2". data have; infile datalines dsd truncover; input id:$11. enc:32. mtx:32. mtx_dose:32. ssz:32. ssz_dose:32. lef:32. lef_dose:32. rtx:32. rtx_dose:32. toc:32. toc_dose:32.; datalines4; 102,1,0,,0,,0,,1,400,0, 102,2,0,,0,,0,,1,,0, 102,3,0,,0,,0,,1,400,0, 102,4,0,,0,,0,,2,,0, 102,5,,,,,,,,,, 106,1,0,,0,,1,20,0,,0, 106,2,,,,,,,,,, 106,3,,,,,,,,,, 106,4,0,,1,2000,1,20,0,,0, 106,5,,,,,,,,,, 107,1,0,,0,,1,20,1,400,0, 107,2,,,,,,,,,, 107,3,0,,0,,1,20,1,400,0, 107,4,0,,0,,1,20,1,200,0, 107,5,,,,,,,,,, 108,1,0,,0,,0,,0,,0, 108,2,0,,0,,0,,0,,0, 108,3,0,,0,,0,,0,,0, 108,4,0,,0,,0,,0,,0, 108,5,,,,,,,,,, 109,1,1,25,0,,0,,0,,1,50 109,2,,,,,,,,,, 109,3,1,25,1,2000,0,,0,,2, 109,4,,,,,,,,,, 109,5,,,,,,,,,, ;;;; run; data want; set have; array c (*) mtx ssz lef rtx toc ; array d (*) mtx_dose ssz_dose lef_dose rtx_dose toc_dose ; array n (5) $ 25 _temporary_ ("MTX","SSZ","LEF","RTX","TOC"); length notes $ 200; if max(of c(*)) = 0 then notes="No current meds"; Else do i=1 to dim(c); if c[i]=1 then notes=catx(',',notes,catx(' ',"Taking",n[i],d[i],'mg')); if c[i]=2 then notes=catx(',',notes,catx(' ',"Stopped",n[i])); end; run; Any help would be greatly appreciated. Thanks!

hanahch · ‎08-22-2021

Hi, I was quick to accept the solution to SAS codes you provided previously and I realized that I need further help with these data. First, I'd like to respond to your questions you addressed earlier. The code for each of the medication (med_mtx, med_ssz, med_lef, med_hcq, med_etn) is 0=not currently taking, 1=currently taking, and 2= stopped med. The unit values for the medication dose med_mtx_dose, med_ssz_dose, and med_hcq_dose are in mg, the value for med_lef_dose is in mg/m^2, and the value for med_etn_dose is mg/kg. I would like to create a note column to summarize the medication status at each encounter (variable enc) based on these rules: 1) no current med when all meds =0 2) current med has been taken since from the previous encounters (=1) 3) new med "added" but not previously taken (=0 or blank in the previous encounters) 4) stopped med when med =2 An example of ID 1029 shows that med_mtx has been taken since enc=1 and continued till enc 3, new med_ssz added at enc 3 that has not been taken previously, and med_etn stopped at enc 3, so the note column at enc 3 should indicate "Taking MTX 25 mg, Added SSZ 2000 mg, Stopped ETN". Another example of id 1025 enc 4 the note should indicate "Taking SSZ 2000 mg|Taking LEF 20 mg/m^2". I'm not sure of how to exactly code this since the program will need to look at previous encounters and compare then changes of medication....if that makes any sense. Any help would be greatly appreciated. Thanks!

hanahch · ‎08-13-2021

Sorry about the discrepancy in the data WANT due to cut and paste. Your solution is exactly what I wanted. Thank you so much for your help and I really appreciate it!

hanahch · ‎08-11-2021

Hi SAS Community. I have a dataset below that keeps track of patient's medications (mtx,ssz, lef, hcq, etn, etc) at each study encounter. The codes for the each med are 0=not currently taking, 1=currently taking, and 2= stopped med, and the medication doses all in mg. data have; infile datalines dsd truncover; input id:$11. enc:32. med_mtx:32. med_mtx_dose:32. med_ssz:32. med_ssz_dose:32. med_lef:32. med_lef_dose:32. med_hcq:32. med_hcq_dose:32. med_etn:32. med_etn_dose:32.; datalines4; 1016,1,0,,0,,0,,0,,0, 1016,2,,,,,,,,,, 1016,3,,,,,,,,,, 1016,4,,,,,,,,,, 1016,5,,,,,,,,,, 1017,1,0,,0,,0,,1,400,0, 1017,2,0,,0,,0,,1,,0, 1017,3,0,,0,,0,,1,400,0, 1017,4,0,,0,,0,,2,,0, 1017,5,,,,,,,,,, 1018,1,0,,0,,1,20,0,,0, 1018,2,,,,,,,,,, 1018,3,,,,,,,,,, 1018,4,,,,,,,,,, 1018,5,,,,,,,,,, 1023,1,1,20,0,,0,,0,,0, 1023,2,,,,,,,,,, 1023,3,,,,,,,,,, 1023,4,,,,,,,,,, 1023,5,,,,,,,,,, 1024,1,0,,0,,0,,0,,0, 1024,2,,,,,,,,,, 1024,3,,,,,,,,,, 1024,4,,,,,,,,,, 1024,5,,,,,,,,,, 1025,1,0,,0,,1,20,0,,0, 1025,2,,,,,,,,,, 1025,3,,,,,,,,,, 1025,4,0,,1,2000,1,20,0,,0, 1025,5,,,,,,,,,, 1026,1,0,,0,,1,20,1,400,0, 1026,2,,,,,,,,,, 1026,3,0,,0,,1,20,1,400,0, 1026,4,0,,0,,1,20,1,200,0, 1026,5,,,,,,,,,, 1028,1,0,,0,,0,,0,,0, 1028,2,0,,0,,0,,0,,0, 1028,3,0,,0,,0,,0,,0, 1028,4,0,,0,,0,,0,,0, 1028,5,,,,,,,,,, 1029,1,1,25,0,,0,,0,,1,50 1029,2,,,,,,,,,, 1029,3,1,25,1,2000,0,,0,,2, 1029,4,,,,,,,,,, 1029,5,,,,,,,,,, ;;;; I would like to add a note/text column that summarizes the change in medcations at each encounter by comparing the current meds to the meds at the previous encounters. The note column needs to show the current meds and the doses, med stopped, and new meds added, like this: Your help is greatly appreciated!

hanahch · ‎01-11-2021

The goal is to pull the most complete vital data on bp_sys, bp_dias and BMI from an encounter that is closest within 15 days prior to dxdate. If an encounter closest to dxdate has the most missing data on all 3 variables then it needs to search the next records until the most complete vital data is found. If no vital data within 15 days then it needs to search up to 30 days. Below are some examples of cases that explained how I marked the encounters in the output: ID 3531- the enc_date is not prior to dxdate --> do not mark as 1 ID 3590-closest encounter (1/24/2017) prior to dxdate with complete vital data --> mark as 1 ID 3669-no vital data within 15 days so look back 30 days. Enc_date 5/15/2011 has the most complete vital data --> mark as 1 ID 3695-no vital data within 15 days so look back 30 days. Enc 4/272014 has the most complete vital data --> mark as 1 Hope my explanation makes sense. Thank you for your help!

hanahch · ‎01-11-2021

Hello SAS experts, I would like to pull complete BP and BMI data from encounter date closest prior to dx date within 15 days; If none within 15 days then look back up to 30 days. What I have: data have; input id enctype $ (enc_date dx_date)(:mmddyy10.) bp_sys 31-33 bp_dias 35-36 bmi 38-43 datawant 45-46; format enc_date dx_date mmddyy10.; datalines; 3531 op 11/27/2016 11/27/2016 120 82 3531 gm 11/27/2016 11/27/2016 120 82 30.22 3590 ip 01/01/2017 01/25/2017 150 58 30.72 3590 gm 01/10/2017 01/25/2017 150 60 30.72 3590 op 01/24/2017 01/25/2017 150 59 30.11 3669 op 05/15/2011 06/08/2011 136 58 3669 op 06/08/2011 06/08/2011 126 60 3669 gm 06/15/2011 06/08/2011 112 58 28.78 3669 op 06/01/2011 06/08/2011 3695 ip 04/27/2014 05/14/2014 125 80 3695 op 05/21/2014 05/14/2014 125 70 3995 op 05/13/2014 05/14/2014 125 80 3995 gm 05/15/2014 05/14/2014 125 70 3744 op 01/02/2018 01/12/2018 114 60 28.96 3744 ip 01/10/2018 01/12/2018 4508 ip 08/12/2018 08/13/2018 162 84 31.6 4524 op 09/22/2017 09/12/2017 110 76 35.79 4704 gm 05/01/2011 05/03/2011 141 74 38.59 4704 op 05/02/2011 05/03/2011 128 70 38.04 7734 op 02/21/2011 02/21/2011 7734 op 07/07/2011 02/21/2011 7734 gm 02/20/2011 02/21/2011 132 64 41.35 8969 ip 03/08/2013 03/26/2013 140 86 31.48 8969 op 03/09/2013 03/26/2013 132 88 31.14 8969 op 02/08/2013 03/26/2013 158 80 32.39 8969 op 04/17/2013 03/26/2013 140 78 31.33 ; data dave; set have; daydiff=intck('day',dx_date,enc_date); run; What I want to have: Your help is greatly appreciated! Thank you!

hanahch · ‎12-09-2020

Sorry one more thing - How would you change in the program so that it outputs only the encounters that have the most data of ht, wt, and BMI? Thanks!

hanahch · ‎12-09-2020

The program works great! Thank so much!

hanahch · ‎12-09-2020

Hi, I have a dataset that looks like the below: id enc_type enc_date mi _date daysdiff bp_sys bp_dias ht wt bmi 3669 CL 6/8/2011 6/8/2011 0 126 60 3669 CL 6/15/2011 6/8/2011 7 3669 PR 6/17/2011 6/8/2011 9 136 58 3669 PR 6/23/2011 6/8/2011 15 112 58 175.26 195 28.78 -> want this 3695 IM 5/14/2014 5/14/2014 0 125 80 3695 IM 5/21/2014 5/14/2014 7 125 70 160.02 -> want this 3744 PU 1/8/2018 12/14/2017 25 114 60 165.1 174 -> want this 3744 IM 1/8/2018 12/14/2017 25 572 PU 6/8/2011 6/8/2011 0 86 195 208 32.7 572 CL 4/25/2013 3/26/2013 30 124 86 195 207 31.4 -> want this 574 PR 4/3/2013 6/9/2013 63 140 88 172.72 224.5 34.1 575 PR 4/8/2013 3/26/2013 13 158 80 213 32.3 -> want this I'd like to pull the most complete data on BP, Wt, Ht, and BMI from encounter date that is closest within +/30 from MI_date. Daysdiff column is the duration in days between the two dates. If an encounter closest to MI_date has incomplete data then it needs to search for the next record till a record with complete data is found. Your help is greatly appreciated!

Online Status	Offline
Date Last Visited	‎08-04-2023 03:03 AM

Reading multiple external folder names and files

How to separate string into numeric and character variables

Re: Summarizing medication changes

Summarizing medication changes

Re: How to create a text field to summarize medication changes across ...

Re: How to create a text field to summarize medication changes across ...

How to create a text field to summarize medication changes across obse...

Re: Help with pulling data from encounter based on date diference

Help with pulling data from encounter based on date diference

Re: Pulling data closest to a date

Reading multiple external folder names and files

How to separate string into numeric and character variables

Re: Summarizing medication changes

Summarizing medication changes

Re: How to create a text field to summarize medication changes across ...

Re: How to create a text field to summarize medication changes across ...

How to create a text field to summarize medication changes across obse...

Re: Help with pulling data from encounter based on date diference

Help with pulling data from encounter based on date diference

Re: Pulling data closest to a date

Re: Pulling data closest to a date

Pulling data closest to a date