Recently in the SAS Community Library: Your often contains the information you need, but not sequenced in the order required for processing. @SASJedi shows you how to properly sequence data so you can compare the data in one table to the data in another, conduct merges or joins and more.
Empowers the Academic Community! Part 2 of 3.
Welcome back to our journey through the latest upgrades in SAS Visual Analytics in SAS Viya for Learners 4 . In part 1, we delved into the general enhancements. Now, let's zoom in on one of the most significant enhancements: the process of creating data items including calculated expressions and dynamic features. So, buckle up and get ready to revolutionize your data with SAS Visual Analytics.
Custom Categories: The custom categories interface has been enhanced with a new look and feel. The interface is more compact and easier to use. For interval groups, a visual shows how large each interval is compared to all other intervals.
You can also automatically generate groups from measures. You can specify the number of groups to generate. Equally sized ranges will be created, and you can edit those ranges.
Outlier detection: The new Insights window identifies possible outlier values in the data for the objects in your report. It provides a new outlier analysis pop-up window that shows how outlier values affect your data.
Measures in the Data pane are automatically checked for possible outliers. An icon appears beside measures that might have outlier values.
Expression Builder: The visual expression builder has been overhauled upgraded to use a new editor called, Monaco.
Selecting a function will automatically display the interface on the right side of the dialog, and previews will be generated automatically at the bottom of the dialog. The expression builder also includes typeahead, tab autocomplete, and hint features, dynamically giving people help along the way as they type. The new interface includes a help menu. This menu is new to SAS® Visual Analytics and describes exactly what each argument does with in the function.
A new Abbreviate numeric values option enables you to specify the scale and digits of precision.
Additional enhancements:
The min() and max() operators are now supported for dates and datetimes.
The term “quick calculation” replaces “derived item” for data items that you can create by using the new calculation pop-up menu selection on the Data pane.
Hovering over a calculated data item will reveal its expression without needing to edit the calculation.
Axes for time-series objects, line charts and more support logarithmic scales.
Excited to check out all the new features in SAS Visual Analytics in SAS Viya for Learners? Educators and students can sign up for free access to SAS Viya for Learners using an academic email address.
Stay tuned for my upcoming post unveiling the thrilling updates to Objects! Did you miss my first post on General Enhancements? If so, you can find it here:https://communities.sas.com/t5/SAS-Communities-Library/Unveiling-the-Latest-Upgrades-SAS-Visual-Analytics-Empowers-the/ta-p/932246
... View more
Hi,
I've been using Proc Glimmix to predict the effect of several predictor variables on my outcome where the distribution is negative binomial. for the purpose of model comparision when I run the following code I receive the AIC tests:
proc glimmix data=modelupdated; class metcat(ref="2") age_new(ref="1") sexnum (ref="2") race(ref="2"); model Rate_12= age_new sexnum race metcat/ dist=nb link=log s; run;
However when I add the random effect of counties, I do not receive the AIC in fit stati table in the output.
proc glimmix data=modelupdated1; class metcat(ref="2") age_new(ref="1") sexnum(ref="2") race(ref="2"); model Rate_12 = age_new sexnum race ave_uninsured metcat / dist=nb link=log s; random intercept /type=un subject=fips_all_digit_num ; run;
any thoughts on this and how I can get AIC becuse I need to compare the two different models vs eacg other.
Thank you,
... View more
Hello, I have a series of 10 Likert scale (1-3) variables that need to be recategorized using the same criteria. The variables are as follows: a1_c_q1 - a1_c_q5, where 'a1' is administrator 1, 'c' is cognitive test, and 'q' represents the questionnaire number (1 though 5). a2_c_q1 - a2_c_q5, where 'a2' is administrator 2, 'c ' is cognitive test, and 'q' represents the questionnaire number (1 through 5). For each of the 10 variables, I am looking to create a new recategorized variable where 1=3 and 3=1. Is there a way to use an array or loop in the code so the same lines do not need to be repeated 10 times? DATA new1;
SET new;
a1_c_q1_new=a1_c_q1;
IF a1_c_q1=3 THEN a1_c_q1_new=1;
ELSE IF a1_c_q1=3 THEN a1_c_q1_new=1;
RUN;
... View more
Hi, I have a http procedure in my script which worked without any problem. And recently we have to redirect this procedure to another server which is used for testing. Afer I changed the ip which is not a certified DNS in the url, I got this error message: ERROR: Secure communications error status 807ff019 description "11.1.1.111(the IP of our test environemnt): SSL Error: Invalid subject name in partner's certificate. Subject name must match machine name." ERROR: SSL Error: Invalid subject name in partner's certificate. Subject name must match machine name. ERROR: Call to tcpSockContinueSSL failed. I did try to modify the system option SSLSNIHOSTNAME by filling a valid url into it, but it doesn't work becuase our server is Windows+SAS9.4M8 not Linux. Can any SAS expert figure out how to resolve this issue? Many thanks! KR., Ye
... View more
I created a yes/no/missing format. It works when I apply it to a variable that I constructed in my syntax, but not to variables that were already present in the data file. Could the existing variables already have a format that is being retained? And if so, how do I override it?
The syntax below will produce a freq table for Any_cancer with 1:Yes, 2: No, Inapplicable/Missing, in that order. This is a constructed variable, and the output is being put into a table. So having it in the correct order is important.
The table for HLT_OCSTROKE shows 2, 1:Yes, Inapplicable/Missing, in that order. This is an existing variable in the data, and there are about 10 more that are doing the same thing.
I would add sample data, but I can't see how it would fail to run properly with new data. The only thing that makes sense is that the formatting is retained from the original data.
LIBNAME temp "C:\SAStemp";
proc format library=temp;
value yesfmt_r
1='1:Yes'
2='2:No'
.='Inapplicable/Missing'
.R='Inapplicable/Missing'
.D='Inapplicable/Missing'
.N='Inapplicable/Missing';
RUN;
DATA temp.want; SET temp.have;
FORMAT
Any_cancer YESFMT_r.
HLT_OCSTROKE YESFMT_r.;
RUN;
PROC FREQ data=temp.want; TABLES Any_cancer HLT_OCSTROKE / missing; RUN;
... View more