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.
I have the following data, How I can create the multiple records based on the horizontal data , depening on the time variables. thank you for your help.
Assumptions:
1. if all four time vairables avaialble then need two records with startdate time and stopdate time depending the on the time
Example first and second rows. only difference between first and second row is column D and E have same time
2. when "restarttime" missing consider the "intermediatestopTime as "restarttime"( and vice versa) and create two records.
3. when "intermediatestoptime" and "restartime" missing then create one record for "stopdatetime" and "startdatetime".
data have;
format date date9. starttime time8. intermediatestoptime time8. restarttime time8. finalstoptime time8.;
do i = 1 to 4;
usubjid = "00-01";
date = '01OCT2024'd;
/* Generate different times for each record */
starttime = '12:20:00't + (i-1)*600; /* Increment start time by 10 minutes each iteration */
intermediatestoptime = starttime + 600; /* Intermediate stop time is 10 minutes after start time */
restarttime = intermediatestoptime + 600; /* Restart time is 10 minutes after intermediate stop time */
finalstoptime = restarttime + 600; /* Final stop time is 10 minutes after restart time */
output;
end;
drop i;
run;
data have1;
set have;
if _n_ =2 then restarttime = '12:40:00't;
if _n_ =3 then restarttime = '';
if _n_ =4 then do; restarttime = '';intermediatestoptime='';end;
run;
... View more
Hello, I have my dataset in Explore and Visualise/ Visual Analytics and I have been working on my report. I realised there is more prep work to be done on this dataset such as creating a new column, is it possible to go to Prepare Data/SAS Data Studio and make this new column? Will this column be automatically added to the report I have been working on in Explore and Visualise if not how I can see it in the report I am currently working on? Lastly, when I prepared my dataset in SAS Data Studio and added some transforms I got this message 'Results are out of sync with the session table' - what does this message mean? Many thanks, Aleks
... View more
Obs months 1 2 2 2 3 6 4 2 I want to merge the dataset above with other datasets based on value of months variable. For example, I want to merge two months of data for the first record, two months of data for the second record, 6 months of data for the third record, and 2 months of records for the fourth record. Is there a systematic way of doing it? I was thinking about creating a variable based on the months variable and create a loop within a macro to achieve it.
... View more
Hi I have a file uploaded to a big data platform showing correct d.p but somehow when our clients see the same file via ODBC, the decimal place change from 4 to 2, how did that happen? Do I need to setup schema for showing data via ODBC or there is specific settings required dealing with?
... View more
Hi everyone, I was following this example of text classification with VTA, VDMML and VA on my own dataset for my project (Link: Classifying messy documents: A common-sense approach (Part II) - SAS Users) My score code ran successfully with no warning or error messages, and the results show that the output CAS tables are in the library I want them to be in, however, I was not able to find the respective tables in CAS. I ensured that I typed in all the details of the input_caslib_name, input_table_name, output_caslib_name and output_categories_table_name is correct. Here are some debugging steps I took: 1. Refreshing the CAS connection -> no change 2. using PROC CONTENTS to check if the table exists -> got this error message thrown, ERROR: File PUBLIC.<table_name>.DATA does not exist. Has anyone gone through this issue before as well? Thanks in advance
... View more