Hi!
CSVALL was actually available in SAS 8.2. But ExcelXP is definitely SAS 9. I am surprised that the ODS XML syntax worked for you in SAS 8.01 -- but perhaps it was there in a rudimentary form. Honestly, I don't remember.
An older, somewhat different method of creating CSV and HTML files did exist. You may not have heard about them. They were called the "HTML Formatting Tools Macros" -- they included ways to get tabulate output into HTML (which you can open with Excel) or SAS datasets into CSV form (which you can also open with Excel).
We used to teach these macros in SAS 6, so they may be out there in your installation. The 2 macros of interest to you might be:
%tab2htm (sends proc tabulate to a minimal HTML file, which opens in Excel 97 and higher) and
%ds2csv (sends a SAS dataset to CSV, which opens in Excel)
They are documented on the SAS/IntrNet page, (but they have a batch mode, too.) The link where you can find some examples and explanations for the options is:
http://support.sas.com/rnd/web/intrnet/format/index.html
But, here's a quick example you can try. (When you go to use the page dimension, I think you will still have to use box=_page_.) At any rate, it's not a CSV file, if you use %tab2htm, but it is pretty sparse in terms of HTML. So it may be smaller in size that what you're currently creating. After you run these macros you will NOT see anything in the SAS Results Window -- you have to use Windows Explorer or IE or Excel or Notepad to navigate to the files and open them.
cynthia
[pre]
**** the code;
filename outfile 'c:\temp\class.csv';
%ds2csv(csvfref=outfile,data=sashelp.class,
runmode=b);
options nodate nonumber ls=190 ps=100 nocenter;
filename tabfile 'c:\temp\classtab.xls';
%tab2htm(capture=on,
runmode=b);
proc tabulate data=sashelp.shoes;
Title "using Tab2HTM Macro";
var sales;
class region;
table region all,
sales*(min mean max);
run;
%tab2htm(capture=off,
runmode=b,
openmode=replace,
htmlfref=tabfile,
brtitle=Tab2Htm,
center=N);
[/pre]