Are there plans to incorporate send to AMO features for SAS datasets in SAS Studio?
It is really hard to get my data out for editing in excel.
I know how to export it, but I don't have a need to keep the excel on our server.
Having to export, download from the server, and then open it is incredibly tedious for little adhoc jobs.
I was hoping to switch over to SAS Studio from EG because I am doing so many adhoc and not project oriented tasks.
Without some type of integration, it takes longer.
I currently have SAS Studio 3.81.
Thank you
Talk to your SAS administrator about setting up a MS Windows folder that can be written to from your SAS server as well as being accessible from your PC. That way you can write Excel spreadsheets to this location using SAS functionality like PROC EXPORT and ODS EXCEL and have that same folder open in Windows Explorer where you can simply double-click on it to open these spreadsheets.
Then it doesn't matter if you use SAS Studio, Enterprise Guide or even SAS batch jobs to create the spreadsheets, you can easily access and open them from your PC. This is the way we do it and it is very efficient.
Unfortunately, my code runs on a Linux server and there is not direct connectivity to my local drives, so I have to make 2 copies before I can even use it...On the server and then copy to local. Ver inefficient.
Have you talked to your SAS administrator about this problem? It is technically possible to set up shared folders at least if your SAS servers are on-premises, not necessarily in the cloud. Often organizations simply don't consider it as an option.
At this point, it sounds like SAS EG is where I am going to have to continue with my adhoc work since AMO is already integrated into it.
I don't understand your reply. AMO and EG are completely separate products and there is no requirement to install both. SAS AMO is a standalone product that is installed as an add-on to MS Office on your PC. At least with AMO you can use it to read SAS data into Excel worksheets directly which I guess is what you want. In this scenario you could either use SAS Studio OR SAS EG or even SAS batch jobs to create SAS datasets and then use AMO to read them into Excel. We use this approach a lot.
You can have a report downloaded automatically when it is produced in SAS/Studio.
Example:
%if 0<%sysfunc(fileref(_dataout)) %then %do;
filename _dataout temp;
%end;
ods excel file=_dataout options (sheet_name="CLASS");
proc print data=sashelp.class;
run;
ods excel close;
%let _dataout_name=class.xlsx;
%let _dataout_mime_type=application/vnd.openxmlformats-officedocument.spreadsheetml.sheet ;
@angie16 wrote:
True, but then I have to copy to windows and open and edit. Trying to avoid having multiple versions of the same thing
Huh? To use SAS/Studio you are connecting from a browser running on your PC. If you download a file with that browser it should already be on your machine. If you download an XLSX file and you have Excel installed on your machine just clicking on the downloaded file in the browser should open it in Excel. Are you not running your browser on Windows?
Also I don't see how using Enterprise Guide is going to be any easier than using SAS/Studio. Enterprise Guide has nothing to do with SAS Add-in for Microsoft Office. It shouldn't be any harder to use SAS/Studio and AMO together than it was to use Enterprise Guide and AMO together.
To be fair, if you have EG and AMO, you can right-click the output in EG and send it to Excel:
But the Excel download from Studio does work well from what I've seen.
I doubt if that "Send to Microsoft Excel" actually has anything to do with SAS Access to Microsoft Office. I think you just need to have Excel installed on the same machine as where Enterprise Guide is running.
Aye, it is to do with AMO. I've had a few support calls come in within my organisation where it wasn't working, turned out AMO was not installed or not enabled. They got this message:
Starting Excel made no difference. Installing/enabling the Add-In fixed it.
@Nigel_Pain wrote:
Aye, it is to do with AMO. I've had a few support calls come in within my organisation where it wasn't working, turned out AMO was not installed or not enabled. They got this message:
Starting Excel made no difference. Installing/enabling the Add-In fixed it.
Yikes. That is a bad design decision. You don't need AMO for the similar export to Excel feature in plain old Display Manager.
Thanks for this, I've never seen that method before. Works very well.
Hello @angie16
Your issues seems to getting SAS data to your desktop and edit in excel.
From the posts in this thread I presume you have SAS 9.4 installed on a Linux server and you are using SAS Studio as the client application. The following are some of the methods one can use to get your work done
All the above approaches are proven to work. In case of an issue seek help from seniors or may be the Admins.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.