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.
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.