cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Lobstermaster
‎09-01-2015
  • 3 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Dataset is locked by user preventing it from updating

by Calcite | Level 5 in SAS Data Management
‎05-19-2011 02:44 AM
‎05-19-2011 02:44 AM
Hi Patrick and RMP, thanks for your advice. Will look into this. Regards, Lobbie ... View more

Dataset is locked by user preventing it from updating

by Calcite | Level 5 in SAS Data Management
‎04-28-2011 09:01 AM
‎04-28-2011 09:01 AM
Hi, I use DI Studio to build jobs and run data loads. From time to time, I get error messages about the data set is locked by another process and preventing my jobs to update the data set. My questions are, 1. Is there a way e.g. in the table loader transformation to have exclusive rights or lock over the data set so that I can load the data like in Teradata, there is a row access locking statement to implement? 2. If I create/load a table as a view in DI using a source data set and if some one is using the view, will it prevent me from updating the source data set? Thanks, Lobbie ... View more

Re: view the table columns in alphabetical order

by Calcite | Level 5 in SAS Enterprise Guide
‎04-28-2011 08:55 AM
‎04-28-2011 08:55 AM
I don't think it is possible because the variables order is registered in the metadata if you are opening a data set from SASApp and which is loaded by your ETL developers. However you can use the Filter and Sort task node to re-arrange the variable order by sorting the variable names. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:11 AM
Quick links