Home

shiney_martin1

I am running the following code to subset an existing table as part of a data engineering pipeline. I want to reduce outputs to the log from proc cas. proc cas ; table.Partition/ casout={caslib="mycaslib" name="previous_errors" replace=True} table={caslib="mycaslib" name= "&viewName._DQ" where="DQField= error"}; quit; This will then print to the log the following: {caslib=mycaslib,tableName=PREVIOUS_ERRORS,rowsTransferred=0,shuffleWaitTime=0.000010252,minShuffleWaitTime=0,maxShuffleWaitTime=2.1457672E-6,averageShuffleWaitTime=1.4645713E-6} This is very frustrating as this code is part of a macro running close to 100 times, so this message is really unnecessarily clogging up the log. Does anyone know how to turn it off? I already have messageLevel set to "warning", which I have checked using "listsessopts" I am using SAS Viya 3.5.

bhaskarkothavt

Hello, I am getting below error message when i am trying to connect Oracle database from SAS Studio using Viya4 (the code ran fine yesterday without any errors though) Creating an aggregated table which will return 700 -8000 rows and SQL code is as below Could some please help me how to overcome this "Insufficient space". Best Regards, Bhaskar

ppinedo

hello everyone, %macro p2(datos,clase1,clase2); proc tabulate data=&datos format=commax10.; class &clase1 &clase2/ missing preloadfmt order=data mlf; tables &clase1*&clase2 all="Total"; %if "&clase1"=A %then .............; %if "&clase1"=B %then .............; %if "&clase1"=C %then .............; %if "&clase1"=D %then .............; %if "&clase1"=E %then .............; ..............; %if "&clase1"=X %then .............; %if "&clase1"=Y %then .............; %if "&clase1"=Z %then .............; %if "&clase1"="SEXO" %then format &clase1 SEXO.; run; %mend; %p1(people,SEXO,EDAD); I get this message: "WARNING: Variable RUN not found in data set WORK.people" What does it mean?? Why I get it and how I can solve it without %do; ... %end;??

GeorgevdW

Hi I am currently building a dashboard on viya for learners as part of my masters program and for one part I need to display values on a bar chart but I also would like to add a line on each bar that is the cut-off value but I can't find a object that allows me to do it in such a way. Is there any way I can do this ? This is how my Bar chart looks I have values for each year for the size but I still need to display the cut-off value on this bar chart in a line or something for each year can this be done in VA?

TomHsiung

Hello, everyone I managed to estimate the parameters for a Weibull accelerated failure time model from the PROC LIFEREG procedure. I have the point and interval estimations for predictor coefficients. In addition, I have the estimations for the Weibull shape parameter. After I get these estimations, I would like to simulate the cumulative incidence curve/survival curve. I know I should use the point estimation of these coefficients and the shape parameter in the prediction model. But I am not sure whether to use the interval estimation of coefficients, or the shape parameter. You answer is much appreciated!