Recently in the SAS Community Library: SAS' @Sundaresh1 highlights a sometimes overlooked task when applying document embeddings for purposes of similarity-based search. Normalisation of vectors helps obtain relevant matches.
Hi everyone - a bit newer to SAS and running into a problem trying to adapt someone's older code. Essentially I have a character variable with responses, and am coding in skips to it. e.g. Add skip coded 777 into the open text variable OPENTEXT1 if responses are blank OPENTEXT1 has character responses maxing out at 161 characters, proc contents show format=161 informat=$161. Check responses with proc freq, all 777 and responses are normal Then I create a "label" using the proc format function with value to label the skip and keep responses proc format; value OPENTEXT '777'="Skip"; run; data dataset1; set dataset; format OPENTEXT $OPENTEXT. proc freq, this time 777 show "SKIP" but other responses truncated to 4 characters I checked proc contents, and it is still showing format and informat still remaining at the same length. Any help appreciated
... View more
Is it possible to use custom Base SAS code for extracting business rules from an Excel file and subsequently generate rules in SAS Intelligent Decisioning via an API? Essentially, I aim to articulate the business logic, specify the associated variable, and have the API automatically translate it into a SAS Intelligent Decisioning rule.
... View more
Hello I was trying to find how a user can store their data on premise disks when working on SAS Viya 4 on AWS. The user data may include files, reports, datasets etc. Disks are essentially local shared drives. I would appreciate if anybody can enlighten on this.
... View more
Hi everyone, I am using claims data for analysis and was stuck at one part in continuous enrollment. Any help would be appreciated. Thanks! I need patients who are continuously enrolled for 12 months prior to the index date to at least one month and maximum of 12 months after the index date. A gap of 30 days is acceptable. Also, I'm interested in first enrollment period only. Here's the data I have Data Test; input patid $ dtstart :YYMMDD10. dtend : YYMMDD10.; format dtstart YYMMDD10. dtend YYMMDD10.; cards; 001 2017-01-01 2017-01-31 001 2017-02-01 2017-02-31 001 2017-05-01 2017-05-31 002 2018-01-01 2018-01-31 002 2018-02-20 2018-04-31 003 2020-03-25 2020-12-31 003 2021-01-15 2021-08-31 Output (intermediate): 001 2017-01-01 2017-02-31 001 2017-05-01 2017-05-31 002 2018-01-01 2018-04-31 003 2020-03-25 2021-08-31 Now, patid 001 has two periods of continuous enrollment but I need only one enrollment period. So the desired output should be - 001 2017-01-01 2017-02-31 002 2018-01-01 2018-04-31 003 2020-03-25 2021-08-31 Following is the Code that I think would work. Not tried yet since data takes long time (~ a day) to process so I want to make sure I do it correctly. I just want to share my thought process Data test1; set test (rename = (dtstart = start dtend = end)); ; by patid; retain dtstart dtend enrolcnt; label dtstart = "Enrollment Date Start" dtend = "Enrollment Date End" Enrolcnt = "Enrollment Period Count"; if first.patid then do; dtstart = start; dtend = end; enrolcnt = 1; end; else do; if dtend + 30 >=start then do; if dtend < end then dtend = end; end; end; if last.patid then output; run; Once I get the continuous enrollment period, I will then select patients with continuos enrollment with enrollment start date 12 months prior to the index date to at least one month and maximum of 12 months after the index date. What confuses me is how to code for "at least" part in the previous statement. Should I create a new date variable as (new = index_date + 30)? SAS CODE (definitely incomplete) - Proc sql; create table test3 as select a.*, b.dtstart, b.dtend from data_index_date as a right join test1 as b on a.patid = b.patid where intnx ('day', a.index_date, -365) GE b.dtstart and a.index_date LT b.dtend order by patid; quit;
... View more
I'm trying to run a test auto-forecast model. I uploaded a simple dataset that matches the format of sample forecasting dataset provided by SAS Viya. The dataset uploads successfully. However, I get the following error when running the project: "The project could not be opened and returned the following status: creatingProviderError" Online support suggests to change the time zone to UTC. However, I'm not able to find the command line on SAS Viya. Here's the online troubleshoot suggestion: https://support.sas.com/kb/61/709.html Please let me know how to resolve this and create a auto-forecast model. Thanks!
... View more