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?



I am having a stored process.it needs to route my report to both hthml and Xls.By default SP route..

Answer / 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

More SAS Interview Questions

How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data?

0 Answers  


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

1 Answers  


explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di

0 Answers  


what are system option ? give few examples ? what are dataset options and dataset statements ? if there is a keep option and keep statement ? which one is executed first ? Difference between a WHERE statement and IF statement ? what is the advantage of using WHERE statement option on the dataset ?

1 Answers   Satyam,


What are symbol tables?Differemce between Local N Global Symbol tables.....

2 Answers   TCS,






how to remove duplicates using proc sql?

0 Answers  


What procedure you used to calculate p-value?

2 Answers   Accenture, Quintiles,


hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?

1 Answers   Pfizer,


Why do we use QUIT commmand for proc datasets and proc sql ???

3 Answers  


how to change the execute of macro

0 Answers   Mind Tree,


Which statement does not perform automatic conversions in comparisons?

0 Answers  


How many data types are there in SAS?

0 Answers  


Categories