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.
Hi All, my teammates have sas newly installed in pc and got the above message when trying to use it. Any idea what could be the problem? just had sas eg installed but cannot use it, showing error message in the above attached picture. I also pinged it. What could be the problem? what other test can I do to trouble shoot? how to resolve?
... View more
%macro sort (dname, new, svar) ;
proc sort data=&dname out=&new ;
by &svar;
run;
%Mend;
%sort(sashelp.class, demo1,sex);
data _null_;
if cexist("WORK.SORT") then
put "WORK.SORT exists";
else
put "WORK.SORT does not exist";
run;
Hi Experts,
here i am trying macro catolog exist or not but its giving wrong output please check where i did wrong
... 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
I have two datasets, both including ID and day. I would like to merge them by ID and day but include the day variables from both files in the data I want, i.e. include them also when there is no match on the day variable.
data have;
input ID Day;
datalines;
1 1
1 2
1 3
;
Data have2;
Input ID Day;
1 .
1 2
1 3
;
Data want;
ID Day Day
1 1 .
1 2 2
1 3 3
... View more
Hi, I have a library of 100+ datasets each with 10+variables. I was wondering if it was possible to output an excel table that had the table name and the column names to the right kind of like the format below. Dataset_name1 | variable_1 | variable_2 dataset_name2 | variable_1 | variable_2| .... Any help would be greatly appreciated. Thank you.
... View more