Hello,
I am working with a company that will export data from SharePoint to SAS datasets. Is there anyway to assign variable labels in SharePoint so that when the data get transferred to SAS the labels are already there?
Thanks in advance.
Clarify what exactly is meant by"...assign variable labels in SharePoint..." - as in what type of "published document" is of interest to interpret and how do you intend to access/retrieve the data objects from SAS?
Scott Barry
SBBWorks,Inc.
The data that is being collected in questionnaires will be processed in SharePoint. I have associated SAS names, SAS labels and formats (where applicable) to each of the variables that are being collected. I have asked to receive the data from the questionnaires in SAS datasets. My question is whether the SharePoint data can be assigned the labels (and formats if possible) upfront in SharePoint so that when I receive the data in SAS datasets it will have the SAS names and SAS labels associated already.
(I have no experience in SharePoint and I believe that the SharePoint people have none or very little experience with SAS - which is what is making this an even harder challenge).
Thanks in advance for any help.
Not likely that you associated any "SAS" specific reference to the SharePoint data. Most likely is that you are faced with exporting "survey" type SharePoint data as an Excel-type data-format, possibly even resorting to column/row CSV-type input handling which SAS can deal with easily -- also, most likely needing to use SAS input-handling process via an FTP-like connection.
To consider prior SAS-related discussion, recommend an Internet search, such as argument-string as: sharepoint data site:sas.com
Scott Barry
SBBWorks, Inc.
Thanks Scott,
You are probably correct. have searched around and have not found anything very useful. The SharePoint data is probably being transferred to Excel and then to SAS. Is there anyway to set up a transfer from Excel to SAS such that the labels and formats can be associated during the transfer?
Thanks Scott,
You are probably correct. have searched around and have not found anything very useful. The SharePoint data is probably being transferred to Excel and then to SAS. Is there anyway to set up a transfer from Excel to SAS such that the labels and formats can be associated during the transfer?
There is no "transfer from Excel to SAS" -- you are faced with doing your input-handling from SAS to connect to the SharePoint server/machine "source" location to read/process the data and generate a suitable SAS-representation, likely with a FILENAME / DATA step processing.
Obviously you will need to gain access-authorization to the SharePoint-deployed system/server, working with your SharePoint admin staff, while also making available the specific location where the "source" SharePoint data file/folder(directory) is located. Recommend to start with confirming that FTP direct-access (outside of SAS) works as expected, then progress to compose your SAS-based input-processing SAS script(s) as needed to process the data.
Make good use of the available SharePoint related resources / papers / posts on the SAS support website.
Scott Barry
SBBWorks, Inc.
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.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.