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.
Hello, I have a variable in my dataset. The categories for this variable are alphanumeric and in character format. For example, they are: A00 to A99, B60 to B89, and so on. Now, I want to list some of them in my SAS syntax: Data want;
set have;
If myvariable in A20 to A45 then myfavourite = 1;
else myfavourite = 0;
run;
Any help would be much appreciated. Thanks.
... View more
Hi SAS Optimization Community,
I’m presenting a live “Ask the Expert” webinar on May 23 rd , 11 AM – 12 PM ET entitled What’s New in SAS Optimization? I’ll show you how SAS Optimization continues to improve on its powerful modeling language with unified access to a broad suite of solvers. Bring your questions. We’ll host a live Q&A session at the end of the webinar.
You will learn about:
All the ways SAS Optimization is changing.
Recently added features, including a conic optimization solver and an automated Benders decomposition algorithm.
SAS Optimization performance improvements.
Reserve your spot for the webinar.
Want more tips? Be sure to subscribe to the Ask the Expert board to receive follow up Q&A, slides and recordings from this and other SAS Ask the Expert webinars.
Can't join the live event? You can view this and other Ask the Expert sessions on-demand here.
... View more
Hi , I have SAS jobs in SAS EG. For each job, I would like to have related output tables (after Table Loader Step). E.g. I have a JOB_A with two output (TABLE_A & TABLE_B) I would like to have something like: JOB_A | TABLE_A JOB_A | TABLE_B I don't know how to perform this with SAS code? Can you help with this? Thanks
... View more
Hi, I have a data set that gives me Race as as R1, R2, R3, R4, and R5. How do I format it to: R1 = American Indian/Alaskan Native, R2 = Asian, R3 = Black or African American, or R4 = Native Hawaiian or Other Pacific Islander, and R5 = White? When I used a format code is on variables R1, R2, R3, R4, and R5 either get uninitialized or all the columns comes up as American Indian/Alaskan Native. This is the code that I use: data merge_dataset2; set merge_dataset; format RACE1-RACE5 $100.; if RACE1-RACE5 = R1 then RACE = "American Indian/Alaskan Native"; else if RACE1-RACE5 = R2 then RACE = "Asian"; else if RACE1-RACE5 = R3 then RACE = "Black or African American"; else if RACE1-RACE5 = R4 then RACE = "Native Hawaiian or Other Pacific Islander"; else if RACE1-RACE5 = R5 then RACE = "White"; run; Thanks
... View more
I have a data set with DMRN and date of the visit (DX_Date). I would like to generate the the start and stop time or T1 and T2 based on each visit date. Could you please help me with the code?
Here is how the data look like:
DMRN
DX_DATE
31
09MAY2017
31
30MAY2017
31
06APR2018
31
07FEB2019
33
02JUN2017
33
04DEC2017
33
11JUN2018
This is how I want to outcome be like:
DMRN
T1
T2
31
09MAY2017
30MAY2017
31
30MAY2017
06APR2018
31
06APR2018
07FEB2019
33
02JUN2017
04DEC2017
33
04DEC2017
11JUN2018
... View more