BookmarkSubscribeRSS Feed
packaging_guy
Calcite | Level 5

I am trying to find out if there is a way to upload data from a google doc (csv) into a sas data set.  This would allow the document to be edited by multiple users at the same time.  We currently have issues with our current text or csv files only allowing one user access at a time. 

We currently have a sas program that outputs an exception file for items that are missing vital data to the program.  We output an exception file (csv) to a shared folder. We then edit the csv file with the missing data.   When we re-run the program, it picks up the csv file and adds the missing data to the program.  The exception report is re-generated for any items that were not previously fixed or any new items that have been picked up and that are missing the necessary data.  The new exception file overwrites the previous file in the shared folder.

I would like the ability to have the exception report in a google doc that would allow multiple users to edit the document concurrently.  I would like the SAS program to pick up the edited data from a google doc to create a data set.  Once the program using this data set runs, I would like to output a new exceptions file to the google doc location so we can start the process over again.

Does SAS have this capability?

Thanks for your help.

1 REPLY 1

sas-innovate-2024.png

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.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 3457 views
  • 0 likes
  • 2 in conversation