DartRodrigo Tracker

Re: How do I fill the variables with data from 2 datasets more a list loop

DartRodrigo — Wed, 01 Jun 2022 09:20:04 GMT

Maybe you should try a join then use Proc Transpose.

ODS LAYOUT

DartRodrigo — Thu, 08 Mar 2018 15:44:51 GMT

Hi experts,

First, Happy woman's day.

Well, I'm using SAS 9.4 in my environment, and we are having some troubles while using some ODS options.

WARNING: The absolute region was too small to accommodate the output supplied for the PDF destination. Output will be suppressed

This is because we are using region (ods region height=3in width=4in x=0.2in y=7.3in;) like this. This warning says that my proc step is larger or higher than the size specified.

What i would like to know is, are there some way to make this to be auto responsive ? Or if i do not setup width and height, it will fill the PDF more effectively ?

Thanks in advance

Re: Code to Show all Tables and Paths of Libnames

DartRodrigo — Tue, 30 Jan 2018 18:41:15 GMT

Mean the version of proc setinit;

Current version: 9.04.01M4P110916

But yes, SAS 9.4

Re: Code to Show all Tables and Paths of Libnames

DartRodrigo — Tue, 30 Jan 2018 18:30:18 GMT

Even with shell script ?

Maybe use some shell commands to track this.

Problem is:

We are migrating SAS 9.02 to 9.04 per waves.

Wave1 - 100 PGMS migrated

Wave2 - 200 PGMS migrated

...

We will put Wave1 to run on SAS 9.04 and need to track all datasets and paths. (Done)

I only need to track anyone who can validate these datasets, maybe one person per filesystem. (Not done)

Thanks

Re: Code to Show all Tables and Paths of Libnames

DartRodrigo — Tue, 30 Jan 2018 17:59:30 GMT

Ok, but i need to know owner and user that access them ?

Code to Show all Tables and Paths of Libnames

DartRodrigo — Tue, 30 Jan 2018 17:23:49 GMT

Hi experts;

Is there some way to create a table containning All libnames, paths, sizes, owners and tables ?

If possible, try to link this with the programs that they were created.

Thanks is Advance

Re: Shell command to show all Groups and users that access or reads a folder or a file

DartRodrigo — Thu, 18 Jan 2018 17:56:35 GMT

I need to show groups per folder/directory.

For example:

staff | /prod/crm

controlm | /prod/bi

Thanks

Shell command to show all Groups and users that access or reads a folder or a file

DartRodrigo — Thu, 18 Jan 2018 16:53:47 GMT

Hi experts,

I'm using unix environment.

Is there a shell command to list all groups or users that have access to a specific location or file ?

ls -l does not work for me, because i need all users that can read from that directory.

Thanks in advance

Permission drwsrwsrwt

DartRodrigo — Tue, 16 Jan 2018 14:30:54 GMT

Hi experts.

There are some sas files that have this permission drwsrwsrwt.

What means the "s" in this permission: drwsrwsrwt ?

Thanks in advance

Re: Find all programs that use a certain libname

DartRodrigo — Fri, 08 Dec 2017 12:41:39 GMT

I'm using batch shell (Unix).

Find all programs that use a certain libname

DartRodrigo — Fri, 08 Dec 2017 11:47:07 GMT

Hi experts.

Do you guys have any idea, on how to find all programs that use a certain libname ?

This should look for it in all folders and paths.

To be more specific, maybe use shell commands to do this, but my idea is to put libname's names in a macro

and do this multiple times for every libname in our server.

Maybe create a list with libname and programs beside.

Do you guys have any idea how to do this ?

Thanks in Advance

Redirect Index.html of SAS Visual Analytics

DartRodrigo — Wed, 17 May 2017 18:59:45 GMT

Hi guys,

Is there any way to change the index.html to my .html ?

I mean, create a main page with all reports while the users entering the Login Page.

Today(After Login Page):

Needed(After Login Page Something Like this):

Please need help.

Thanks in Advance

TKGrid Process

DartRodrigo — Tue, 14 Mar 2017 17:33:22 GMT

Hi everyone.

There is a few days that we are having troubles with the LASR Servers of SAS Visual Analytics.

The problem is:

Lasr Servers Stopped:

LASR Analytic Server - MyServer

Public LASR Analytic Server - MyServer

LASR Server DBM

Causes:

We could not find them yet. But there are somethings we've found:

There are some TKGrid Processes Stopped during days in all nodes into the VA Server
These processes take more than 100gb
LASR Server DBM is in 74% reached
We've made the Stop/Start, but the scripts did not killed these processes
We run some table to load from the Guide directly to LASR server (Without the HDFS process

I'd like to know what are the possible causes when the LASR Servers Stops.

And why these TKGrids processes are still running during days, even when we restart the sas.servers ?

Thanks in Advance

Re: Set Main report for every user

DartRodrigo — Wed, 08 Mar 2017 13:48:18 GMT

I've done a main report => when any user open SAS Visual Analytics the main page is this report.

Set Main report for every user

DartRodrigo — Wed, 08 Mar 2017 12:08:03 GMT

Hi everyone.

There is a long time i've beeing trying to setup a main report for every user in SAS Visual Analytics.

But i don't have much time left so, that's why i'm here. Could you help me, how to set a main page or report for every user in SAS Visual Analytics ? I look for an option in SAS Management Console, but could not find.

Thanks in Advance

Re: Error in SAS VA

DartRodrigo — Tue, 14 Feb 2017 17:59:45 GMT

Hi guys.

Sorry, forgot to answer this.

We still having troubles with this.

It is the cause of earlier version of table, cause we've updated the table in the metadata and in data builder.

Att

Ram Exceeds in SAS VA Environment

DartRodrigo — Thu, 01 Dec 2016 17:54:24 GMT

Hi guys,

I'm having troubles with some agent of SAS Visual Analytics Environment, it is called TKGrid:

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
12825 lasradm 20 0 37.9g 24g 15g S 0.0 38.2 42:04.56 /opt/sas/TKGrid_3.2/TKGrid/bin/tkmpinodelib SRVPRDSAS10.sky.local 43086 lasr 16308

We've applied the hotfix, but the issue remains.

Here we have 4 servers:

srvprdsas10 - Main Node

srvprdsas11 - Slave

srvprdsas12 - Slave

srvprdsas13 - Slave

This agent 'TKGrid', makes the distribution of processing and environment, someone in SAS told me.

Before we apply the hotfix we were having issues in srvprdsas12, with memory usage.

After the hotfix, we are having issues in srvprdsas13, this seems to me the distribution it is working well around the environment.

Someone please can help me.

Thanks in Advance

Re: Sub Query with Data step

DartRodrigo — Fri, 30 Sep 2016 14:44:28 GMT

I solved this by creating two separated data sets:

DATA SMS_30; SET TEST_30D_V3 (WHERE=(CHANNEL_CD EQ '_MP') DROP=IND_QTD_EMAIL);RUN;
DATA EMAIL_30;SET TEST_30D_V3 (WHERE=(CHANNEL_CD EQ '_EM') DROP=IND_QTD_SMS);RUN;

PROC SORT DATA=TEST_30D_V3;
BY X_ACCT_KEY;
RUN;

PROC SORT DATA=SMS_30;
BY X_ACCT_KEY;
RUN;

PROC SORT DATA=EMAIL_30;
BY X_ACCT_KEY;
RUN;

DATA TESTE_EV_30D(DROP=CHANNEL_CD);
MERGE SMS_30 (IN=A DROP=MOMENTO)
EMAIL_30 (IN=B DROP=MOMENTO)
TEST_30D_V3 (IN=C KEEP=X_ACCT_KEY MOMENTO);
BY X_ACCT_KEY;
RUN;

Thanks in Advance

Re: Sub Query with Data step

DartRodrigo — Wed, 28 Sep 2016 13:46:16 GMT

I want to transform this:

Key | SMS | Email

6456545 | 2 |

6456545 | | 2

Into this:

Key | SMS | Email

6456545 | 2 | 2

With this proc sql i can do this, but it takes a long time to run.

I'd like to test with datastep.

Thanks

Sub Query with Data step

DartRodrigo — Wed, 28 Sep 2016 13:25:46 GMT

Hi mates,

How can i transform this proc sql in data step, to check witch one is faster ?

PROC SQL;
	CREATE TABLE MMM2 AS
	SELECT DISTINCT A.X_ACCT_KEY,	(	SELECT B.IND_QTD_SMS
										FROM MMM B
										WHERE B.X_ACCT_KEY = A.X_ACCT_KEY AND
											  B.IND_QTD_SMS NOT IN ('0', '')
									) AS IND_SMS,
									(	SELECT B.IND_QTD_EMAIL
										FROM MMM B
										WHERE B.X_ACCT_KEY = A.X_ACCT_KEY AND
											  B.IND_QTD_EMAIL NOT IN ('0', '')
									) AS IND_EMAIL	
	FROM MMM A;
QUIT;

Thanks in Advance