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 - ¿How can I connect files from a web server to sas viya? I want to automatically capture the log files in .gz, and then process them (ex: domain.com-2024-04-11.gz).
... View more
When a gambler decides how much to bet, their decision is influenced by their prior wager outcomes (perhaps they start to double down if they have sustained losses, for example), and I am trying to examine how NFL gamblers' prior betting profits/losses influence their next-round-of-betting behavior. I need to sum just the profits/losses from last round of completed NFL events. NFL events occur in distinct blocks (e.g., Sunday at 1:00, 4:00, and 8:00, Monday at 8:00, Thursday at 9:00) and last three hours, but bets can be placed any time from a week before the block up until game time. The dataset I am attaching contains only one gambler but there are many gamblers (each uniquely identified by product_account_id), so the sum needs to begin anew when a new product_account_id is reached. As you can see, things get especially messy with rows 89-104. I would also like to set up a structure where I can sum the profits from the last 2, 3, 4, and 5 rounds of betting. Any help would be greatly appreciated. proc import datafile='C:\SAS_help_request_05112024.xlsx' out=sample_dataset dbms=xlsx;run;
... View more
How can I reset my user ID to connect to SAS through Coursera? See message below: An error occurred. Please contact your system administrator. There was an error when authenticating against the external identity provider: The system could not obtain group memberships for korto.korlewala@snhu.edu.
... View more
I'm having difficulty writing a piece of SAS code and I'm seeking the most effective approach within SAS. I have a variable named 'type' (with values 1, 2, 3, 4) and client IDs. Essentially, I aim to create another variable called 'modified_type,' which follows these rules: If there's a single unique client ID with only 1 in the 'type' variable, then 'modified_type' should be set to 0. However, if there are multiple client IDs with the same number having 1 in the 'type' variable, 'modified_type' should be set to 1. If there are 2 in the 'type' variable, then 'modified_type' should be set to 2... and so on. I tried using the retain function so something like this: retain modified_type 0; if first.client_id then modified_type = 0; if type = '1' or type = '1st' then modified_type = 1; else if type = '2' or = '2nd' then modified_type = 2; and so on..... but these does seem to retain 0 in the type and for some reason shows as 1. Yea im note sure the best way to do this, a newbie at SAS so would even appreciate the point in the right direction:
... View more
Hi all,
Please help me to code this. This is the dataset below-
I have 2 drugs being used for each ID i.e., SGA and DM. I have multiple start date and end dates for each ID and drug. I want to see if the DM_start falls into any of the SGA_start and SGA_end under each id. That is DM_start of period 3 can fall in the SGA_start and SGA_end of period1.
And also calculate the number of overlapping days for each time period. I want to know the no. of days for each orange period.
Thank you all in advance,
Any help would be appreciated.
... View more