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

Explain by-group processing?

591


What is the maximum length of the macro variable?

680


what is the use of proc contents and proc print in sas? : Sas-administrator

611


what is sas metadata server? : Sas-di

597


What is the different between functions and PROCs that calculate the same simple descriptive statistics?

1234






State the difference between INFORMAT and FORMAT ?

599


how to change the execute of macro

1684


What are the automatic variables for macro? : sas-macro

679


what is sas business intelligence? : Sas-bi

592


Describe a time when you were really stuck on a problem and how you solved it?

2086


To what type of programms have you used scratch macros?

2148


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

1019


What is maximum storage capability of SAS?

911


what is the function of catx syntax? : Sas-administrator

654


What is factor analysis?

664