I want to mimic the functionality that DI gives when you drag and drop an extract components which has an output table with a generated name. I can see that your code provides this kind of functionality.  By using the below statements you have mentioned, might be the case and I will definitely give it a try. data; run; %let ds = &syslast; ... View more

I want to mimic the functionality that DI gives when you drag and drop an extract components which has an output table with a generated name. I can see that your code provides this kind of functionality.  By using the below statements you have mentioned, might be the case and I will definitely give it a try. data ; run; %let ds = &syslast; ... View more

Exactly. Only the ones that I have defined (or the macro code defined).   ... View more

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