Hi Community,   I have a very simple merge code:   proc sort data = table1; by subject; run; proc sort data = table2; by subject; run; data table12; merge table1 (in=a) table2; by subject; if a; run;   table1 SUBJECT ae_start ae_end ae_dur 118118 31-Mar-15 31-Mar-15 1 118872 19-Apr-15 09-May-15 21   table2 Trial SUBJECT age sex abc 118118 78 male abc 118151 60 male abc 118377 73 male abc 118682 84 male abc 118730 60 male abc 118872 81 female   after merge SUBJECT ae_start ae_end ae_dur Trial age sex 118118 31-Mar-15 31-Mar-15 1       118872 19-Apr-15 09-May-15 21         somehow, data from table2 data won't show in the merged table, I double checked the column property, every attribute (Type, Length, Format, and Informat are all teh same), what would be the other cause that failed this merge?   As always, thank you all for the past support!  ... View more

  Dear Community, I am quite new to SAS programming and has been learning and using SAS to clean and manipulate data for about 2 months (thanks to the great and generous help I got from this forum) and now I want to challenge myself to learn tabulating summary reports (Example 1, 3 and 4 in the attached paper). Below is a simple example I found on internet:     0verall N=70   ------ ------------ System Organ Class   Subject Preferred Term Event n(%) --------------------------------------------------------- Overall 20 14(20) Cardiac disorders 6 4 (6) Atrial flutter 1 1 (1) Cardiac failure 1 1 (1) Palpitations 3 2 (3) Tachycardia 1 1 (1)   This example above was written in SAS Macro, which seems very complicated to me for now and I plan to learn later when I have had more experience. For now, I just want to try to use SAS code to generate the summary above. The Marco codes in the attached abstract is too hard to follow now. For those not familiar with clinical trial data, I have a data set consisting variables like subject id, aeterm, preferred term and system organ class (SOC) of thousand observation, which I would like to turn the data into the summary table like above.  Below is the part of the data usubjid aeterm preferred term aebodsys 1002 aspiration pneumonitis Pneumonia aspiration Respiratory, thoracic and mediastinal disorders 1002 Epistaxis Epistaxis Respiratory, thoracic and mediastinal disorders 1003 ischemic stroke Ischaemic stroke Nervous system disorders 1007 Multiple Myeloma Plasma cell myeloma Neoplasms benign, malignant and unspecified (incl cysts and polyps) 1007 Dehydration Dehydration Metabolism and nutrition disorders 1007 Worsening Pleural Effusions Pleural effusion Respiratory, thoracic and mediastinal disorders 1011 Orolingual angioedema Angioedema Skin and subcutaneous tissue disorders 1011 Worsening of Congestive heart failure Cardiac failure congestive Cardiac disorders 1011 Pneumonia Pneumonia Infections and infestations 1012 Recurrent Stroke Cerebrovascular accident Nervous system disorders 1013 Right femoral pesudoaneurysm Vascular pseudoaneurysm Injury, poisoning and procedural complications 1016 Malignant MCA infarction (Index Stroke) Ischaemic stroke Nervous system disorders 1018 Progression of Stroke Stroke in evolution Nervous system disorders 1021 Acute Coronary Syndrome Acute coronary syndrome Cardiac disorders 1026 Progression of Ischemic Stroke Stroke in evolution Nervous system disorders   Any help would be greatly appreciated! Thanks ... View more

Dear community,   Part of the CSV file looks like below:   9001 no 2018-01-23 18:18 multiphase or dynamic 9002 no 2018-01-31 16:49 multiphase or dynamic 9003 no 2018-02-06 11:03 multiphase or dynamic 9004 no 2018-03-20 17:58 multiphase or dynamic 9005 no 2018-04-28 10:44 multiphase or dynamic 9006 no 2018-05-02 * single phase 9007 no 2018-07-13 10:28 multiphase or dynamic 10001 no 2018-01-12 13:04 multiphase or dynamic 10002 no 2018-05-17 17:09 multiphase or dynamic 10003 no *   * 10004 no 2018-06-26 9:49 multiphase or dynamic 11001 no 2018-02-23 16:38 multiphase or dynamic 11002 no 2018-03-06 9:43 multiphase or dynamic 11003 no 2018-04-19 8:28 multiphase or dynamic 11004 no 2018-04-19 13:23 multiphase or dynamic     proc import datafile="C:\Users\sasuser\sam.csv"     out=aolc dbms=csv replace ; getnames=yes;run;   Log show the message below:   NOTE: Invalid data for prstdtc_cta_time in line 169 56-56. RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+ 169       incomplete,2,1824R0089007,30,8,2,09006,no,,,2018/05/02,*,single phase,left,Unchecked,       86  Unchecked,Unchecked,Checked,Unchecked,Unchecked,Unchecked,Unchecked,Unchecked,Uncheck      171  ed,Unchecked,Unchecked,good,Help,incomplete,18/06/13 13:30:56,18/07/12 16:09:41, 250 DFSTATUS=incom DFVALID=2 DFRASTER=1824R0089007 DFSTUDY=30 DFPLATE=8 DFSEQ=2 usubjid=9006 proccur_mrascan=no prstdtc_dt=  prstdtc_time=  prstdtc_cta_dt=2018-05-02 prstdtc_cta_time=. prtrt_cta=single phase prlat_occluson=left faloc_icat=Unchecked faloc_ical=Unchecked faloc_m3distal=Unchecked faloc_proximal=Checked faloc_bothm2=Unchecked faloc_vrtbrslr=Unchecked faloc_distalm1=Unchecked faloc_oneofm2=Unchecked faloc_aca=Unchecked faloc_midm1=Unchecked faloc_trifrctn=Unchecked faloc_pca=Unchecked faorres_colatrls=good Help=Help DFSCREEN=incom DFCREATE=18JUN13:13:30:56 DFMODIFY=18JUL12:16:09:41 VAR32=  _ERROR_=1 _N_=168 NOTE: Invalid data for prstdtc_cta_dt in line 173 45-45. 173       incomplete,1,1821R006R007,30,8,2,10003,no,,,*,,*,*,Unchecked,Unchecked,Unchecked,Unch       86  ecked,Unchecked,Unchecked,Unchecked,Unchecked,Unchecked,Unchecked,Unchecked,Unchecked      171  ,*,Help,incomplete,18/05/26 15:14:59,18/07/19 07:51:55, 225 DFSTATUS=incom DFVALID=1 DFRASTER=1821R006R007 DFSTUDY=30 DFPLATE=8 DFSEQ=2 usubjid=10003 proccur_mrascan=no prstdtc_dt=  prstdtc_time=  prstdtc_cta_dt=. prstdtc_cta_time=. prtrt_cta=* prlat_occluson=* faloc_icat=Unchecked faloc_ical=Unchecked faloc_m3distal=Unchecked faloc_proximal=Unchecked faloc_bothm2=Unchecked faloc_vrtbrslr=Unchecked faloc_distalm1=Unchecked faloc_oneofm2=Unchecked faloc_aca=Unchecked faloc_midm1=Unchecked faloc_trifrctn=Unchecked faloc_pca=Unchecked faorres_colatrls=* Help=Help DFSCREEN=incom DFCREATE=18MAY26:15:14:59 DFMODIFY=18JUL19:07:51:55 VAR32=  _ERROR_=1 _N_=172   ERROR: Import unsuccessful.  See SAS Log for details.   IS there a way to fix this?   Thanks! ... View more

Dear community,   I have a survey questionnaire, one of the questions is to ask people to pick their most favourite fruit(s) from the list below (select all that apply)   apple pear orange grape watermelon banana   The data ended like below: pid fruit1 fruit2 fruit3 fruit4 fruit5 fruit6 1 apple           2   pear         3     orange       4     orange       5       grape     6         watermelon   7   pear       banana 8 apple     grape     9     orange       10 apple         banana 11         watermelon   12     orange       13     orange       14 apple     grape     15         watermelon   16 apple         banana 17       grape     18 apple           19             20 apple             Since this is one question in the dataset and I would think it should be presented as one variable (e.g., fruit), a few observations do have multiple selections though.   My question is how I should consolidate the data into one column (e.g., fruit)   Thanks ... View more