How to export output from SAS On demand to Excel or word ?

[srikanthyadav44]

dear all,

please let me know how to export output generated in SAS on demand  to excel or word?

[SAS_Cares]

We have tutorials that can walk you through this process! Check out this video here https://www.youtube.com/watch?v=6fZ9a_3YPNU  You can also find additional support resources on our product pages https://support.sas.com/en/software/ondemand-for-academics-support.html

[srikanthyadav44]

i watched your video. but i could not export my SAS output to excel. 

I runt the regression by using the following code 

PROC REG DATA=AEM;
MODEL DV=IV_1 IV_2 IV_3;
by YEAR NIC_two_digit;
output out=AEM_residuals
p=predicted_accruals
r=residual_accruals;
run;

after that

i used the following code to export the output, as suggested by you  

PROC EXPORT
DATA =work.AEM_residuals
outfile='C:\demo\AEM_residuals.xlsx'
DBMS=xlsx REPLACE;
RUN;

i am getting the following error 

RROR: Temporary file for XLSX file can not be created -> /home/u3912674/C:/demo//AEM_residuals.$$1. Make sure the path name is

correct and that you have write permission.

i have the demo folder also in the C drive. 

kindly help in writing the appropriate SAS code for exporting my output.

thanks in advance  

[Kurt_Bremser]

Please study the instructions, it's all in there.

On Demand runs on a UNIX cloud server and does NOT have access to your desktop storage. You need to create the file in your home directory (/home/u3912674, use UNIX syntax for filenames) on the server and then use the download feature of SAS Studio.

[srikanthyadav44]

thanks a lot

please let me know how to create a file in home directory. i am very new to the SAS on demand platform. 

please let me know the step-by step procedure required after getting my regression output in order to export my output in excel.

thanks in advance 

[Kurt_Bremser · Accepted solution]

Use this export code:

proc export
  data=work.AEM_residuals
  outfile='/home/u3912674/AEM_residuals.xlsx'
  dbms=xlsx
  replace
;
run;

You will find the file in the navigation pane of SAS Studio, where you can mark it for download.

[srikanthyadav44]

thanks a lot

the code is working now