I am having a stored process.it needs to route my report to
both hthml and Xls.By default SP routes to html.I used the
PRINTTO to route the html to Xls.BUt it createsthe file not
but no content was written to file(0KB)?how can i do it?

Answer Posted / aravind9882

try this...
ods html file='C:\Documents and
Settings\Administrator\Desktop\a.xls';
proc print data=emp noobs;
run;
ods html close;

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Will it bother you if the guy at the next desk times the frequency and duration of your bathroom or coffee breaks on the grounds that ?you are getting paid twice as much as he is??

2394


For what purposes have you used sas macros? : sas-macro

804


What are the default statistics that proc means produce?

827


hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana

5225


Explain the purpose of substr functions in sas programming.

840


what is enterprise guide? What is the use of it? : Sas programming

785


Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager

1887


Explain what is SAS informats?

867


What versions of SAS have you used (on which platforms)?

1294


describe about metadata object? : Sas-di

864


What is program data vector (pdv)?

889


What is program data vector (pdv) and what are its functions?

879


For clinical entire study how many tables will create approx?

1757


explain the function of substr in sas? : Sas-administrator

812


why a stop statement is needed for the point= option on a set statement?

848