I have the data in following format: data have; input id date :date9. Supply drug $; datalines; 1 03JAN19 90 AB 2 02JAN19 -90 AB 2 15FEB2019 30 AB 3 02JAN19 30 AB 3 05JAN19 -30 AB 3 30MAR19 30 AB 4 03APR19 60 AB 5 01JAN19 60 CD 5 02FEB19 60 CD 5 06FEB19 -60 CD 6 01MAR19 30 CD 6 01APR19 30 CD 7 01JAN19 60 CD 7 02FEB19 60 CD 7 06FEB19 -60 XY 8 01MAR19 30 CD 8 01APR19 30 CD ; I need help with deleting negative supply of same drug in this data (the first and second observation for ID 1, the first and second observation for ID 3, second and third observation of ID 5 in this example, but not for second and third observation of ID 7), considering the second observations are actually a refund or reversal of the earlier observation (reversal within 7days of a visit). Thanks in advance for the help. ... View more

Hello SAS Community, I am currently working on a project where I have more than two groups I would like to compare using propensity score matching. I am familiar with using PROC PSMATCH for a typical treatment vs. control setup, but I am unsure how to approach it for multiple group comparisons. Is there a way to directly compare more than two groups using PROC PSMATCH? If not, what is the best practice? Should I perform pairwise comparisons and then adjust for multiple comparisons? Are there alternative techniques or procedures in SAS that might be better suited for this type of analysis? Any guidance, sample code, or references would be greatly appreciated! Thank you in advance! ... View more

Hi,  I have the following dataset: data have; input ID Var1 Var2 Var3new Var4new Var5old Var6old; datalines; 1 11 12 13 14 15 16 2 21 22 23 24 25 26 3 31 32 33 34 35 36 4 41 42 43 44 45 46 5 56 51 52 53 54 55 56 ; run;   First I want a dataset after dropping all variables with names ending with "old" from the dataset (Var5old, Var6old) and in the new dataset I want to rename the variables where column name ends with "new" (Var3new, Var4new as Var3 Var4). As I have 100s of variables do not want to manually rename all of them. I am looking for a final dataset:   data want; input ID Var1 Var2 Var3 Var4; datalines; 1 11 12 13 16 2 21 22 25 26 3 31 34 35 36 4 43 44 45 46 51 52 53 54 ; run; ... View more

I have two tables:   data A; length var2 $ 50; input var1 var2 $ &; datalines; 1 zzzblue sky 2 BlUe sky 3 green leaf 4 red apple 5 red apple ; run;     data B; length var4 $ 50; input var3 var4 $ &; datalines; 14545 BLUE 26464 blue 34646 gReen ; run;   Var4 in dataset B matches partially with var2 in dataset A. I need help with a many to many merge based on this partial match where the new dataset will look like this-   var1 var2 var3  var4 1 zzzblue sky 14545 BLUE 2 BlUe sky  26464 blue 3 green leaf 34646 gReen ... View more