Hi guys,
Today i'm trying to export some files to SharePoint.
PROC EXPORT DATA= SCHEDULE
OUTFILE= "https://MySharePoint/Forms/text.txt"
DBMS=TAB REPLACE;
RUN;
The code above, is the only way i've tried to export, But there is an error as follows:
ERROR: Physical file does not exist,
/sas/sas/config/Lev1/SASPApp/https://MySharePoint/Forms/text.txt
I need a way to export without installing any other SAS or Windows applications, because here it is quite limited access.
Just to specify:
filename request temp;
filename response "Path\output.xml";
data _null_;
file request;
input;
put _infile_;
datalines4;
<soapenv:Envelope xmlns:rep="http://www.sas.com/xml/schema/sas-svcs/reportrepository-9.2"
xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
<soapenv:Header>
<Action
xmlns="http://schemas.xmlsoap.org/ws/2004/08/addressing">
http://www.sas.com/xml/schema/sas-svcs/reportrepository-9.2/DirectoryServiceInterface/isDirectory</Action>
</soapenv:Header>
<soapenv:Body>
<rep:isDirectoryDirectoryServiceInterfaceRequest>
<rep:dirPathUrl>SBIP:path-name</rep:dirPathUrl>
</rep:isDirectoryDirectoryServiceInterfaceRequest>
</soapenv:Body>
</soapenv:Envelope>
;;;;
run;
proc soap in=request out=response service="ReportRepositoryService"
soapaction="http://machine-name:port-number/SASWIPSoapServices/services/ReportRepositoryService"
envfile="http://file-server-name.abc.xyz.com/sas-environment.xml"
environment="test";
wssusername="user-name"
wsspassword="password";
run;
Most important, is this possible ?
If so, How ?
Thanks before anything
The only way that I have found to move files from Unix host (which from your error message it looks like you are using) to SharePoint is to use curl. http://stackoverflow.com/questions/28341625/performing-multiple-requests-using-curl-with-different-o...
But if you cannot call system commands then you might not be able to do that.
The attempt you posted looks like it is attempting to connect to some SAS service rather than a SharePoint service. Do you have a SAS interface to SharePoint that you can use to write to SharePoint?
SAS Web Parts ? No i do not have any other web based applications.
This SAS Note may help point you in the right direction:
http://support.sas.com/kb/42/054.html
Your Sharepoint admin should be able to provide a UNC path.
FILENAME Statement, WebDAV Access Method and/or http://www.sas.com/content/dam/SAS/en_ca/User%20Group%20Presentations/Winnipeg-User-Group/HarryDroog...
The error message:
ERROR: Physical file does not exist,
/sas/sas/config/Lev1/SASPApp/https://MySharePoint/Forms/text.txt
is caused by a wrong current directory. It is failure of SAS having it let that way. http://support.sas.com/kb/50/345.html Ask your admin to correct that. And when he is not that obstinate aks for the risks of xcmd. When not: " bla bla ", have that granted for you.
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.
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.