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.
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
Suppose, because I would like to create some visual separation between groups of columns in PROC REPORT output, I want a column that is shaded gray and has no data in it. I can get most of the way there via this program. Note the use of the fake variable GAP in the columns statement, which produces the empty column F in the Excel output. But you can see the gray appears for the DATA rows but not for the header rows. In PROC REPORT, I use style(header) but it doesn't produce the desired results. So how can I get PROC REPORT to shade the first two rows of column F the same color gray?
proc format;
value gapf .,low-high=' ';
run;
ods excel file="test.xlsx";
proc report data=sashelp.cars(obs=50);
columns make msrp,type gap invoice,type;
define make/group "Make";
define type/across " ";
define gap/' ' format=gapf. style(column)={cellwidth=.01in backgroundcolor=verylightgray}
style(header)={backgroundcolor=verylightgray};
define msrp/mean "MSRP";
define invoice/mean "Invoice";
run;
ods excel close;
Also, how can I make column F narrower, the option cellwidth=.01in doesn't seem to make it that narrow? Is this too narrow in Excel?
... View more
Hi everyone! I'm currently learning SAS programming, and I wanted to embark on my own project for now. I have access to SAS Viya, so I was thinking of conducting unsupervised classification of emails (multi-class classification) through VDMML and VTA. I was thinking of running the text through VTA and then extracting the score code from the categories node, and then process this data to use in VDMML to train a classification model. However, I'm not sure what kind of pipeline would be suitable for this approach as most of the current pipelines seem catered towards supervised learning. Any help in this area would be appreciated. Apologies if this is a very basic question, and thank
... View more
How can I fix this code? _LABEL_ can't be found. And the results Pctls_trp_trp, imo dosen't look very nice. with _NAME_ and col1-col14. Can someone help me with the _LABEL_ ? proc univariate data=sashelp.shoes noprint;
var Sales Inventory Returns;
output out=Pctls pctlpts = 5 10 20 25 30 40 50 60 75 80 90 95
pctlpre = Sales_ Inventory_ Returns_
pctlname = pctl5 pctl10 pctl20 pctl25 pctl30 pctl40
pctl50 pctl60 pctl75 pctl80 pctl90 pctl95
mean=Sales_mean Inventory_mean Returns_mean
std =Sales_std Inventory_std Returns_std ;
run;
PROC TRANSPOSE data=Pctls out=Pctls_trp;
run;
data Pctls_trp;
set Pctls_trp;
_NAME_=scan(_NAME_,1,'_');
run;
proc sort data=Pctls_trp;
by _NAME_;
run;
proc transpose data=Pctls_trp out=Pctls_trp_trp;
by _NAME_;
id _LABEL_;
var col1;
run;
/* end of program */
... View more
A new update is available for SAS Studio , version 15.3 : Hot Fix: L9L019 - Published 30MAY2024 , Download link for L9L019 Component name: SAS/STAT Related SAS release: 9.4 Issues addressed in L9L019 SAS Note 70794 The MCMC procedure issues a warning in SAS® Studio when you specify the NTHREADS= option This list of notes might be incomplete. For a complete list of issues addressed by this hot fix, visit the hot fix page for L9L019 Note: A comprehensive list of all SAS hot fixes is available from support.sas.com. You can use the SAS Hot Fix Analysis, Download, and Deployment (SASHFADD) tool to manage your SAS hot fixes.
... View more