I want send proc tabulate result to excel.
Is it possible?
Why not? Take a look at http://support.sas.com/rnd/base/ods/odsmarkup/excelxp_demo.html
for one possibility
Sure. ODS is helpful.
You should post it into ODS Forum, there is a SAS employee Cynthia@sas is a specialist about it.
Ksharp
Hey Milena,
I tried my best but I failed. :smileyconfused:
I would export the dataset by PROC EXPORT and build the table in EXCEL..
The simple export is:
DATA TEST;
SET SASHELP:CLASS;
RUN;
PROC EXPORT DATA= TEST;
OUTFILE ="YOUR PATH:::\TEST.XLS"
DBMS = EXCEL REPLACE;
SHEET = "EXPORT SAS TO EXCEL";
RUN;
Greetz Niels
If you are wanting the tabular appearance one approach is to use the EXCELXP tagset.
ods tagsets.excelxp file='output path\your file name.xml' ;
<your proc tabulate code here>
ods tagsets.excelxp;
Then use EXCEL to open the resulting XML file.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.