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 Folks, I have a string variable called string and what I need to do is search for certain letters such as S or X and if I find it then I need to convert the string to XXXX. Does anyone have some example code to do this? All the best, Sean data test;
infile datalines delimiter=',';
input string $ newstring $;
datalines;
F03 J47 S528 X590,F03 J47 XXXX XXXX
E872 R263 S720 X590,E872 XXXX XXXX XXXX
S720 X590,XXXX XXXX
S150 V789,XXXX V789
;
run;
... View more
I get the error: ERROR: The SAS/ACCESS Interface to ORACLE cannot be loaded. ERROR: Image SASORA found but not loadable.. Please make sure Oracle environment is set correctly. Look in the install/Config doc for additional info for your platform. Works fine interactively, but no longer when submitted as a batch file. Worked fine this morning (and for years), but then installed MS Visual Studio and Python. That seems to have changed some path variable SAS version 9.4 TS 1M6, Windows 10 Enterprise In interactive mode (where it continues to work): %sysget(TNS_ADMIN) returns the correct network location. ORACLE_HOME, LD_LIBRARY_PATH not defined as system variables. I've uninstalled Python, MS Visual Studio, and reinstalled SAS. Same errors. First time posting here. Looked at related posts, but couldn't figure it out. Much appreciate any help.
... View more
Hi experts,
I am using SAS Mirror Manager and I am noticing something odd. I am using the "--deployment-assets" parameter to point to the deployment assets file downloaded from my.sas.com but it seems like SAS Mirror Manager is always downloading the latest release and not the release found in the deployment assets file.
According to the doc I expected it to download the same cadence and release found in the deployment assets file and not the latest release. I verified the downloaded release in the downloaded path:
../sas_repos/rel/stable/2024.04
I see there:
relFormatVersion":"0.0.1","name":"stable","version":"2024.04","latest":{"duList":"lod/stable/2024.04/20240511.1715441583768
But my deployment assets file name has a different release:
stable_2024.04_20240423.1713898974806
The command I am using is:
$MIRRORMGRPATH/mirrormgr mirror registry --path ${MIRRORPATH} --deployment-data ${ASSETSPATH}/${CERTSFILE} --deployment-assets ${ASSETSPATH}/${ASSETSFILE}
What am I missing here? Maybe I am looking in the wrong place.. where can I see/verify which release was downloaded by mirror manager?
... View more
Please can someone help me. I have SAS 9 table with colonne TPS whixh specify the duration. Eg i can have in this variable modality like 30:22:00. After chargin this table in my CASLIB, for the same record this variable shows 6:22:00.
Seems like SAS ignore the 24 hours . After 24hours SAS set to null the duration.
How can i find issue to this problem ?
Thks
... View more
Esteemed Advisers
I need some help with selectively deleting observations by groups. Below are exemplar “have”and “want” datasets. The goal is to retain only one Member that contains “A” in both the Alpha and Beta Groups (which one is retained is irrelevant as they are redundant).
Thanks for taking a look and any advice you have to offer,.
Gene
data have;
input Group $ Member $;
Alpha A1
Alpha A2
Alpha B1
Alpha B2
Alpha A3
Alpha C1
Alpha C2
Beta A1
Beta A2
Beta D1
Beta D2
Beta E1
Beta E2
Beta A3
;
data want;
input Group $ Member $;
Alpha A1
Alpha B1
Alpha B2
Alpha C1
Alpha C2
Beta A1
Beta D1
Beta D2
Beta E1
Beta E2
;
... View more