https://communities.sas.com/t5/SAS-Enterprise-Guide/Dataset-with-Multiple-Users-Appending-Missing-Data/m-p/728539#M38388 <P>SAS datasets are not designed to be updated at the same time by different users. The user who gets a lock on the dataset first will be able to append, but others trying to append at the same time will fail with log errors. You could try experimenting with the FILELOCKWAIT LIBNAME option, but you would have to ensure that ALL users apply the option when needing to append the dataset.</P> Tue, 23 Mar 2021 19:51:27 GMT SASKiwi 2021-03-23T19:51:27Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Dataset-with-Multiple-Users-Appending-Missing-Data/m-p/728534#M38386 <P>We have a SAS dataset that multiple SAS users append to on a regular basis.&nbsp; For some reason, it is missing data quite frequently and I need to do a file restore back to the most recent version.&nbsp; Has anyone had this happen with a file that is frequently appended to?&nbsp; It is the only file I am seeing issues with so I am thinking it has something to do with multiple users appending.</P> Tue, 23 Mar 2021 19:41:59 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Dataset-with-Multiple-Users-Appending-Missing-Data/m-p/728534#M38386 cbrotz 2021-03-23T19:41:59Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Dataset-with-Multiple-Users-Appending-Missing-Data/m-p/728538#M38387 <P>A SAS dataset is not designed to be used in a shared configuration like this. It is a simple, physical file on a disk. Reading is probably fine but writing is bad. You are probably seeing file locks happening.</P> <P>&nbsp;</P> <P>Find a storage mechanism that handles concurrent access such as a DBMSs (ex. SQL Server).</P> Tue, 23 Mar 2021 19:48:58 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Dataset-with-Multiple-Users-Appending-Missing-Data/m-p/728538#M38387 AlanC 2021-03-23T19:48:58Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Dataset-with-Multiple-Users-Appending-Missing-Data/m-p/728539#M38388 <P>SAS datasets are not designed to be updated at the same time by different users. The user who gets a lock on the dataset first will be able to append, but others trying to append at the same time will fail with log errors. You could try experimenting with the FILELOCKWAIT LIBNAME option, but you would have to ensure that ALL users apply the option when needing to append the dataset.</P> Tue, 23 Mar 2021 19:51:27 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Dataset-with-Multiple-Users-Appending-Missing-Data/m-p/728539#M38388 SASKiwi 2021-03-23T19:51:27Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Dataset-with-Multiple-Users-Appending-Missing-Data/m-p/728575#M38393 <P>What if we had each user append to their own SAS file and ran an overnight job that did the final append to the main table?&nbsp;</P> Tue, 23 Mar 2021 21:27:44 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Dataset-with-Multiple-Users-Appending-Missing-Data/m-p/728575#M38393 cbrotz 2021-03-23T21:27:44Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Dataset-with-Multiple-Users-Appending-Missing-Data/m-p/728580#M38394 That should be fine. It is very simple to use a DB as well. You need SAS/Access to ODBC/OleDB/etc. but a db is optimal here. Tue, 23 Mar 2021 21:52:09 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Dataset-with-Multiple-Users-Appending-Missing-Data/m-p/728580#M38394 AlanC 2021-03-23T21:52:09Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Dataset-with-Multiple-Users-Appending-Missing-Data/m-p/728581#M38395 <P>That sounds like a good solution as long as users don't need to see other users appends during the same day.</P> Tue, 23 Mar 2021 21:53:07 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Dataset-with-Multiple-Users-Appending-Missing-Data/m-p/728581#M38395 SASKiwi 2021-03-23T21:53:07Z