Hi, good Morning.   I found this link see, find anything that works for you.   PROC IMPORT - Microsoft Excel Workbook Files   But it will only represent until Excel 2007, anyway i thing this might help you.   Att ... View more

Hi, The following code works very well in sql and SAS Data step   data test; length char $ 20; input char; cards; 121egghhh hfghhhdjdj 5656566 tt4556hyj ; run; data test2; set test; CourseNum = compress(char, ' ', 'A'); if compress(char, ' ', 'A') then flg = "fail"; else flg = "pass"; run; /*SQL*/ proc sql; create table test2 as select char, compress(char, ' ', 'A') as CourseNum, case when compress(char, ' ', 'A') then "fail" else "pass" end as flg from test; quit; Att ... View more