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.
Is it possible to add Sensitivity Labels ("Public", "Internal", "Confidential" etc.) to Excel spreadsheets when they are created using Libname with engine XLSX? I couldn't find any options to this purpose on https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/acpcref/n0oj9f6i838mymn148890ckla700.htm.
Eg.
libname abc2 XLSX "C:\Temp\SomeSpreadsheet.xlsx";
... View more
This event is for the Nordics and UK&I; however, We welcome everyone interested in migration to Viya. Join us virtually for discussions.
Date: 29/10-2024
Time: 09:00-10:00 CET (GMT +1)
... View more
IND_F = ID1 >= ID2 >= ID3 ; One of the program says as below can someone please help what does that mean? They are all date values. I am seeing value of IND_F = 1 for few records not sure how ? Regards kajal
... View more
I am running a regression having a binary response variable and need to estimate fixed effects for hundreds of thousands of class levels (eleven_digit_account_id). Each code below produces hundreds of thousands of coefficients, one for each class level, overwhelming system resources. Is there a way to suppress class-level coefficients in any of these procs or is there another proc that can handle a binary response variable with hundreds of thousands of class levels? proc glimmix data=summary_statistics NOCLPRINT; class eleven_digit_account_id; model bet_win = net_stake last_round_profit miles_fan_bet_team eleven_digit_account_id/noint solution dist=bin link=logit; run; quit; proc genmod data=summary_statistics descending; class eleven_digit_account_id; model bet_win = net_stake last_round_profit miles_fan_bet_team eleven_digit_account_id/noint dist=bin link=logit; run; quit; proc logistic data=summary_statistics; class eleven_digit_account_id; model bet_win (event='1') = net_stake last_round_profit miles_fan_bet_team eleven_digit_account_id/noint; run; quit;
... View more
Hi,
I am using proc sql left join to merge my two excels on based on two mutual columns they have.
here is the code I use:
proc sql; CREATE TABLE FINALV3 AS SELECT * FROM WNPOP LEFT JOIN pop2012 ON WNPOP.State_Name_All=pop2012.State_Name_All AND WNPOP.County_Name_All=pop2012.County_Name_All; QUIT;
while the proc happened and I can see the columns joined and the number of obs are correct, I do not have values in the joined columns. (THERE IS NO ERROR in the LOG ).
any ideas of what is going wrong?
... View more