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 experts,
I'm using LEI (Visual Investigator 10.8)
I configured a relationship between entity X and Y.
I would like that this relationship will be created after a task will be approved by a user (assumed that I have a workflow that after an action in it, the relationship will take place...).
It is possible to do that. I didn't get any information regarding this in the documantation.
The below demonstrate it better:
1. A relationship between X and Y has defined.
2. Workflow on entity X was defined.
3. a user create a relationship between record in entity X and record Y. The relationship between them yet not approved (and not visible in Network diagram / bridge table etc...)
4. workflow task on entity X is being made.
5. after a specific task action completed - the relationship will be shown at the Network diagram.
Something like this is possible?
Thanks in advance.
Idan
... View more
Hi folks,
I am attempting to read an xlsx file into SAS without SAS doing anything to modify the the variable types or the characters as they appear when viewing the xlsx file in Excel. In other words, if something looks like a date, regardless of how it's stored in the xlsx file (e.g., "11/25/2023"), it'll show up in sas as a character variable as that same value (e.g., "11/25/2023"). In other words, I'd like to replicate what the Import Data wizard in SAS does when it just defines all fields as character, as in the following attributes for one particular column, for example:
type=String
Source Informat=$CHAR29
Len.=29
Output Format=$CHAR29.
Output Informat=$CHAR29.
The code automatically generated from the Import Data wizard when I do this contains the DATALINES4 statement, which I can't use because I can't just fill all of these in, as I'm trying to load the data in without having to look at the contents. I'd be fine, though, if I can define the variable types/lengths/formats/etc., as I know what the variables are and what they'll be named.
How do I do this without having to fill in the DATALINES4 content?
I need to be able to specify the sheet within the Excel workbook in question as well.
Thanks!
... View more
Hi there,
I am busy cleaning up our backdated files where we have zipped the files to save storage space.
I am trying to create the code to scan through my various folders and if there are files that have been unzipped then it zips it if the zipped file doesn't exists, otherwise if the files have been unzipped and the zipped ones exists, then it should delete the original file.
... View more
Hello everyone, I am trying to select alternate columns from my dataset, starting from column number 1 and including every nth alternate column after that. For example, I want to select columns 1, 3, 5, 7, and so on up to column n. Is there a way to make this selection without having to manually specify the column names? Here are my column headers: FINAL_STATUS_01MAY24, FINAL_STATUS_02MAY24, and so on...
I would appreciate any help or advice. Thank you!
... View more
I was trying to use tasks for the first time and they didn't work. I can click things, but it doesn't generate any code. Do I need to do something to enable them.
Will the Machine Learning tasks work without being licensed for Visual Machine Learning? Although, I can't get even the basic descriptive tasks to work.
... View more