Hi All, Can anyone tell me the code that will find the students who has taken Math 3. Student_ID        Course 101                   English 2 101                   Math 1 101                   Math 3 102                   English 1 102                   Math 2 102                   Math 2 103                   Math 2 103                   English 1 104                   English 1 104                   Math 3 Output would be: Student_ID        Course 101                   English 2 101                   Math 1 101                   Math 3 104                   English 1 104                   Math 3 Thanks, ... View more

Hi there, I tried to merge two table where variable lengths are different in two different table for the same variable. Can anyone help me writing the code to add these two table with set statement plco. Table1: Student_ID        Name 101                   John 103                   Allison 105                   Michael Table2: Student_ID        Name 107                   Johan 109                   Chowdhury Thanks, ... View more

I am trying to import data from Access 2013 to SAS 9.3 with the following code. Can anyone tell me what is the mistake I am doing? PROC IMPORT DBMS=ACCESSCS replace; OUT=Apple.MyDATA1 DATATABLE='details'; DATABASE="E:\SAS\MyTable.accdb"; RUN;3 I get the following error: ERROR: Failed to connect to the Server ... View more

Hi All, I never worked on a Dynamic Summary Table. Can anyone help me with some example code/reference/suggestion on how to produce a Summary table like this: Significant variables Age Number of Patients (%) p value Unadjusted odds ratio 95% Confidence interval 65 92 (30.5) p<.01 65-75 65 (45.4) 0.25-0.48 75-84 45 (41) 85+ 30 (23.8) No. of Visit 1 2 3 4 or more mean (standard deviation) median (range) Diagnosis Breast Cancer Lung cancer Cancer of the pancreas Congestive heart failure Copd Cancer of the cervix Others Admission Yes No Day of Visit Monday Tuesday Wednesday Thursday Friday Saturday Sunday ... View more

Hi All, Can anyone tell me where and how should I add the 'where clause' in the following code for merging two table. I want to add where name='Jack' for tabl1. Data out; merge Table1(in=a) apple.Table2(in=b); by ID1;  /*Common variable*/ if a=0; run; ... View more