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

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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
  • 3414 views
  • 0 likes
  • 2 in conversation