Hi All, Here is the data i have been working on. I tried to use transpose and reshape and it did not work. I would like to collapse the ADATE variable into pre and post and have their corresponding Prediff and PostDiff variables.  Data Have: ID Name ReportDate Match ADATE Generic Prediff Postdiff 1 TP 9/27/2016 A,B         3 TE 10/26/2016           3 TP 10/26/2016 A,B 11/25/2016 A   29.10 4 TP 11/18/2016 A,B 8/16/2015 A -460.797   4 TP 11/18/2016 A,B 1/14/2017 A   56.20 7 TP 2/18/2017 A,B 3/10/2017 A   19.38 8 TP 2/21/2017 A,B 3/7/2017 A   13.31 8 TP 2/21/2017 A,B 2/21/2017 A -0.68   9 TP 4/17/2017 A,B 4/24/2017 A   6.136 9 TP 4/17/2017 A,B 4/15/2017 A -2.86     Data Want: ID Name ReportDate Match ADATE_pre ADATE_Post Generic Prediff Postdiff 1 TP 9/27/2016 A,B           3 TE 10/26/2016             3 TP 10/26/2016 A,B 11/25/2016   A   29.10 4 TP 11/18/2016 A,B 8/16/2015 1/14/2017 A -460.79 56.2 7 TP 2/18/2017 A,B 3/10/2017   A   19.38 8 TP 2/21/2017 A,B 3/7/2017 2/21/2017 A -0.68 13.3 9 TP 4/17/2017 A,B 4/15/2017 4/24/2017 A -2.86 6.136 ... View more

Hi all, Here is my dataset with all characters. I want to extract the drug name from the ReactionToDrug column and collapse symptoms in one row. Along with the ADR classification that is listed in the ItemName column. For example, ID#1 has Docetaxel, and had two symptoms: Cardiac and Pulmonary. Also, there was no ADR classification in the ItemName so this row is empty. For ID#2, it has Cetuximab drug and 4 different symptoms: Cardiac, Pulmonary, Dermatologic, Hypersensitvity. It also has an ADR classification as “Severe: Is life threatening or causes permanent injury or death”. There are some duplicates, but it needs to be counted only once based on the drug. For ID#3, The drug is Cetuximab and has 2 symptoms: Hives and Itching. Also, has the ADR classification as “Minor: requires no medical treatment or has no effect on continuation of therapy.” For ID#4, it has 3 different drugs with corresponding symptoms and ADR classification.     Dataset Have: SubjectID ReactionToDrug ItemName ValueALL 1 DOCEtaxel ivpb, ABFFETGEYGHDFDFDRWREYTRHGDFD Cardiac Tachycardia 1 DOCEtaxel ivpb, ABFFETGEYGHDFDFDRWREYTRHGDFD Pulmonary Shortness of Breath 2 cetuximab ivpb, SDGGFHFFGHFGFDGDFGDGDGDGDGDHFHFHFHFF ADR Classification Severe: Is life threatening  2 cetuximab ivpb, SDGGFHFFGHFGFDGDFGDGDGDGDGDHFHFHFHFF Cardiac Chest Pain 2 cetuximab ivpb, SDGGFHFFGHFGFDGDFGDGDGDGDGDHFHFHFHFF Cardiac Hypotension 2 cetuximab ivpb, SDGGFHFFGHFGFDGDFGDGDGDGDGDHFHFHFHFF Cardiac Tachycardia 2 cetuximab ivpb, SDGGFHFFGHFGFDGDFGDGDGDGDGDHFHFHFHFF Dermatologic Flushing 2 cetuximab ivpb, SDGGFHFFGHFGFDGDFGDGDGDGDGDHFHFHFHFF Hypersensitivity Anaphylaxis 2 cetuximab ivpb, SDGGFHFFGHFGFDGDFGDGDGDGDGDHFHFHFHFF Hypersensitivity Bronchospasm/stridor 2 cetuximab ivpb, SDGGFHFFGHFGFDGDFGDGDGDGDGDHFHFHFHFF Pulmonary Bronchospasm 2 cetuximab ivpb, SDGGFHFFGHFGFDGDFGDGDGDGDGDHFHFHFHFF Pulmonary Shortness of Breath 2 cetuximab ivpb, SDGGFHFFGHFGFDGDFGDGDGDGDGDHFHFHFHFF ADR Classification Severe: Is life threatening  2 cetuximab ivpb, SDGGFHFFGHFGFDGDFGDGDGDGDGDHFHFHFHFF Cardiac Chest Pain 2 cetuximab ivpb, SDGGFHFFGHFGFDGDFGDGDGDGDGDHFHFHFHFF Cardiac Hypotension 2 cetuximab ivpb, SDGGFHFFGHFGFDGDFGDGDGDGDGDHFHFHFHFF Cardiac Tachycardia 2 cetuximab ivpb, SDGGFHFFGHFGFDGDFGDGDGDGDGDHFHFHFHFF Dermatologic Flushing 2 cetuximab ivpb, SDGGFHFFGHFGFDGDFGDGDGDGDGDHFHFHFHFF Hypersensitivity Anaphylaxis 2 cetuximab ivpb, SDGGFHFFGHFGFDGDFGDGDGDGDGDHFHFHFHFF Hypersensitivity Bronchospasm/stridor 2 cetuximab ivpb, SDGGFHFFGHFGFDGDFGDGDGDGDGDHFHFHFHFF Pulmonary Bronchospasm 2 cetuximab ivpb, SDGGFHFFGHFGFDGDFGDGDGDGDGDHFHFHFHFF Pulmonary Shortness of Breath 3 cetuximab ivpb, SDGGFHFFGHFGFDGDFGDGDGDGDGDHFHFHFHFF ADR Classification Minor: requires no medical treatment  3 cetuximab ivpb, SDGGFHFFGHFGFDGDFGDGDGDGDGDHFHFHFHFF Hypersensitivity Hives 3 cetuximab ivpb, SDGGFHFFGHFGFDGDFGDGDGDGDGDHFHFHFHFF Hypersensitivity Itching 4 nivolumab IVPB, GDFDFDFDGDHFHFHFGDGDGDGDGDG ADR Classification Minor: requires no medical treatment  4 nivolumab IVPB, GDFDFDFDGDHFHFHFGDGDGDGDGDG Cardiac Tachycardia 4 nivolumab IVPB, GDFDFDFDGDHFHFHFGDGDGDGDGDG Dermatologic Flushing 4 PACLitaxel ivpb, FDGDGDHFHFHFJGJGJGJGJGJGJGJ ADR Classification Significant: Results in hospital admission,  4 PACLitaxel ivpb, FDGDGDHFHFHFJGJGJGJGJGJGJGJ Dermatologic Flushing 4 PACLitaxel ivpb, FDGDGDHFHFHFJGJGJGJGJGJGJGJ Pulmonary Shortness of Breath 4 DOCEtaxel ivpb, ABFFETGEYGHDFDFDRWREYTRHGDFD ADR Classification Significant: Results in hospital admission,  4 DOCEtaxel ivpb, ABFFETGEYGHDFDFDRWREYTRHGDFD Dermatologic Flushing   Data Want: ID DrugName Symptoms ADR Classification  1 DOCEtaxel Cardiac, Pulmonary   2 cetuximab Cardiac, Pulmonary, Dermatologic, Hypersensitvity Severe: Is life threatening  3 cetuximab Hives, Itching Minor: requires no medical treatment  4 Nivolumab Cardiac, Dermatologic Minor: requires no medical treatment  4 Paclitaxel Dermatologic, Pulmonary Significant: Results in hospital admission 4 Docetaxel Dermatologic Significant: Results in hospital admission ... View more

Hi all,  I am trying to get a formatted frequency table and I tried PROC freq and tabulate but i can't seem to figure it out. Here is my dataset: I will need the output in a 3 dimensional table. I only need the count and respective totals and in the specific format as shown below. Thanks, Item Code Category A H Tar B H IO C L End D L IO A H End B H Tar C H IO D L End A L IO B L End C H Tar A L IO B H End C L IO D H End   Want: Item Code Tar IO End Total A             H 1   1 2   L   2   2 B             H 1 1 1 3   L     1 1 C             H 1 1   2   L   1 1 2 D             H     1 1   L   1 1 2 Total   3 6 6 15 ... View more