About AndrewHowell

AndrewHowell · ‎05-16-2017

Simple answer - the recommended training for this certification is the DI Fast Track course, although training is certainly not mandatory. Certification is a test of knowledge, not of training - how you acquire the knowledge (training, experience, self-study, etc) is up to you. The DI User Guide is the primary manual, however there are also some tasks in Management Console, too. The DI Certification page on the SAS Support website https://www.sas.com/en_us/certification/credentials/data-management/data-integration-developer.html contains what you need to know. Exam details Exam content guide Training recommendations Sample questions Best of luck!

AndrewHowell · ‎05-15-2017

Sunny, I think a better way to ask will be for you to clarify what responsibilities will you be doing, including any/all of SAS installation, SAS configuration, SAS administratrion, SAS user support, etc, and for who - the company you work for, a customer, etc. Andrew.

AndrewHowell · ‎05-14-2017

Sunny. Best place to start - in fact, it's my primary SAS link: https://support.sas.com/en/sas-administrators.html From here you will have links to everything you should require. Plus keep asking questions in the Administration and Deployment community. Question: Are you looking to install, administer, both?

AndrewHowell · ‎05-05-2017

I was hoping to just find the right combination of options where I could just reference the table/columns as a "Name Constant"$. Oh well.. Thanks for the responses..

AndrewHowell · ‎05-05-2017

Background: SAS 9.4 M3 (Windows). SAS/Access to ODBC (connecting to SQL-Server database) I have SAS Platform Admin and ODBC Admin permissions on the Windows server. I can define the ODBC settings to connect the server to the SQL Server databases I can define the Server & Connections in the Server Manager plug-in of Management Console I can define the libraries in the Data Library Manager plug-in of Management Console Problems: Tables with tablename lengths exceeding 32 characters do not appear when registering tables. Other tables (which DO define in metadata) but have multiple (similarly names) long column names won't open in Enterprise Guide. If a table has one column with a name length exceeding 32 characters, it can open ok in EG. For example: ThisIsMyReallyReallyLongColumnName However, if a table has multiple columns whose first 32 characters are identical, the table won't open in EG. For example ThisIsMyReallyReallyLongColumnNameOne ThisIsMyReallyReallyLongColumnNameOne "ThisIsMyReallyReallyLongColumnNa" is the first 32 characters in both names If I were to open this table in EG, I get an error: Variable ThisIsMyReallyReallyLongColumnN0 is not on file LibName.TableName I've played with so many options (VALIDVARNAME, etc) when defining the libraries, and when registering the tables in metadata, when opening EG, that I'm now starting to go in circles. So, any assistance appreciated..

AndrewHowell · ‎04-27-2017

[This sounds more like a Tech Support question than a Communities discussion, BTW.] Some questions to help pinpoint the issue: Do you have all mid-tier apps (including VA) installed in the one WebApp Server SASServer1_1? (If so, curious wny?) Can you start other WebApps (Stored Process Web Application, SAS Studio, etc)? Can you at least access the Web Server home page? Compare your list of "UP" servers/services against those listed in the $SASCONFIG/Lev1/Documents folder. (This will also show you the location of the log files you'll need to examine.)

AndrewHowell · ‎04-26-2017

Ok, to just to be clear what you are trying to achieve: You have a macro variable P containing a date-formatted value (e.g, 01JAN2017) You have another macro variable D, which may contain a number, a missing (period) or be null. If D is a number, it represents a number of months. If D contains a number, you want to adjust the date value of P by the number of months in D. So how to check what's in D.. I used the ANYDIGIT() function.. The only fiddly bit was having nested %SYSFUNC() macro functions in the final calculation.. %macro MyAdjust(P_Old,D); %local P_New; %if %sysfunc(anydigit(%str(&d))) %then %let P_New = %sysfunc(intnx(month,%sysfunc(today()),&D.-1,BEGINNING),date9.); %put P_Old:&P_Old P_New:&P_New; %mend; %MyAdjust(01JAN2017,1); %MyAdjust(01JAN2017,0); %MyAdjust(01JAN2017,12); %MyAdjust(01JAN2017,.); %MyAdjust(01JAN2017,); P_Old:01JAN2017 P_New:01APR2017 P_Old:01JAN2017 P_New:01MAR2017 P_Old:01JAN2017 P_New:01MAR2018 P_Old:01JAN2017 P_New: P_Old:01JAN2017 P_New: It just won't work for negative values of D because the negative sign counts as non-digit.

AndrewHowell · ‎04-26-2017

Just looking at the code (not able to run it at the moment), on the surface it looks like you just need to change: %let &P = ... to %let P= ...

AndrewHowell · ‎04-21-2017

Firstly, to locate your log files, the best place to look is in the $SASCONFIG/Lev1/Documents folder of each server, which contains files which were dynamically created when your platform was installed, including a detailed list of what was installed on that server, how to start & stop the services/spawners and (in your case) the location of all the log files. Now what to do with your log files. SAS does not have a log file archiving & purging policy - that's up to you. My suggestion is each month, in each folder zip the previous months' logs (201701.zip, 201702.zip, etc), and delete any logs older than (say) 3 months - if you REALLY need log files older than that, you should be able to retrieve them from your server's filesystem backup. Best of luck.

AndrewHowell · ‎04-20-2017

Tammy, there are other providers of metadata plug-ins (there's a German crew who have a metadata-reporting plug-in), but none I've seen so far are anywhere near as feature-rich & well marketed as Metacoda; the fact that SAS itself uses the Metacoda plug-in at numerous offices worldwide (esp Tech Support) is a testament to the Metacoda team.

AndrewHowell · ‎04-20-2017

Whilst restarting a LASR server is considered a last-resort option, it does highlight the benefit of having more LASR servers - each specifically tasked, such as: Operational tasks & associated LASR libraries Discovery tasks & associated LASR libraries Autoload tasks & associated LASR libraries .. and these can be broken down even more by team, department, etc. Plus the table limit you can set is server-based, not library- or table-based, so that's another way to ensure one server does not overwhelm your VA platform, and (if necessary) lets you restart one LASR server without upsetting users on the other LASR servers. See page 83 of the VA 7.1 Admin Guide or page 100 of the VA 7.3 Admin Guide.

AndrewHowell · ‎03-31-2017

I think I might be in with a decent chance at this year's travel prize.. Melbourne to Sydney to San Fancisco to Orlando - total 10,856 miles. It was supposed to be 25.5 hours from first departure to last arrival, but the Melb-Syd leg was delayed due to bad weather & I missed the connecting international flight, so was held over in Sydney for 24 hours. I'm actually on the SanFran-Orlando flight right now - if it lands on time then that will make 49.5 hours.. (and only a day and a half to lose the jet lag & adjust the body clock..) So if I look a little tired Sunday, you'll understand why..

AndrewHowell · ‎03-28-2017

@ChrisHemedinger - I don't leave til Thursday afternoon, so I might come keep you company at Coder's Corner..

AndrewHowell · ‎03-28-2017

Firstly, whilst this site is great for discussions, I'd always recommend taking this kind of problem to your local SAS Support. But (having managed a helpdesk in a past life), some questions to try to quickly focus on the root cause: Was it previously working? If so, what has changed? SAS binaries SAS config Underlying binaries/config - Java, Java paths, etc? If not, what installation testing was done? Does it work for another user (i.e, is it a personal or pervasive problem)? What is your setup (workstation only, client/server, etc)? Do you have platform admin rights? Do you have O/S admin rights? you etc.. Please tell us as much as you can to help you.. (But also ask Tech Support.. and if you get the answer from them, please post it here.)

AndrewHowell · ‎03-28-2017

Curious to know why you can't use RTM.. Anyway, I think the setting you want is UJOB_LIMIT - the maximum job slots per user in a queue. I think it is found/set in the queue options in $LSFCONFIG/conf/lsbatch/cluster_XYZ/configdir/lsb.queues

Online Status	Offline
Date Last Visited	‎04-30-2023 01:46 PM