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.
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
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
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