Recently in the SAS Community Library: SAS' @BethEbersole reveals 4 steps to stop money laundering, solve law-enforcement cases, find missing children and more with SAS Visual Investigator.
hello everyone, %macro p2(datos,clase1,clase2);
proc tabulate data=&datos format=commax10.; class ANYO;
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;??
... View more
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
... View more
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.
... View more
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?
... View more
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!
... View more