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

If you have a dataset that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variables?

0 Answers  


how do i get last 10obs from a dataset when we don't know about the number of obsevations in that dataset?

7 Answers   TCS,


what r the job openings SAS for fresher graduates !

0 Answers   TetraSoft, Wipro,


how many types prompting framework can be broken down to? : Sas-bi

0 Answers  


if a variable contain dates like "2015/01"---"2015/12" (yymm) ,How to add day to those dates,if them month is jan then 31 if the month is feb then 28 so on ...

0 Answers   Accenture,


how will you location sas platform applications available from web browser? : Sas-bi

0 Answers  


What r all the reporting procedures...?

3 Answers  


Dear all, proc means data=dsn noprint completetypes; class trtmntgroup /preloadfmt; output out=tot n=n; format trtmntgroup trtf. ; by vstgrp descending severity; run; This is the code I used for AE table. I got the values without giving the variable ‘trtmntgroup(numeric)’ in var statement. And if I give the var statement for that variable i’m getting the same values.How is that possible? What is the difference between class and var statement? Could any one explain me how does proc means work at the back end. And what is the difference between _freq_ value and N value in proc means. Thanks and regards, Rajesh.

1 Answers  


What are the differences between sum function and using “+” operator?

0 Answers  


How do you generate random samples?

5 Answers  


why only we use SAS? their r many programmin language like SPSS, Oracle... Why SAS?

2 Answers   Accenture,


Explain the special input delimiters used in sas programming.

0 Answers  


Categories