About Rogerio_Alves

Rogerio_Alves · ‎02-25-2021

To avoid a problem to duplicate data with an APPEND I created an INDEX on DI with some columns. When I run the job it is executed but send this message and JOB is finished with EXIT on FLOW MANAGER. ERROR ON LOG: Add/Update failed for data set <TABLE TARGET> because data value(s) do not comply with integrity constraint. How could I solve that? Thanks!

Rogerio_Alves · ‎02-09-2021

I have an APPEND process that duplicates data if I run it twice. Is there some way to avoid data duplication using APPEND?

Rogerio_Alves · ‎12-29-2020

Tks a lot for your support!

Rogerio_Alves · ‎12-29-2020

Anand, no, I'm using my own user and I'm not the creator of jobs. Tks!

Rogerio_Alves · ‎12-29-2020

I'm using IBM Platform Process Manager version 9.1 to manage job funning on SAS GRID 9.4. On client is unavailable the options Kill, Supend, Rerun could you please help me how to solve it? Tks !

Rogerio_Alves · ‎09-24-2020

Tks a lot to answer!

Rogerio_Alves · ‎09-24-2020

Do you know how many WHERE statement can I use in a PROC SORT? Tks!

Rogerio_Alves · ‎02-12-2020

I got you! Thanks a lot!

Rogerio_Alves · ‎02-12-2020

Hi, I got you! You'r right, I was with a wrong concept about RANGE could be. Thanks a lot to explain. Appreciate.

Rogerio_Alves · ‎02-12-2020

Hi everybody, I'm using the PROC MEANS in order to get the MIN, MAX, RANGE and MEAN of a group of values. The MIN, MAX and MEAN returns well but for RANGE was returned the SUM of MIN and MAX values. This is my code: proc means data=TBL min max mean range maxdec=0 ; class ano local categoria; var valor; run; The result I've got: The SAS Guide information: Tks to help!

Rogerio_Alves · ‎03-07-2018

Thanks to answer, it works for me!

Rogerio_Alves · ‎03-02-2018

Thanks to answer! Will it running inside of VA? Do you have some example? Thanks.

Rogerio_Alves · ‎02-28-2018

Hi, I'm migrating an excel report to SAS Visual Analytics. On the report there is an KPI that is calculated comparing results using the first line as reference: price diff 10 0 20 10 30 20 The challeng is that there are a lot of filters and this first number will change when the filters are used on report. Thanks! Rogério

Rogerio_Alves · ‎02-19-2018

I'm looking for some comparision of SAS VA versions from 7.2 to actual. Thanks, Rogério

Online Status	Offline
Date Last Visited	‎02-17-2022 03:58 PM

DI APPEND -

DI APPEND

Re: Flow Manager client - SAS 9.4 Grid

Re: Flow Manager client - SAS 9.4 Grid

Flow Manager client - SAS 9.4 Grid

Re: PROC SORT AND WHERE

PROC SORT AND WHERE

Re: Proc means range is sum min and max values

Re: Proc means range is sum min and max values

Proc means range is sum min and max values

Desafio – Workshop time Sicredi!

Re: Flow Manager client - SAS 9.4 Grid

Flow Manager client - SAS 9.4 Grid

SAS Visual Analytics Comparison

DI APPEND -

DI APPEND

Re: Flow Manager client - SAS 9.4 Grid

Re: Flow Manager client - SAS 9.4 Grid

Flow Manager client - SAS 9.4 Grid

Re: PROC SORT AND WHERE

PROC SORT AND WHERE

Re: Proc means range is sum min and max values

Re: Proc means range is sum min and max values

Proc means range is sum min and max values

Re: Visual Analytics - Comparing lines on table

Re: Visual Analytics - Comparing lines on table

Visual Analytics - Comparing lines on table

SAS Visual Analytics Comparison

SAS Brazil Community