Creating an AI Assistant for SAS Viya in 5 steps (@sassoftware/viya-assistantjs) - Part I
Recent Library Articles
Recently in the SAS Community Library: SAS' @kumardeva debunks the myth that developing AI assistants is too hard. He shows you how to use the @sassoftware/viya-assistantjs library to jump start your development.
Good morning.
I'm hoping some can help because I'm out of ideas.
I'm attempting to use ODS Excel to place the page number and number of pages in the footer at a right justify. I've tried the three different methods in the example below. I've done some searching and found some information but can't seem to get it to work.
I get warning messages such as:
WARNING: Apparent symbolic reference R not resolved. WARNING: Apparent symbolic reference P not resolved. WARNING: Apparent symbolic reference N not resolved.
Can anyone give me a hint as to what I may be doing wrong here?
options(sheet_interval = 'none'
sheet_name = 'Sheet Name'
frozen_headers = '2'
row_repeat = '1-2'
suppress_bylines = 'yes'
autofilter = 'all'
pages_fitwidth = '1'
pages_fitheight = '50'
/* print_footer = '&R &P & of &N'*/
/* print_footer = 'Page &P & of &N'*/
print_footer = "Page &R &P of &N"
/* print_footer = "&;LInstitutional Research and Assessment &R Page &P of &N &Z &F"*/
absolute_column_width = '12, 30, 30, 18, 10, 10, 12, 50');
... View more
Good day everyone, New EG user here. I am working with a legacy program that looks for lab errors. The numeric errors are assigned a number that represents a letter code. Error #14 has been changed at the lab into 14A and 14B, which results in log notes stating "Invalid numeric data, "14A", at line 115 column 78. How can I edit the code to prevent this? ****import parameter files***; %macro newdata (outfile, filename,param,param_g,param_error, param_a); data first; %let _EFIERR_ = 0; /* set the ERROR detection macro variable */ infile &filename delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=1 ; informat year best32. ; informat month best32. ; informat day best32. ; informat labid best32. ; informat ¶m_g $2. ; informat ¶m best32. ; informat ¶m_error best32. ; informat ¶m_a $2. ; *informat labsignoff $3. ; format year best12. ; format month best12. ; format day best12. ; format labid best12. ; format ¶m_g $2. ; format ¶m 7.3 ; format ¶m_error best12. ; format ¶m_a $2. ; *format labsignoff $3. ; input year month day labid ¶m_g $ ¶m ¶m_error ¶m_a $ ;*labsignoff $ ; if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */ run; proc sort; by labid year month day; data &outfile; set first; if ¶m_error = 0 then do; ¶m_A = "";end; if ¶m_error = 23 then do; ¶m_A = "QQ";end; if ¶m_error = 1 then do; ¶m_A = "A"; ¶m = .; end; if ¶m_error = 22 then do; ¶m_A = "JJ";end; if ¶m_error = 18 then do; ¶m_A = "RR";end; if ¶m_error = 6 then do; ¶m_A = "RR";end; if ¶m_error = 9 then do; ¶m_A = "V";¶m = .;end; if ¶m_error = '14A' then do; ¶m_A = "FF";end; if ¶m_error = '14B' then do; ¶m_A = "V"; end; *proc print; %mend; Thanks for considering this puzzle.
... View more
Hi guys,
suppose to have the following dataset:
data DB;
input ID :$20.Admission:date9. Discharge:date9. Diagnosis :$20.;
format Admission date9. Discharge date9.;
cards;
0001 06DEC2014 14DEC2014 VIRUS_A
0001 08NOV2020 11NOV2020 FLU
0004 14MAY2014 02JUN2014 FLU
0004 30JUN2015 15AUG2015 FLU
0004 16FEB2019 18FEB2019 VIRUS_A
0005 10AUG2019 11SEPT2019 FLU
....
;
I have to fit a time-series model to estimate the weekly number of hospitalizations for VIRUS_A. The dataset shown is just an example of the real dataset. I don't know how to set the "weekly" from the admission dates I have (I have also discharge dates). The study starts on 2014 but some patients are hospitalized after the start others at different months of the 2014. Moreover, does the week number start from the 01 January? If yes, what's happens if 01 Jan is in the middle of the week?
Apart the practical SAS programming, I also have not clear the theory behind mapping dates to weeks. It's the first time I deal with this data and questions.
Thank you in advance
... View more
Hi, do you guys ever work with Verhoeff check digit algorithm (https://en.wikipedia.org/wiki/Verhoeff_algorithm) with SAS? I am trying to use sas for verhoeff check digit but havent found any script to do so.
... View more
NEWS YOU CAN USE
In this month's edition of our SAS Viya Release Updates, you'll find out how to change the privacy level of a semantic type in the SAS Information Catalog, run SAS DATA step code directly in SingleStore, and check out the eight new steps added to SAS Studio.
Plus, learn how to automatically add missing values in our tip of the month. Happy reading!
NEW VIYA FEATURES
Check out these new features and what they mean for you.
Product: SAS Information Governance
New feature: Review and manage semantic types.
Description: Through the new classifications UI inside of SAS Information Catalog, authorized users can change the information privacy level of a semantic type. Learn more.
Product: SAS Viya with SingleStore
New feature: Run DATA steps directly in SingleStore.
Description: SAS Viya with SingleStore is now able to run SAS DATA step code directly in SingleStore. Learn more.
Product: SAS Studio
New feature: Eight new steps in SAS Studio – from preparing data to machine learning.
Description: The latest release of SAS Studio Analyst and SAS Studio Engineer gives you eight new steps ranging across the different capabilities of SAS Viya. Learn more.
SPOTLIGHT USE CASE
Review and manage semantic types
Depending on your organization's needs, you might need to increase or decrease the sensitivity of personal identifiable information (PII) within your SAS Viya environment. Now you can change the default classifications inside SAS Information Catalog, and the corresponding flags that appear on a table level inside of SAS Information Catalog and SAS Visual Analytics will change accordingly. This allows you to easily control the privacy level of data.
TIP OF THE MONTH
Brought to you by David Weik Senior Pre-Sales Solutions Architect, SAS
As you are building your decisions, you are continuously adding more and more elements to them. You might be pulling in a prebuilt rule set, or you might be adding a model to the decision that a data scientist built. Along the way, you may have to add more and more missing variables, which can feel a bit cumbersome. That is a perfect opportunity to go into the SAS Intelligent Decisioning application settings and check the box to automatically add missing variables for you.
Learn more.
... View more