Hello @Michaela904  Further to what @Kurt_Bremser  has said, I would like to add the following : If you have created a dataset while running your code and it is saved in the work  library it will be lost  once the SAS EG session is closed or if the connection is lost for any reason.(Yes it does happens in real life, when SAS is installed on a  remote Server and SAS EG is on your desktop)..   ... View more

Sorry to hear that. In your situation I would seek help from SAS Tech Support. Suggest the same. ... View more

Hello @maubry  You have two questions. Q1 : How the users can connect to a specific Compute? (permissions defined in the Management Console?)    The users connect through the metadata tier.  Q2 :If a user is connected to Comp2, is it possible for him to access to libraries on Comp1 ? Yes. For a young and up coming administrator, with the questions you have asked in mind, I suggest that you read  the following references. They will server as a good starting point (in addition to the SAS documentation) https://www.lexjansen.com/nesug/nesug11/ma/ma10.pdf  https://www.sas.com/store/books/categories/administration/sas-administration-from-the-ground-up-running-the-sas-9-platform-in-a-metadata-server-environment/prodBK_71228_en.html  ... View more

Hello @sathya66  I suggest you give the full path in the statement  ods csv file="/full_path_here/ODS_CSV.csv"; Please check your DI job settings. Please share your outcome ... View more

Hello @BrahmanandaRao  Your question is "How to count variables for each dataset in a library". While there are many approaches to the solution, I would use the following code which I find simple and pretty straight forward.  I hope you will find it useful. It creates two column output, the first is name of the dataset and the second the number of columns in the table. Here is the code. proc sql; select memname Label "Dataset" ,count(name) as Num_of_cols from dictionary.columns where memtype="DATA" group by memname ; quit; ... View more

Hello @Son_Of_Krypton  I see from your question that you are "appending data to oracle ". Are you appending data to an existing oracle table OR creating a new table and adding data to it? Looks like  you have created a connection to oracle using libname statement and performing the append, please note that in proc append the table attributes will correspond to the attributes of the base table.   ... View more

Hello You are not passing any parameter to stored procedure. I suggest create stored procedure like this and try. CREATE OR REPLACE PROCEDURE del_stored_proc IS BEGIN DELETE FROM test WHERE date >= add_months(trunc(sysdate), -4); END del_stored_proc; ... View more

OK Approaching SAS Tech Support is what I would recommend. ... View more

I hope you are running SAS 9.4. SAS Remote services not running should not be a show stopper. I have servers running SAS 9.4 with remote services stopped.  See the following statement from SAS documents and that will help you understand things better. "SAS Remote Services are not used by SAS 9.4. Although SAS Remote Services are still available to support custom applications, SAS Remote Services are not started by default." https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.5&docsetId=whatsdiff&docsetTarget=p1rxod72hits05n1s67v2m5b96u0.htm&locale=en    ... View more

In a similar scenario I would try a clean restart. And if that does not work, would contact SAS Tech Support at the earliest. If you have had a complete restart, then better to contact SAS Tech Support at the earliest. ... View more

The error is typical of executing invalid block. I suggest trying in SQL developer first. ... View more

Why not enable workspace server logs for some time and see if they through some light? ... View more

Hello @piddy_  Thanks for the reply. I understand the pain. As the saying goes "the wearer knows where the shoe pains" you know the issue better. With this statement   "In the end I only need the last variable where all preceding things have been changed" in mind,   my approach would be to reverse the string and take the required portion. An example of my approach is the following snippet. I have an feeling that creating 40 variables would not be needed. I have used a similar approach but in Korn shell scripting quite some time back. I know this will not end your miseries but may show some direction. For ease of understanding I have created multiple variables str1,str2,str3 and str4.. Similarly I have used multiple puts to trace what is happening. Best of luck in your endeavor. I would appreciate if you can share your success. That will enlighten many of us. data _null_; /* This is the string from which you are going to extract the word*/ str1="EmailImport-VS {{POST}}Advisering pr. 30.12.2013 [Ref.nr.].pdf {{SERVICE}} Postkasse [Autotitel=2018A12A1327] [Ref.nr.=49e392c5d6-df75-4687-ba81-effd3a4a752a.pdf"; /* reverse it*/ str2=reverse(str1); put=; /* Taking "=" as the marker*/ str3=substr(str2,1,find(str2,'=')-1); put str3=; /* Reverse again to get back*/ str4=reverse(str3); put str4=; run; ... View more

I understand your anguish in using the regular expressions. It would help if you can give us an idea of how the original names/tokens are. Be aware that there cannot be a single general  formula or function to address all the issues. ... View more