topic Re: Export Results to Excel in New SAS User

Export Results to Excel

RDellaVilla — Sun, 21 Nov 2021 17:06:54 GMT

Hello,

I am running an analysis and getting some Results after I perform a Proc Means:

proc means data = dataset_jumps_pa;
var exc_retadj  spread  size annualized_standev;
title All: Return (paper vol);
run;

What I would like to get is to export my results to Excel.

I have tried the following:

proc export	
	data = work.dataset_jumps_pa	
	dbms = xlsx
	outfile = "/c/myfolder/Results/all.xlsx"
	replace;
run;

which only exports the dataset from which I then perform the PROC MEANS.

I was wondering if there is a way to export the Results of the PROC MEANS directly to excel.

Thanks in advance

Re: Export Results to Excel

ballardw — Wed, 01 Dec 2021 16:02:09 GMT

ODS is the preferred way to get results output to files.

Try: (The FILE= should start with a drive or mount point, otherwise the output (location) is subject to interesting results).

Make sure the spelling in the path matches your system as well.

ods excel file="/c/myfolder/Results/all.xlsx";

proc means data = dataset_jumps_pa;
var exc_retadj  spread  size annualized_standev;
title All: Return (paper vol);
run;

ods excel close;

There are a lot of options that may apply to the output but this should get you started.

Alternatively you could send output from Proc Means output to a data set and export that. However that data set may not appear as you want.

Re: Export Results to Excel

Kurt_Bremser — Sun, 21 Nov 2021 18:08:59 GMT

Use ODS EXCEL to direct the output from MEANS to the spreadsheet.