About BobD

BobD · ‎04-18-2012

Thanks for the reply, Paul. I should have given credit for solving my SecurID problem; it was your suggestion to my original question that led to the solution. I'm also eager to hear if this can be done. I keep thinking, with all the hundreds of pages of documentation about things like this, surely there is some way to set this up. I have a track open with SAS Tech Support where (among other things), I've asked the same question. If we come up with an answer, I'll be sure to post a follow-up. The initial suggestion was also to define ACLs, but it looked complicated and possibly difficult to maintain. Your experience trying that route tells me to keep looking. Thanks again, and here's hoping there are some other SAS BI "administrators" following this group and willing to jump in. Bob

BobD · ‎04-17-2012

Hi, To correct an issue with respect to RSA authentication with Enterprise Miner (which uses expiring passwords), I created a workspace server in a new "Application Context" named SASEMApp and set it up to use SAS Token Authentication. That fixed our problem and works just fine as long as the user selects the second workspace server from the drop-down list when the log into EM. Is there any way to configure EM so that the correct workspace server is the only one available? If they forget, the default is the "normal" server (SASApp), which will let them in okay, but any tasks they perform will fail. Users start EM via Java Web Start. Similarly, is there any way to prevent this new workspace server from being displayed as an available server from within Enterprise Guide? In other words, I want all Enterprise Miner sessions to use the SASEMApp workspace server and I want all other clients (like EG) to only use the SASApp workspace server. Is that possible? Thanks! Bob Message was edited by: bob duell BTW - This is SAS 9.3 TS1M1 and Enterprise Miner 7.1

BobD · ‎04-10-2012

Hi, Each time I go to the main SAS Communities support page, my browser (IE8) complains with this error message: I've never seen a message like this. Sometimes I click "Yes", other times I click "No"; it doesn't seem to make any difference. It's not a big deal, just slightly annoying. Might this be caused by some IE setting in my browsers? Thanks, Bob

BobD · ‎04-09-2012

Since your target variable is a DATETIME value, try creating your filter with a DATETIME value as well. Rather than use "current_date", create a variable named "current_time" set to just before midnight: current_time = input(put(current_date,date9.) || ':23:59:59'; Good luck!

BobD · ‎03-09-2012

I don't think so. Try this: proc sql; connect odbc (dsn); create table claims as select * from connection to odbc ( select mbr_id , prov_mpin , prov_id , max(prov_row_eff_dt) as prov_eff_dt from co.table where mbr_id > 0 group by 1,2,3 ) order by mbr_id; disconnect from odbc; quit; I reformatted your query to make it easier to read. I removed the DISTINCT keyword because I don't think it is needed, and I used column references (1,2,3) in the GROUP BY clause, which I'm pretty sure will work. I also deleted a stray semi-colon from your example code (in front of your ORDER BY clause).

BobD · ‎03-08-2012

As previously said, since you are using SQL pass-thru, your macro variable should be defined as a valid date in DB2 syntax. The standard date syntax is YYYY-MM-DD, surrounded by single quotes. If you want today's date, you can use the function CURRENT_DATE instead. In other words, if today is March 8, 2012, either of the following should work for you: %let date = '2012-03-08'; %let date = current_date; Hope this helps.

BobD · ‎03-02-2012

This might get you on the right track: data have; informat date mmddyy10. Dosage 2. Status $4.; input Date Dosage Status; datalines; 1/1/2011 20 Live 1/8/2011 10 Live 1/26/2011 15 Dead run; data calendar; do i=1 to 31; date = mdy(1,i,2011); output; end; keep date; run; data want; merge calendar have(in=a rename=(Dosage=tmp_dosage Status=tmp_status)); by date; retain Dosage Status; if a then do; Dosage = tmp_dosage; Status = tmp_status; end; drop tmp_dosage tmp_status; run; I'm sure there are many different ways to do the same thing but this is what comes to my mind first. Good luck, Bob

BobD · ‎03-02-2012

FYI, the ".gpg" extension usually means it is an encrypted file (using GnuPG, here if interested http://www.gnupg.org/). It's not a "compressed" file per se; although gog normally compresses a file during encryption, you cannout uncompress it yourself. The one without ".gpg" on the end is probably the decrypted copy of the same file. And note that you did not need to rename the file with ".txt". If it's just a plain text file, any editor can open it by that name.

BobD · ‎02-23-2012

Well, "fair amount" seems like an understatement. I created a subset depot for only OLAP Cube Studio and Information Map Studio (which are the only products not in my regular Windows order) and the result is still 5.1 GB. And yes, I selected only Windows (not Windows 64) and only English. I suppose the best solution would be to figure out how to get these two tools into my regular Windows order. I has asked about this before but was told it was not possible (my guess is there is some license restriction). It's not obvious to me why that should be true, since these two products do not work without a BI server (as far as I know), but that's way above my pay grade. Perhaps I can ask for a supplemental order with just those tow products; I'll ask again. For safety sake, I just went ahead and downloaded a complete "Windows" depot from my UNIX order using the Download Manager. That was painfull (taking about eight hours), but I'm sure the network and the antivirus scanner (which I cannot disable) was at fault. This copy is about 10 GB. Running the Deployment Wizard to add these two products showed it was adding about 660 MB. BTW, there is a link-to-nowhere on the SAS support site that references a future release (SAS 9.4): http://support.sas.com/resources/thirdpartysupport/index.html. It will just be my luck that my the time I get 9,.3 up and running, a new version will be out! Anyway, thanks for the response; I'm good to go. Bob

BobD · ‎02-23-2012

Hi again, I finally figure it out; using -subsetclients does in fact work on UNIX. One must select the dialog option "By Product" to get the list of clients. However, it seems that it still included all the "foundation" products in the new depot. That's just a guess, but I ran this and selected only the "clients" I wanted and the resulting new "depot" was 9 GB (and only for Windows and English). The entire UNIX depot is 15 GB. So, I suppose I'm still not doing it correctly. I just want a new depot with only the Windows clients, which I hopefully can FTP to a Windows server to do the installs. Is that possible?

BobD · ‎02-22-2012

Hi Mark, I tried using the -subsetclients option on UNIX but I was not offered a chance to selects any clients. Is this feature available on UNIX? I'm using a freshly downloaded UNIX depot for SAS 9.3 TS1M1 containing my Enterprise BI Server. I want to create a "subset" containing only those Windows clients specific to this release (such as Information Map Studio, OLAP Cube Studio and perhaps others). I have a completely separate Windows order (which contains other software, including EG and EM clients), but for some reason SAS was not able to include those clients in my "normal" Windows order. Thanks, Bob

BobD · ‎02-14-2012

Hi Paul, Thanks for your suggestion. As it turns out, this is a fine solution (at least I hope so). Rather than change the existing workspace server, we are going to create a new "Application Server Context" just for Enterprise Miner users. That "context" will have it's own workspace and stored process servers (configured to different ports) and using SAS Token Authentication as you suggest. That way our Enterprise Guide users can continue to use their own IDs as normal. I have tested this in a "practice" BI environment and it works great. As soon as I get my server upgraded to Solaris 10 this weekend, I will be installing a new BI environment with SAS 9.3 and setting this up. This has been quite the learning experience! Thanks to you and some fine followup support from SAS Tech Support, I think we are finally on track to solving our very frustrating problem. Bob

BobD · ‎01-26-2012

Use the RENAME statement in PROC DATASETS (avoiding recreating the data set): data have; myvar = 0; run; data _null_; set have; put _all_; run; proc datasets lib=work nolist; modify have; rename myvar=MYVAR; run; quit; data _null_; set have; put _all_; run;

BobD · ‎01-26-2012

Does anyone have any real-world experience installing, configuring, or otherwise using RSA SecurID authentication for SAS users on a UNIX platform? I am particularly interested in speaking with anyone using Enterprise Miner. As background, we run a SAS 9.2 M3 Enterprise BI Server environment that includes Enterprise Miner 6.1. Individual users are defined in the system Metadata server and authenticate using "DefaultAuth". Enterprise Miner users launch the client using Java Web Start. Additionally, selected users connect to the server using Enterprise Guide (v 4.3) and others use SAS/CONNECT from full-blown PC clients (Win XP, Vista, and Win 7). When a user attempts to connect to the server and is presented with a "password" dialog box, he must enter the "password" derived from his SecurID token. This "password" changes every 30 seconds. In other words, our users do not have "host account" passwords. Everything works just fine for SAS/CONNECT and Enterprise Guide users. Once a connection is made, it remains in effect for the user to do whatever he wants. However, because of an design I still don't fully understand, Enterprise Miner works differently. Apparently, each "node" of an EM "project" causes a new SAS session to be started on the server (by the Object Spawner) and EM attempts to start the new session using the cached credentials (which have certainly expired). Obviously, this makes Enterprise Miner pretty useless. Does anyone else have a similar environment and if so, would you be willing to help me with a solution? I do have an open track with SAS Tech Support but they share my frustration (apparently I am the only site in the world with this problem ;> ). Thanks in advance, Bob PS - I'm going to post this same message to SAS-L. I hope that doesn’t offend anyone but there are so many different places where SAS users congregate these days.

BobD · ‎01-18-2012

Just a guess, but try adding "THEN DO" to the "IF DEPTH > 0" statement (plue a matching END statement. A subsetting IF statement might not work in this context.

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Re: SAS Access to Vertica

SAS Access to Vertica

How do SAS/Access connections work?

How can I start JBOSS dependant on SAS BI on UNIX?

Couple suggestions

Re: EG 4.3 over VPN "not recommended"?

Re: Issue with sas only reading every other line from my excel file.

Re: Issue with sas only reading every other line from my excel file.

Re: Can I control access to workspace servers by function?

Re: Security Warning message

reading files in a directory - help with space in directory name...

Importing SQL databases

Re: how can i get to_char to work in proc sql without connecting to or...

Can I control access to workspace servers by function?

Re: Can I control access to workspace servers by function?

Can I control access to workspace servers by function?

Security Warning message

Re: Date formats

Re: MAX Help

Re: SQL Date Issues

Re: How to Create a Full Daily Transactional Dataset

Importing SQL databases

Re: Depot Subsetting Utility for SAS 9.3?

Re: Depot Subsetting Utility for SAS 9.3?

Re: Depot Subsetting Utility for SAS 9.3?

Using RSA SecurID with SAS Enterprise Applications

Change case of variable name

Using RSA SecurID with SAS Enterprise Applications

help with INFILE/INPUT problem when reading multiple text files with s...