dear all,
please let me know how to export output generated in SAS on demand to excel or word?
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.
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
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
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
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.
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
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.
thanks a lot
the code is working now
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
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.