Upload files to sharepoint from SAS

[Billybob73]

Hi,

I've been experimenting uploading files from SAS EG to our sharepoint site.

This works for SAS datasets using the following code (&doelpad is the sharepoint URL + folder) :

option set=SHAREPOINT_COMP_MODE 1;
filename sometest webdav "&doelpad./cars.csv";
proc export
  data=sashelp.cars
  file=sometest
  dbms=csv
  replace
;
run;

Let's say I want to upload pdf or xlsx files from SAS, how would I proceed ?

Thanks

BB

[Stephanvd]

For  PDF:

use ODS PDF

link: https://documentation.sas.com/?docsetId=odsug&docsetTarget=n0mc4eolqoned0n16oy88mpj0e4g.htm&docsetVe...

For XLSX: 
change filename to a xlsx file 

dbms = XLSX

link: https://blogs.sas.com/content/sasdummy/2012/01/25/export-to-excel-got-easier/