About LAP

LAP · ‎07-09-2018

I''ve been a SAS Admin for over 10 years and feel that we balance SAS development/analytic and admin roles pretty well. Recently, however, there has been talk in our company (large fortune 500), about outsourcing all software management responsibilities (not just SAS). I naturally feel that this in general is not a good idea but I'd like to hear the opinion of others. Has this been tried anywhere else and what your experiences have been. What do you see as the advantages and disadvantages. Just for reference: We have 3 separate licenses. 1) Grid Clustered Metadata , 4 compute nodes 2) Single Server (all tiers) 3) Multiple Server (1 for each tier - Compute, Meta and Mid)

LAP · ‎01-03-2018

I think maybe I wasn't clear with my question. We run SAS in a Grid environment.... no desktop SAS installations and users are not allowed direct access onto the linux server. Users use Studio or EG to access. However, we initially tested Sim Studio (before we purchased Grid and migrated to Linux) . At that time we didn't use the JMP add-in but we were able to configure JMP to use SIM Studio that was installed on our Windows server (again... there was no client installation except for JMP). Now that sim studio is on linux. Can we do the same thing.

LAP · ‎10-18-2017

We deployed on a Linux grid and would like to take advantage of Sim Studio 14.3. However, we don't allow users to log into the production server, so running Sim Studio from a linux desktop environment will not work for us. However, we do have a few licenses of JMP. Can we run Sim Studio 14.3 (on our grid) from a Windows JMP installation

LAP · ‎06-21-2016

Sai, Did you work with Tech support on this? If so could you provide us with a track. They seem to be sending us down a rabbit hole on this and if we could point to a similiar solution it might help. Thx

LAP · ‎06-21-2016

Thanks for the solution. However, we are using Linux servers and I'm not sure if there is anything equivalent in Linux. We can check with our root admins.

LAP · ‎06-20-2016

We have the following implementation: Metadata Cluster (3 servers), MidTier (2) and Compute TIer (Grid - 4 nodes). We have installed and Configured SAS Environment Manager following the "Installing and Configuring SAS Environment Manager in a SAS Grid Environment". All seems to be functioning correctly. The agents are running on each node and environment manager sees all the agents. Now, we want to initialize the service architecture Framework follwing the "Initializing SAS Envrionemnt Manager Service Architecture Framework for SAS 9.4M3" instructions. However, step2 : Validate Framework fails Here's the info: Service Architecture Validation - Mon Jun 20 11:54:16 CDT 2016 Starting level 1 validation... Level 1 validation completed with 0 error(s) Starting extended level 2 validation (this could take a while)... Level 2 validation completed with 1 error(s) in 34.104 sec Service Architecture validation completed with 1 error(s) Errors: 1) The SAS Environment Manager Agent is not running. However, the (modified) grid agents are running (not the default one). We feel that the failure is do to the "standard scripts" not working in our grid environemnt (won't be the first time we've encountered this). So the question I have to any grid administrator, is what changes / modifications/ hoops did you have to do to get service architecture framework working in a Grid environment? Thx for your help

LAP · ‎11-14-2013

By any chance are you looking at the "data" that shows in EG rather than output from a procedure. If my memory serves me, the column names are the variable names. However if you mouse over each of the column headings, or check the properties of the variables (proc contents) you will see that the labels are indeed there. So in the simple example; Data chk; input lst_name; LABEL lst_name = "LAST NAME"; FORMAT lst_name $50.; run; The data chk will still show lst_name as the variable name. However, if you do a proc report, the label should show up.

LAP · ‎06-22-2011

I have several jobs that are scheduled to run each night. I capture errors based on the &syserr macro variable and %syserrortext (new in SAS 9.2) at relevents spots in my code and assigning to a new macro variable. At the end of my job, I can check the value of each of these error variables and send a status report (via email to myself or project leads). For instance (simple example) %let step1err = -1; * Real errors are 0 - ....; -1 indicated that step not run; %let step1msg = ; step goes here... %let STEP1err = &SYSERR; %LET step= &SYSERRORTEXT; At the end of the job I collect all my steperrs and create a report that shows how each step completed. This is very generalized.. you will have to adapt method to your own circumstances. Hope this gives you a startting point

LAP · ‎06-22-2011

To expand on some of the things already said... It is important to understand how your data is stored and what attributes are associated with a certain variable. This will drive the solution. One way to check your data - there are many - that I use frequently is the following proc sql; describe table xxx.xxx; This will return each column name, type (num or Char), format, informats and label. If the date is already numeric then reformatting with a new date format will do the trick. If the date is stored as a character variable ie Char(n) then you will have to use some sort of conversion to convert to a numeric variable that represents a date. As for the other thread where mydate = Wed May 18 16:58:32 2011 If this is a FORMATTED numeric value, something like datepart something like x = datepart(maydate); format datepart worddate.; should give the correct results

LAP · ‎01-10-2011

If I'm understanding what you want: sum some value across all rows in you table. then I think this will work. data example; set example; if _n_ = 1 then sum=0; *I do not think you need this line but I put in for example; sum + height; increments sum by value of height; run; I'm not sure of what you are thinking about when you say use sum function over height column. The sum function works on columns in a single row ie something like this.... sum = sum(ht1, ht2, ht3). This syntax sums across rows. So when i = linescount, Height will be the sum of height over all lines. You certainly can get more creative with what you increment - as you say some more complex calculation for example : sum + (a + b*(c^2)*d/e); where a-e are all columns. Hope this helps

LAP · ‎01-06-2011

There two way to do this. Using proc transpose proc transpose data=test out=trans; by PROVID Company; var Rate Payment; run; Data final; drop _name_; merge trans (where=(_name_ = "Rate") rename = (col1 = Rate1 col2=Rate2 col3 = Rate3)) trans (where=(_name_ = "Payment") rename = (col1 = Payment1 col2=Payment2 col3 = Payment3)); by provID company; run; Alternately, you could do this in a data step. I usually do this when there are a lot of rename statements. proc sort data=example; data alternate (keep = provID company rate1-rate3 payment1-payment3); array r(*) rate1 - rate3; array p(*) payment1-payment3; do i = 1 to 3; set example; by provID company; r(i) = rate; p(i) = payment; if last.company then return; end; run;

LAP · ‎01-06-2011

Message was edited by: LAP Message was edited by: LAP

LAP · ‎01-06-2011

I'm not sure if I'm missing something here on what you want to do but we use cursors in oracle/sql and I have not seen anything so complicated that a SAS data step cannot accomplish the same thing. The data step inputs a single record, acts upon the objects (vars) of that record and then outpts that record. It then retrieves the next record, (if there is one) and repeats the process. In your explanation: FOR I = 0 to DATASET.LINESCOUNT DATASET(I).Height ...etc END FOR The data step equivelent is data example; set example; height = .......; run; The for/end for is implied in the data step. The specific line can be reference by automatic variable (linescount= _n_; This will iterate through each row of your example table and perform whatever operation you want on height. This is very simplified but you could get pretty complex in what you do with that observation. Of course it would have been helpful if an example of what exactly you do with sql/cursor was provided. What specific operations that you "used to work with, doesn't work in sas".

LAP · ‎01-06-2011

You can also use a colon modifier to select codes that "Begin With". However, I believe that this method is limited to an "IF" statement. see http://support.sas.com/kb/24/851.html (Sample 24851: Using a Colon Modifier to Select Observations with Values Beginning with a Specific Character By Kirk Paul Lafler) for more information.

LAP · ‎12-28-2010

I'm assuming that all you wish to do is subset your original data set based on a range of dates. The problem (error message) here is that your original data set x.loan does not have a variable i on the data set. The syntax for the data set options that you use on the set statement applies specifically to x.loan. The variable i is actually created in the output data set test. Two easy solutions come to mind... You could try changing the where = (period=dhms(i,0,0,0) portion to an if statement in the data step data test; set x.loan(keep= period bron loannr ENR where=(bron NE 'FAF')); do i = &date_from to &date_to; if period = dhms(i,0,0,0); output; end; run; But since you say your original data is very large I would probably recommend using the between-and operator on the where = clause. ie (keep=period bron loannr ENR where=(datepart(Period) between mdy(07,01,2010) and mdy(12,01,2010) and bron ne "FAF"));

Online Status	Offline
Date Last Visited	‎04-10-2024 08:30 PM

Outsourcing SAS Admin Responsibilities????

Re: SAS/OR 14.3 and SAS Simulation 14.3 are here!

Re: SAS/OR 14.3 and SAS Simulation 14.3 are here!

Re: SAS Environment Manager's Service Architecture Framework in a Grid

Re: SAS Environment Manager's Service Architecture Framework in a Grid

SAS Environment Manager's Service Architecture Framework in a Grid

Re: [newbie] Ordering output in the same order as input

Re: How to check logs for errors and send email thru sas code

Re: 01JUN2011:00:00:00 Convert To SAS Date...

Re: loop through rows/observations

Re: protecting the password in proc sql

Re: order by in subquery??

Re: How to select first few records to test the Proc sql;

Outsourcing SAS Admin Responsibilities????

Re: ERROR: Unable to clear or re-assign the library MACROS because it ...

Outsourcing SAS Admin Responsibilities????

Re: SAS/OR 14.3 and SAS Simulation 14.3 are here!

Re: SAS/OR 14.3 and SAS Simulation 14.3 are here!

Re: SAS Environment Manager's Service Architecture Framework in a Grid

Re: SAS Environment Manager's Service Architecture Framework in a Grid

SAS Environment Manager's Service Architecture Framework in a Grid

Re: [newbie] Ordering output in the same order as input

Re: How to check logs for errors and send email thru sas code

Re: 01JUN2011:00:00:00 Convert To SAS Date...

Re: loop through rows/observations

Re: how to transpose this

Re: Determine Source Table For Column

Re: loop through rows/observations

Re: DELETE or SELECT TEXT BEGINNING WITH SAME CHARACTER

Re: Extract data based on date --> should be very simple...!

SAS Inner Circle Panel

SAS Innovate 2025

SAS Analytics Explorers

SAS Global Forum 2018