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