Hi I have 4 sas datasets ab bc ca db   and i have to export to excel so that te excel workbook has 4 sheets ab bc ca and i need to share the excel file to the share point location as i dont have PC SAS and my SAS is on Citrix (Remote SAS )     can anyone pls help ... View more

datea    time                     customer 2015-11-20  11:18:36.0000000  lucy 2015-11-20  11:21:09.0000000         lucy dateb      amount 2015-11-20  250 output datea    time                     customer  amount 2015-11-20  11:18:36.0000000  lucy   250 2015-11-20  11:21:09.0000000         lucy   250   I have three tables and i have an output where it has two records but the amounts are duplicated so how to pick a record with max time . can anyone pls help ... View more

Hi , I have a code  . I ran the code but i am getting an error . Can anyone pls help     ERROR: Describe error: IColumnsInfo::GetColumnInfo failed. : Deferred prepare could not be completed.: Statement(s) could not be prepared.: Incorrect syntax near 'dt'.     proc sql OUTOBS=10; connect to oledb as cnt (init_string ="Provider=SQLOLEDB.1;Integrated Security=yy;Persist Security Info=True;Initial Catalog=price;Data Source=yy" schema=dbo); create table gg as select * from connection to cnt (select                                 cc.x,                                 cct.y,                                  cc.z,                                  cc.n,                                  cct.l,                                  cct.k   FROM yu cct left outer JOIN Check cc on cc.x = cct.y where date >= '30MAR2015:00:00:00'dt and cct.VDATE is null; ); disconnect from oledb; quit;        ... View more

Hi , I have a dataset like in data a an dnow i want the dataset to look like in data b     can anyone pls help   data a       customer phone phonetype   lori 12356 cellphone   lori 45623 homephone   lori 23687 workphone           datab       customer cellphone homephone workphone lori 12356 45623 23687 ... View more