topic Re: ODS internet set as output destination in ODS and Base Reporting https://communities.sas.com/t5/ODS-and-Base-Reporting/ODS-internet-set-as-output-destination/m-p/209396#M13878 <HTML><HEAD></HEAD><BODY><P>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?</P><P>(And what is the operating system of your SAS server?)</P></BODY></HTML> Fri, 28 Aug 2015 10:23:28 GMT Kurt_Bremser 2015-08-28T10:23:28Z ODS internet set as output destination https://communities.sas.com/t5/ODS-and-Base-Reporting/ODS-internet-set-as-output-destination/m-p/209395#M13877 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I would like to create a daily report (.XLS) using&nbsp; ODS Tagsets EXCELXP and have this report automatically uploaded to a cloud based storage area (Box).</P><P></P><P>Has anyone got some experience with this?</P><P></P><P>Thanks!</P></BODY></HTML> Fri, 28 Aug 2015 09:45:34 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/ODS-internet-set-as-output-destination/m-p/209395#M13877 Rik 2015-08-28T09:45:34Z Re: ODS internet set as output destination https://communities.sas.com/t5/ODS-and-Base-Reporting/ODS-internet-set-as-output-destination/m-p/209396#M13878 <HTML><HEAD></HEAD><BODY><P>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?</P><P>(And what is the operating system of your SAS server?)</P></BODY></HTML> Fri, 28 Aug 2015 10:23:28 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/ODS-internet-set-as-output-destination/m-p/209396#M13878 Kurt_Bremser 2015-08-28T10:23:28Z Re: ODS internet set as output destination https://communities.sas.com/t5/ODS-and-Base-Reporting/ODS-internet-set-as-output-destination/m-p/209397#M13879 <HTML><HEAD></HEAD><BODY><P>I use a Window 7 Enterprise 64 bit operating system and we have Box for Microsoft Office to upload/access the files.</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"> </SPAN></P></BODY></HTML> Fri, 28 Aug 2015 10:57:28 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/ODS-internet-set-as-output-destination/m-p/209397#M13879 Rik 2015-08-28T10:57:28Z Re: ODS internet set as output destination https://communities.sas.com/t5/ODS-and-Base-Reporting/ODS-internet-set-as-output-destination/m-p/209398#M13880 <HTML><HEAD></HEAD><BODY><P><A href="https://en.wikipedia.org/wiki/Comparison_of_file_hosting_services" title="https://en.wikipedia.org/wiki/Comparison_of_file_hosting_services">https://en.wikipedia.org/wiki/Comparison_of_file_hosting_services</A></P><P>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).</P><P>Then define a FILENAME FTP with the proper options, and use the fileref in the FILE= option of the ODS TAGSETS statement.</P></BODY></HTML> Fri, 28 Aug 2015 11:15:45 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/ODS-internet-set-as-output-destination/m-p/209398#M13880 Kurt_Bremser 2015-08-28T11:15:45Z