data a; input id name&$40. age salary; cards; 1 Andy Murray 28 1500000 2 Stewart Christen 31 2500000 3 Adam Levine 35 800000 4 Bill White 40 1500000 5 Army Grey 20 300000 6 Dawson Robert 30 500000 ; run;   Let's say this is the data and there are 10k such entries. Number 2 and 6 have actual names as Christen Stewart and Robert Dawson.    How can we identify what all names are swapped and how can we correct them?   ... View more

Difference between end of current drug and start of next same drug is more than 60,consider them two different usages otherwise club them as single usages with minimum start and maximum end. INPUT DATA DRUG   S.DATE           E.DATE A           24-Sep-19      03-Dec-19 A         17-Jan-20            21-Feb-20 A       21 -MAY-20           20-Jun-20 B      30-Jun-20           29-Aug-20 B       13-OCT-20           12-NOV-20 OUPUT DATA DRUG     S.DATE      E.DATE A         24-Sep-19            21-Feb-20 A       21-May-20            21-Jun-20 B     30-Jul-20               12-NOV-20 ... View more

how to create Create observations depending on the length of the Name. ... View more