Hi, I would like to concatenate across columns containing a string of single characters to obtain a new column containing the letters arranged in alphabetic order. This will allow me to identify all the people with the same combination.    I would really appreciate any help! Thank you!   data have: id d1 d2 d3 d4  1 A B C D  2 B D A C 3 D A B C 4 E B F D etc   data want: id concat 1 ABCD 2 ABCD 3 ABCD 4 BDEF etc ... View more

Hello, I am trying to define concomitant use of drugs.  I have a great solution to my problem with a SAS data step at the link below: https://communities.sas.com/t5/Base-SAS-Programming/Concomitant-drug-medication-use/m-p/351710#M81886 However, the only issue is that I have a very large dataset (~600K rows) and those codes require a ton of memory and my computer crashes. I wonder if anybody could suggest an alternative, perhaps a proc sql solution, that would not require as much memory and computational capacity.  Thank you very much! Any help would be greatly appreciated!   Katie   ... View more

Hello, I am a bit new to SAS and any help with my issue would be of great help.   I have a dataset organized as below: ID DRUG START_DT DAYS_SUPP END_DT 1 A 2/17/10 30 3/19/10 1 B 5/6/09 30 6/5/09 1 C 7/9/11 60 9/7/11 1 E 3/1/10 90 5/30/10 1 B 1/1/09 90 4/1/09 1 D 2/1/09 30 3/3/09 1 C 5/6/12 90 8/4/12 2 B 4/1/12 60 5/31/12 2 A 7/1/10 30 7/31/10 2 C 8/3/10 90 11/1/10 2 D 11/1/13 90 1/30/14 2 E 12/5/13 90 3/5/14 2 A 2/1/11 90 5/2/11   I would like to identify individuals that are using two or more different drugs at the same time for at least one month. Use of drug A (or B) may begin before (or after) use of drug B (or A); also, duration of drug A can fall completely within the duration of drug B (and vice versa). If possible, I would also like to keep track of the different types of drug combinations (e.g. AB, CD, ABCE etc).   If a person has used two or more drugs concurrently for at least one month, I would then like to capture that first date when this criteria is met (to merge with another type of dataset).    Any help is much appreciated!   Thank you very much! ... View more

Hello, I would like to create a new date variable by adding values (days) to the date in another column. I ran the following code; however, the new column 'END_DATE' shows the same date as the 'ORDER_DATE'   Any help is much appreciated! Thank you!   data td2; set td1; END_DATE=ORDER_DATE + MED_QTY1; /*this variable contains days; can be 30, 60, 90 etc */ format END_DATE DATETIME.; informat END_DATE ANYDTDTM40.; run; ... View more