BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.

dear all,

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

1 ACCEPTED SOLUTION

Accepted Solutions
Kurt_Bremser
Super User

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.

View solution in original post

6 REPLIES 6
SAS_Cares
SAS Employee

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
Quartz | Level 8

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
Super User

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
Quartz | Level 8

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
Super User

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
Quartz | Level 8

thanks a lot

the code is working now 

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 6 replies
  • 6024 views
  • 7 likes
  • 3 in conversation