@joeFurbee I think Proc Tabulate to spice it up a little bit, in terms of data representation! ... View more

Very nice event! A recap of the SAS Explore event was made plus many small bits of general knowledge! Keep up the good work! Thank you SAS! ... View more

Hi!  I am logged as administrator. However the specific library is an ODBC library that connects to an Microsoft SQL Server. When I click on the properties icon, I see that the library has the read only keyword on top of the window. The user is the "SAS Installer" user. Should I search for a user with unlimited rights to revert back the settings?   Best Regards, Vasilios   ... View more

Hello! I faced the same situation in the past and what I did was the following: 1. specified the length of the fields 2. also the format of the fields 3. the character representation of the numeric and then filtered it out   data chk; length miu 8; length sd 8; length theta 8; length n 8; do miu=2 to 3.5 by 0.5; do sd=0.7 to 1.3 by 0.3; do theta=0.8 to 2.8 by 0.2; do n=6 to 30 by 4; output; end; end; end; end; format miu 8.; format sd 18.1; format theta 18.1; format n 8.; run; And then for the filtering part data chk1; set chk; theta_c = input(theta, $20.); run; data chk2; set chk1; where theta_c ="1.6"; run;     ... View more

Hi @ChrisHemedinger    I know that this is a very old post. I did not know the DDE commands until I found this post! Do you have any other alternatives other than DDE? I am using SAS Data Integration Studio 9.4   Best Regards, Vasilios ... View more

  Unfortunately I am operating SAS Visual Analytics 9.4 (I don't have the CAS Engine, only the LASR). I think the problem has to do with how the Stored Process is built.  I will try to generate a stored process (I used the one from the samples) and see how it goes.   ... View more

Hello Mike!   I indeed checked and I have the same configuration as you have pointed out in your screenshot. I also added my user in the authorization part on the stored process with access rights, but nothing seems to work.     ... View more

I mainly use indexes and try to influence SAS on what to pick up in terms of performance. However I am not aware of the utilloc you mentioned. Do you have any material / url to know more details about it?   Thank you! Vasilis ... View more

Thank you for your tip! I will try the datastep view, since I have not used it. I mainly use views due to the fact that are stored in memory and not on disk. What I am trying to achieve is leverage the Proc SQL Views to compute fast data and when the information is aggregated to store them.    It seems that many things happen behind the scenes. I thought that all the information stored in the PDV. Thank you! ... View more

It is a dataset and not a view. I tried to Query the Dictionary.Tables to find out about these types of messages (that include the error). I searched and found out the PROC METALIB, but I do not know if I can list the problematic tables. ... View more

In the work library are stored usually tables that are stored temporarily in a SAS session. The problem is that I cannot find the tables in the WORK library (because they do not exist) and I need to find a way to search these tables in the metadata server (if they exist, so as to delete them).     ... View more