cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
pparpati11
‎07-21-2023
  • 3 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: PROC Export to sharepoint from SAS EG , base SAS is UNIX

by Calcite | Level 5 in SAS Enterprise Guide
‎02-21-2018 05:18 PM
‎02-21-2018 05:18 PM
I need to make this process automated as a batch job. So E.G. prompting to enter username and password might not work for that purpose. ... View more

PROC Export to sharepoint from SAS EG , base SAS is UNIX

by Calcite | Level 5 in SAS Enterprise Guide
‎02-20-2018 09:29 PM
‎02-20-2018 09:29 PM
Hi,   We have Base SAS on a UNIX server and I am trying to run the code below fro SAS EG. It works fine with a local path on the PC for the outfile where PC files server is Installed. The below is also running fine if I also specify username and password, but I don't want to hard code my credentials in the code. Wanted to ask if there are any workarounds . I need to export to both excel and access from SAS EG.   PROC EXPORT data=sashelp.cars dbms=excelcs outfile="\sharepoint Location\test_cars.xls" replace; sheet = Data; server="xx.xx.xx.xx" ; port=9621; run;   PROC EXPORT DATA=sashelp.cars OUTTABLE="cars1" DBMS=ACCESSCS REPLACE ; DATABASE="\SharePoint location\test_cars.MDB"; SERVER="xx.xx.xx.xx" ; PORT=9621; RUN;   Thanks, Praveena ... View more

Re: Proc Export to UNIX Directory W/ PC Files Interface

by Calcite | Level 5 in SAS Procedures
‎02-20-2018 02:45 PM
‎02-20-2018 02:45 PM
Hi,   I am trying to do something similar. It works fine with a local path on the PC where PC files serer is Installed. We have Base SAS on a UNIX server and I am trying to run the code below fro SAS EG. The below will run fine if I also specify username and password, but I dont want to hard code my credentials in the code. Wanted to ask if there are any workarounds . I need to export to both excel and access.   PROC EXPORT data=sashelp.cars dbms=excelcs outfile="\sharepoint Location\test_cars.xls" replace; sheet = Data; server="10.47.87.96" ; port=9621; run;   PROC EXPORT DATA=sashelp.cars OUTTABLE="cars1" DBMS=ACCESSCS REPLACE ; DATABASE="\SharePoint location\test_cars.MDB"; SERVER="10.47.87.96"; PORT=9621; RUN;   Thanks, Praveena ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎07-21-2023 12:42 PM
Group Hubs for pparpati11
View All
Quick links