To All: I am trying to determine how to take the lock off the SAS data set when another person is using it.  Actually I would like to know how to allow more than one person to be able to upload data to a SAS dataset at the same time? For example when person A is working within the dataset, if person B tries to open and work within it, the data set is locked and person B cannot input his data.  Is there a way to get rid of the lock? Thanks, Reggie ... View more

To All: We are creating Stored Processes in a Mid Tier Test library and once all requirements are met we want to move to the Mid Tier Production Library.  We are encountering that we cannot modify the physical location of the stored processes and need to either re-code the stored processes or leave it within the Test Library. We have tried modifying the physical location via console management with no luck.  Is there anyway in which to modify the physical location of stored processes?  Example Test library - called Reggie Functiona library - called action I will create a stored process within the test library of reggie.  However once I am certain that the information is working within reggie, I would like to move the stored process to Action because action is the main library where the process will run.  Yet when I point the path to action, and delete the test stored process out of reggie, the entire stored process is deleted. Thanks Reggie ... View more

To All: When a Web Report Studio prompt is run, it is automatically filled with the first options we chose.  Therefore I have to hit the reset to default button everytime I want to run a new report.  Is there a way to have this refresh on its own and not have to hit the reset to default each time I want to run a new report? For example: I have attached a view of the SAS Web Report to this note.  If I ran a report to see how many sandals the store has in stock, when I get my report I would then log out.  However the nex day when I log back into the system the value "sandals" is still in the selected value window.  How can I make sure once I log out and back onto the system that the selected value window is empty? Please see attached example Thanks Reggie ... View more

To All: I am having a hard time connecting to SAS to Oracle. I am currently on Windows 2003 32bit.  Every time  I try and connect I get the following message below. I am using SAS 9.2. Error:  The SAS/ACCESS Interface to Oracle cannot be loaded. Error:  Image SASORA found but not loadable. Error:  Error in the LIBNAME statement. Can someone please assist me with this issue? Thanks ... View more