twocanbazza Tracker

Re: Call symput not working as expected

twocanbazza — Mon, 12 Dec 2016 20:57:24 GMT

I thought (could be wrong) that the & is executed at complile time and &dte1 and &dte2 don't exist at compile time given it is populated during the datastep

The reason it works the second time is that the first data step execution has completed and so the macro vars now exist and can be used when you run again.

so change to

data _null_;
date1=put(intnx('month',today(),-1,'beginning'),yymmdd10.);
call symput('dte1',date1);
call symput ('st_dt',date1);
date2=put(intnx('month',today(),-1,'e'), yymmdd10.);
call symput('dte2',date2);
call symput ('en_dt', date2);

run;
%put &dte1.;
%put &dte2.;
%put &st_dt.;
%put &en_dt.;

Barry

Re: LSF schedudling: developers vs admins

twocanbazza — Tue, 22 Nov 2016 00:26:39 GMT

Hi @Quentin,

Ideally yes a second environment with SAS and LSF to test the deployment and scheduling (obviously the schedule wouldn't run in the same frequency but it enables the developer to get things right before handing over for release).

However in the real world, like your site and a site we manage this sometimes doesn't fit; At a site we manage the developers who have rights to schedule etc are now finding issues like what happens when they go on leave for a period of time, who monitors the job and re-triggers if they fail - given the jobs are scheduled using their ID becomes painful - you need to find a happy medium and have a good relationship with your SAS administrators 😉 .

You could have a group setup in LSF with a lower priority that you could test your schedules and then pass to your admins to release in the production queue etc.

Barry

Re: LSF schedudling: developers vs admins

twocanbazza — Mon, 21 Nov 2016 02:02:45 GMT

There are particular options in LSF that enable you to allow non-owners to trigger jobs... although the are still called 'Administrators'...

Role	Where defined	Summary of permissions
Normal user	Any operating system user on LSF hosts. All users are automatically assigned this role.	Normal users can view flow definitions, flows, calendars, and jobs that are owned by all users but can control only work items that they own.
Process Manager administrator	Users that are specified in JS_ADMINS in the file js.conf after the first one that is listed.	Process Manager administrators have full control over all Process Manager items of all users. Process Manager administrators can view, control, and modify flow definitions, flows, calendars, and jobs on behalf of other users.
Process Manager Control administrator	Users that are specified in JS_CONTROL_ADMINS in the file js.conf.	Process Manager Control administrators can view flow definitions, flows, calendars, and jobs that are owned by all users and can control flows and jobs on behalf of other users.
Process Manager Group administrator	Users that are specified as GROUP_ADMIN in LSF user groups in thelsb.users file when JS_ENABLE_GROUP_ADMIN=true in js.conf.	Group administrators can view flow definitions, flows, and calendars owned by all users. Group administrators can control flows and jobs on behalf of users who are members of the same LSF user group.

As an admin I for one like the Idea to only allow admin to schedule (Should have been tested in UAT prior to being released and scheduled in production so no need to test) however this has other issues like who monitors job and resolves issues if it failes etc

Re: AUTHDOMAIN for users

twocanbazza — Wed, 07 Sep 2016 23:43:45 GMT

If you have the users defined in the Metadata against AUTHDOMAINS The users could manually update their passwords in the metadata with the SAS Personal Login Manager.

Re: Future release SAS VA

twocanbazza — Fri, 08 Jul 2016 03:29:47 GMT

I am Wondering if VA is at the same point of it's life cycle as WRS was when VA was released, given the shift in focus to SAS Viya

Re: Can't launch SAS Deployment Manager/Uninstall SAS 9.3 - Same problem!

twocanbazza — Sun, 08 Nov 2015 20:32:24 GMT

SAS Should be able to provide you a 9.3 license

Re: SAS 9.3 won't uninstall properly - same problem!

twocanbazza — Sun, 08 Nov 2015 20:30:20 GMT

SAS should be able to provide you a licence for 9.3

Re: SAS enterprise guide slow to open dataset on SAS server in AWS cloud

twocanbazza — Tue, 03 Nov 2015 21:14:58 GMT

AWS Hosts Worldwide

AWS has about 9 Regions where they host, each Region is split by at least two availability zones. If your setup is basic with no failover etc your SAS server was stood-up in one of those availability zones. That Region/Zone was selected by whoever set up the ec2 server and may not be your closest. You could Live on the west coast of the states and have your server in europe, not ideal. For myself I am in Auckland New Zealand and our closest AWS Region is Sydney Australia etc

Re: SAS enterprise guide slow to open dataset on SAS server in AWS cloud

twocanbazza — Tue, 03 Nov 2015 20:58:51 GMT

Hi.

Really hard to say how to fix with out knowing you network topography and how AWS is setup for your site

What region is you EC2 running, and is it the closest region to your location. Is you organisiation using AWS direct connect between your Site and AWS or are you accessing over the internet connection?

Several options, Look into direct connect (this will increase you bandwidth and thru put), another option is to have EG installed on a server in AWS and you RDP onto that.

Also Just a warning, AWS charges for data out, so everytime you view a dataset like you have decribed it is costing you organisation money, having EG in AWS also will not incur that data download cost.

Another issue could be that your PC that you have EG installed on is underpowered and is struggling?

Re: create a table name with a variable name

twocanbazza — Mon, 19 Oct 2015 21:15:46 GMT

Does this work when not using the a macro var in the name, the error indicates and issue with Library permissions not the table name...

Also what is the value of the macrovar when you get the issue?

Barry

Re: AD Account is locked at SAS Server

twocanbazza — Wed, 30 Sep 2015 23:01:11 GMT

Have seen this before also but can't recall the exact problem...

I gather the user can't log onto the server directly

Given you have rebooted the server etc, a rouge session doesn't seem to be the issue...

do you have credentials stored in the metadata? or hardcoded in SAS code? are there any SAS jobs running on the server when the account is locked? Is it after they do something in SAS or is it even when they don't do anything?

Although it is the SAS server that is seen to be be doing this it may not be SAS that is the issue....

Barry

Re: Multiple Depots, which one was used?

twocanbazza — Tue, 25 Aug 2015 21:21:52 GMT

Thanks Sunshine, will have a look as this points me in the right direction

Should have said this is SAS 9.2, and don't know who did the install...

Barry

Multiple Depots, which one was used?

twocanbazza — Tue, 25 Aug 2015 20:16:20 GMT

Hi.

Hopefully a simple question, and just making sure I haven't missed anything

If you have multiple depots on site, is there a way of checking an installation for what depot was used (ie PC has EG installed and need to know what depot was used to do the install)

Cheers

Barry

Re: Unable to connect SAS EG 7.1 on virtual PC to metadata server on AIX box

twocanbazza — Wed, 03 Jun 2015 03:25:15 GMT

Have you got a SAS profile defined or a SAS metadata server running?

Re: WRS cannot open the data which from oracle database

twocanbazza — Sun, 02 Mar 2014 21:13:48 GMT

Then you are not testing like for like, try accessing through the information map from EG, as your information map may be using another server etc which may not have the same SAS products installed

Re: WRS cannot open the data which from oracle database

twocanbazza — Thu, 27 Feb 2014 20:59:45 GMT

When using EG, can you access the data using the information map or are you accessing the data/library directly...

Re: How to output a list of all libraries in SAS?

twocanbazza — Thu, 20 Feb 2014 23:38:52 GMT

Hi Stumbled on this and thought it may help. I believe it provides the answer you need (although the document has been mentioned here, here is the specific link I think)

SAS(R) 9.3 Language Interfaces to Metadata

Barry

Re: SAS Deployment Manager 9.3. starts with windows

twocanbazza — Sun, 16 Feb 2014 21:17:37 GMT

Best bet for this is to contact Tech Support.

At a guess it is because the install hasn't appeared to have completed?

Barry

Re: Cannot Access Data created in E.G. 5.1 in Office Analytics

twocanbazza — Fri, 14 Feb 2014 00:35:07 GMT

Hi Just trying to understand what you have done, and I need to clarify your definitions

when you say folder(s) under a library your admin created - are you talking about metadata folders or physical folders? As I am not sure you can create folders under a library in metadata...

How did you place the data in the folders?

Funny questions I know

Barry

Re: Order of programs in SAS EG

twocanbazza — Mon, 20 Jan 2014 20:31:42 GMT

As (Reeza) said - is to Link the programs, in the order you want.