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.
proc sql; create table MostPopularRouterByState as select c.State, o.SKU, count(o.OrderID) as TotalOrders from DATA_ELE.ORDERS o inner join DATA_ELE.CUSTOMERS c on o.CustomerID = c.CustomerID group by c.State, o.SKU having calculated TotalOrders = (select max(calculated TotalOrders) from DATA_ELE.ORDERS o2 inner join DATA_ELE.CUSTOMERS c2 on o2.CustomerID = c2.CustomerID 77 where c.State = c2.State 78 group by c2.State, o2.SKU) 79 order by c.State, TotalOrders desc; ERROR: Summary functions nested in this way are not supported.
... View more
Hi. I'm SupermanJP. I updated SAS plotter, modern data visualization package for SAS base. https://github.com/Superman-jp/SAS_Plotter document https://superman-jp.github.io/SAS_Plotter/ new features new plots " sankey diagram" was available! official mail address: sasplotter@picolabs.jp official web site (Japanese) https://picolabs.jp Please feel free to contact me if you have any bug reports, feedback, or requests.
... View more
I am seeking urgent help as the issue impacting all SAS Studio users on our Viya 4 environment. Since 9:30AM EST today, users have been encountering an error message stating "ERROR: Insufficient disk space is full, or quota has been exceeded." or "ERROR: Insufficient space in file WORK.BDXFS124.DATA." Unable to run even simple steps like proc contents, or reading data from sashelp to work directory and this issue is causing significant disruption to our daily operations, as it prevents users from performing any task in sas studio and sometime we noticed "sas studio compute context" is keep on disconnecting.
Our SAS administrator verified the status of pods, and all are working fine and we are unable to identify what caused the issue all of a sudden. Unfortunately, the impact is even more critical as we have fully transitioned to SAS Studio and do not have access to Base SAS at this time and we depend on sas studio for our daily operatoins.
Given the severity of the problem and its impact on our daily operations, any guidance or solution you can provide would be greatly appreciated.
Please let me know if there are any immediate steps we can take to free up disk space or identify the cause of the quota being exceeded. We are available to discuss this matter further at your earliest convenience.
Sincerely,
Bhaskar
... View more
Hi everyone,
could you please tell me how to remove the "subgroup size label" from the attached plot? displaying this label only for the pre-intervention (left side of the plot) disrupt the appeal of the plot.
proc shewhart data=both1 (rename=(_phase_=_index_)) ;
by _index_ notsorted;
xschart LOS_hours*AdmitYYQ / nochart OUTLIMITS=Limits;
run;
proc shewhart data=both1 limits=Limits ;
xschart LOS_hours*AdmitYYQ / readphase=all readindexes=all phaselegend totpanels=1 skiphlabels=1
turnhlabels nohlabel nochart2 ODSTITLE="Mean Chart " ;
label LOS_hours = 'Mean LOS';
run;
Thank you!
... View more
I am trying to connect to Postgres in Base SAS 9.4 for the first time using the following command: libname pg postgres user=**** pwd=***** server="****" database=**** conopts="sslmode=require" ; I am receiving the following error: CLI error trying to establish connection: Service negotation failed; The client and server cannot communicate, because they do not possess a common algorithm. in DoSchannelNegotiation:CreateSchannelCredentials If anyone recognizes this error, please let me know how you resolved it!
... View more