topic Uploading and writing to google docs in SAS Programming https://communities.sas.com/t5/SAS-Programming/Uploading-and-writing-to-google-docs/m-p/98976#M290754 <HTML><HEAD></HEAD><BODY><P>I am trying to find out if there is a way to upload data from a google doc (csv) into a sas data set.&nbsp; This would allow the document to be edited by multiple users at the same time.&nbsp; We currently have issues with our current text or csv files only allowing one user access at a time.&nbsp; </P><P></P><P>We currently have a sas program that outputs an exception file for items that are missing vital data to the program.&nbsp; We output an exception file (csv) to a shared folder. We then edit the csv file with the missing data.&nbsp;&nbsp; When we re-run the program, it picks up the csv file and adds the missing data to the program.&nbsp; 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.&nbsp; The new exception file overwrites the previous file in the shared folder.</P><P></P><P>I would like the ability to have the exception report in a google doc that would allow multiple users to edit the document concurrently.&nbsp; I would like the SAS program to pick up the edited data from a google doc to create a data set.&nbsp; 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.</P><P></P><P>Does SAS have this capability?</P><P></P><P>Thanks for your help.</P></BODY></HTML> Thu, 13 Dec 2012 14:52:47 GMT packaging_guy 2012-12-13T14:52:47Z Uploading and writing to google docs https://communities.sas.com/t5/SAS-Programming/Uploading-and-writing-to-google-docs/m-p/98976#M290754 <HTML><HEAD></HEAD><BODY><P>I am trying to find out if there is a way to upload data from a google doc (csv) into a sas data set.&nbsp; This would allow the document to be edited by multiple users at the same time.&nbsp; We currently have issues with our current text or csv files only allowing one user access at a time.&nbsp; </P><P></P><P>We currently have a sas program that outputs an exception file for items that are missing vital data to the program.&nbsp; We output an exception file (csv) to a shared folder. We then edit the csv file with the missing data.&nbsp;&nbsp; When we re-run the program, it picks up the csv file and adds the missing data to the program.&nbsp; 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.&nbsp; The new exception file overwrites the previous file in the shared folder.</P><P></P><P>I would like the ability to have the exception report in a google doc that would allow multiple users to edit the document concurrently.&nbsp; I would like the SAS program to pick up the edited data from a google doc to create a data set.&nbsp; 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.</P><P></P><P>Does SAS have this capability?</P><P></P><P>Thanks for your help.</P></BODY></HTML> Thu, 13 Dec 2012 14:52:47 GMT https://communities.sas.com/t5/SAS-Programming/Uploading-and-writing-to-google-docs/m-p/98976#M290754 packaging_guy 2012-12-13T14:52:47Z Re: Uploading and writing to google docs https://communities.sas.com/t5/SAS-Programming/Uploading-and-writing-to-google-docs/m-p/98977#M290755 <HTML><HEAD></HEAD><BODY><P>Take a look at: <A href="http://support.sas.com/resources/papers/proceedings12/240-2012.pdf" title="http://support.sas.com/resources/papers/proceedings12/240-2012.pdf">http://support.sas.com/resources/papers/proceedings12/240-2012.pdf</A></P></BODY></HTML> Thu, 13 Dec 2012 15:10:12 GMT https://communities.sas.com/t5/SAS-Programming/Uploading-and-writing-to-google-docs/m-p/98977#M290755 art297 2012-12-13T15:10:12Z