I tried to use the _data_ keyword in a let statement.   %let random_ds = _data_; But this does not work. I haven't though tried to use it with sysfunc. I will give it a try ... View more

I want the SAS code to be a part of a SAS macro and combine in with fork and wait functionality provided in SAS Data Integration Studio. If I have the same process running for lets say many records simultaneously, I don't one process to read or write to datasets of another process. This is the main reason I want to have autogenerated names just like the drag and drop functionality in DI (when you actually drag an drop an extract component, the name of the table is a random string). ... View more

This is a very interesting article. Is there any way that we could do the same in SAS Visual Analytics 7.5? I need to retrieve the list of reports and the data sources that are used by the reports.   ... View more

I don't know where the log files are stored for actions as such. Do you have @rudfaden any idea? ... View more

@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