The LITI rule for Text Analytics that you didn’t know you needed…until now!
Recent Library Articles
Recently in the SAS Community Library: Customer complaint call transcripts can end up being quite verbose. SAS' @PeterChristie reveals how to distill relevant info using SAS Text Analytics.
Hello Community,
I am dealing with Proc ARIMA for outliers detection, I would like to output the dataset with the outliers dates by a variable:
/*-- Outlier Detection --*/
proc arima data=CASUSER.ds out=ds_outliers;
identify var=dk noprint;
by region;
estimate method=ml;
outlier id=date;
run;
This is the output for a single region, I would like to flag the outliers in my original dataset. I checked and with out= option the is just statistics of the model.
... View more
I recently started a discussion about difficulty installing SAS 9.4 on a Windows 11 platform. There were a couple comments but none with a solution (even though one was accepted as a solution by accident, somehow). After communicating with SAS technical support directly, it was discovered that Windows 11 requires SAS 9.4 to be at least version M7, and the latest version is actually M8. The version I was trying to install was an old M4 version and that is apparently why the install failed. Moral of the story, if you are using Windows 11, use the proper version of 9.4.
... View more
Hi, I'm fighting with a translate() function in my new job. I have my 'old faithful' code fragment to remove diacritics (accented characters) which worked fine (both: in datastep and proc sql) -till current job: TRANSLATE(FirstNAME, "aaccdeeillnnoorrsstuyzz", "áäčćďéěíĺľňńóôŕřšśťúýžź") + I tried to replace " with apostrophs >>> no! + I tried to change obly one character (e.g. á to a) - it worked well + but when I extend <StringFROM> and <StringTO> to very small set of characters (fom 'áíšžň' to 'aiszn') >> translate() started to mix the characters: .. + Adamík =>>> Adami k ... error: add space after correct change + Arpáš =>>> Arpi � ... change á to i instead of a + strange char inst. "s" + Badáň =>>> Badi ň ... same "a" + ignore ň from list + Ažimov =>>> Ažimov ... ignore ž Bonus: I have another 'shape' to remove strange chars from a name and it seems works 😄 ... (all are changed to a space which is further celaning by COMPBL() 😞 COMPBL(translate(FirstNAME, " ", "0123456789/\:;|{}[]()!@#$%^&*_.,-")) as MyLoveNAME, Have somebody an idea where is it screwed? PS: I hacked it by this ugly patch ... tranwrd(tranwrd(tranwrd(tranwrd(tranwrd(tranwrd(tranwrd(tranwrd(tranwrd(tranwrd(tranwrd(tranwrd(tranwrd(tranwrd(tranwrd(tranwrd(tranwrd(tranwrd(tranwrd( lowcase(cli.FirstNAME), 'á', 'a'), 'ä', 'a'), 'č', 'c'), 'ď', 'd'), 'é', 'e'), 'ě', 'e'), 'í', 'i'), 'ĺ', 'l'), 'ľ', 'l'), 'ň', 'n'), 'ó', 'o'), 'ô', 'o'), 'ŕ', 'r'), 'ř', 'r'), 'š', 's'), 'ť', 't'), 'ú', 'u'), 'ý', 'y'), 'ž', 'z') as NameNoDIA, ...but it makes me sick 😞 and -truly: i'm surprising it works. -thx- Martin
... View more
Hey friends! I am aiming to compare a departments KPI to an overall KPI which is that of the whole organization. Thus, I want to make a line chart in SAS VA, where one of the measures is affected by user input through lists and button bars, choosing the department in focus. In the same line chart, I want to show another measure as well - an index which is the average KPI for the whole company. This should therefore remain unaffected by the users choices with regards to input through lists and button bars. So how can I make it happen, either by some techincal or designwise adjustment?
... View more
We are using SAS94M8 on Linux Grid platform. As part of a project we would need to connect to Teradata Vantage on GCP. Part of this migration will change the way clients use to connect to Teradata from LDAP to SAML based federated authentication approach. Can this feature of SAML based federated authentication be enabled or released for SAS94M8? Documentation for configuring federated authentication on Teradata. Configuration for Browser Authentication • Security Administration • Reader • Teradata Online Documentation | Quick access to technical manuals End users would only need to provide the DSN name and the logmech (BROWSER or EXTERNALBROWSER) to connect to the database. Teradata support the BROWSER mechanism on Windows and Mac OS only.
... View more