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.

mkiran

I am configuring Oracle on new 9.4 M8 and below are the entries I made in sasenv_local after having Oracle configured on Linux. everything looks good as per SAS documentation but still getting the error. Can you please suggest where things are going wrong? Note : I have restarted Connect and Share services after updating sasenv_lcoal. libname mydblib oracle user=uname password=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX ! path=<mypath from tnsnames.ora>; ERROR: Unable to load oracle client (libclntsh.so) ERROR: Error in the LIBNAME statement. sasenv_local entries: ODBCHOME=/sas/sashome/AccessClients/9.4/SQLServer export ODBCHOME ORACLE_HOME=/sas/oracle/product/12.2.0/dbhome_1 export ORACLE_BASE=/sas/oracle export PATH=$ORACLE_HOME/lib:$PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH export LD_LIBRARY_PATH echo $PATH /sas/sashome/SASFoundation/9.4:/sas/oracle/product/12.2.0/dbhome_1/lib:/sas/sashome/SASFoundation/9.4:/sas/oracle/product/12.2.0/dbhome_1/bin:/home/sas/.local/bin:/home/sas/bin:/usr/share/centrifydc/bin:/usr/local/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sas/config/Lev1/Applications/SASGridManagerClientUtility/9.4/ echo $LD_LIBRARY_PATH /sas/sashome/AccessClients/9.4/SQLServer/lib:/sas/oracle/product/12.2.0/dbhome_1/lib

l1umen

My boss just informed me that SAS is not free to use, which blew my mind to be honest. I thought the only reason why people put up with it was because it was easily accessible, but to learn that it’s actually super expensive just makes me wonder why so many people still use it. For me personally, SAS is a huge pain in the ass when it comes to data manipulation. I don’t like not being able to see the result of coding as I go along, like I would in R or even Python. Not to mention, it doesn’t run on Mac systems, and their free university software (that I’ve been using) does not allow you to copy and paste. It also automatically logs you out after 15 mins of nothingness, WITHOUT AUTOSAVING, which is incredibly stressful. I do love running multivariate categorical analyses in SAS though. How about you all? Would love to hear your experiences and opinions.

Ileana_GC

You are Viewing the SAS Certification support page. We contract with a third party, Pearson VUE, for Exam Scheduling, payment and delivery in Exam test centers and online. Please review the common questions below. If you still need support, review the contact information boxes at the bottom of this article.

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!