It has been recently observed that after migrating user from EG 4.3 to 5.1 the work libraries are getting lost.If a user opens a session and started writing to work library there is no problem till the time the user is accessing the work location too frequent. After few hours if he has tried to access the datasets in work library the datasets are not there any more. The backend investiation suggests that the Connection from SAS EG 5.1 is being reset and a new connection is created. The new connection is referring to a new location and the old location is existing with the datasets. But the seession has already lost the old work directory. The possibility of Network Disrruption has already been tested and thre is no problem observed. Please let me know if there is any known issue. Is there any way we can prevent it from happening? ... View more

SASA,I am getting file lock error when I am using the SPDE library. I have searched a lot but solutions given seem to be not working. Can anybody tell me how do I get rid of this error without deleting the mdf file from the physical library? It will be highly appreciated if you comeback with a solution of any kind. ... View more

I have mistakenly executed one data step that updated one of the permanent tables. Can anybody tell me is there any way to restore the data sets with the earlier version?? I will highly appreciate if anybody comesback with a quick and fast solution.. ... View more

I am passing value from a stored process to another stored process using query string. https://URL-of-stred-process?age=14 Now I would like to use this query string age as a macro variable. So that I can run some filters on it. Pleas Help... ... View more

I am having problem using javascript in stored process. In a web page there is a textbox and a button. Whatever I write in the textbox needs to be captured in a SAS macro variable(or variable) after the button click so that I can update a dataset with the contents of the textbox. Navigating to another page is not permitted. Please help. ... View more

I wnt to remove this two borders(left and right) and make the text as left alligned. Can anybody help me how to do this? ... View more

If I use a proc sql with sum functions along with group by( sum function variable not included in group by),is it possible that the observation count changes in every different run. If it is then why? It happend to one of my work. I know the solution to avoid it. I need sort before. But my question is why it is happening? ... View more

I am using a simple proc sql with a data set which contains millions of records. The code is like PROC SQL NOPRINT; CREATE TABLE TABLE1 SELECT * FROM DM.TABLE WHERE COMPANY="xxx" ; Now I ran the code again with PROC SQL NOPRINT; CREATE TABLE TABLE2 SELECT * FROM DM.TABLE WHERE COMPANY="xxx" ; Now I am doing a proc compare without any by variable. PROC COMPARE BASE=TABLE1 COMPARE=TABLE2; Now proc compare compares the two data sets observation by observation or with a ID variable. ID variable is absent. What I think proc compare shold give exact matching. But though the rowcount is same it is giving some difference. When applied by variable on the primary key of the source data set,it is giving the exact match. Why it is happening can anybody help? ... View more