Hi,
I would like to create a daily report (.XLS) using ODS Tagsets EXCELXP and have this report automatically uploaded to a cloud based storage area (Box).
Has anyone got some experience with this?
Thanks!
Well, you need to copy the resulting .xml file to a given location. What tool do you use to access your cloud based storage outside of SAS?
(And what is the operating system of your SAS server?)
I use a Window 7 Enterprise 64 bit operating system and we have Box for Microsoft Office to upload/access the files.
https://en.wikipedia.org/wiki/Comparison_of_file_hosting_services
states that FTP access to Box is possible for Business/Enterprise customers. So you need to confirm that first (use any FTP client to check the connection).
Then define a FILENAME FTP with the proper options, and use the fileref in the FILE= option of the ODS TAGSETS statement.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.