Thank you for above replies!! i was able to fix one of my problems. But still have following issue.. 1. am running a stored procedure from sas stored procedure web application and i have a multi select ptompt on top of it. 2. i have selected 2 values from the list and ran and was expecting 2 excel sheets to open with results from 2 tables. but am getting only one excel sheet for the first prompt i selected. is it possible to get two excel sheets or two tabs in one excel? am not able to provide log as i cant see it in web browser... 3. right now am using following code. *%let _ODSDEST=TAGSETS.Msoffice2k; data _null_; rc = stpsrv_header('Content-type','application/vnd.ms-excel'); %macro A; %if (&name)= box %then %do; rc = stpsrv_header('Content-type','application/file=box.xls'); %end; %if &name= chair %then %do; rc = stpsrv_header('Content-type','application/file=Chair.xls'); %end; %mend A; %A; am not getting any error, but i can see only output for table box even if i select both in my prompt.. Thanks nitin
... View more