topic Re: How to export output from SAS On demand to Excel or word ? in New SAS User

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

srikanthyadav44 — Thu, 01 Jul 2021 06:25:48 GMT

dear all,

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

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

SAS_Cares — Thu, 01 Jul 2021 13:32:54 GMT

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

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

srikanthyadav44 — Fri, 09 Jul 2021 04:42:12 GMT

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

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

Kurt_Bremser — Fri, 09 Jul 2021 06:50:43 GMT

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.

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

srikanthyadav44 — Fri, 09 Jul 2021 13:30:26 GMT

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

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

Kurt_Bremser — Fri, 09 Jul 2021 16:11:48 GMT

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.

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

srikanthyadav44 — Fri, 09 Jul 2021 17:54:06 GMT

thanks a lot

the code is working now