Recently in the SAS Community Library: SAS' @StuartRogers provides a close look at the new Microsoft Entra Gallery application and details how it can be used.
Hello, I don't have much experience with SAS VA. The user is requesting the creation of a custom page where they can select various options as shown in the attached photo. I need to be able to capture the selected parameters in a job execution. The page in the attached image is a test created using HTML code in SAS job execution. Could you please guide me on how to capture the parameters in a new job upon clicking the button? Thank you.
... View more
I write one macro which works fine to split data into 2-subgroups.
Logic is 1) sort by target var 2) based on weight/wt, split into 2 subgroups.
BUT how to split into N-Subgroups with N as a parameter, say N=3 or 7?!
%macro bisect(ds, byvar, cutvar, note);
proc sort data=&ds.; by &byvar.; run;quit;
data &ds.;
set &ds.;
retain wt_sum;
wt_sum=coalesce(wt_sum,0)+&cutvar.;
run;quit;
data &ds.(drop=wt_sum);
set &ds.;
if wt_sum<=50 then ¬e.=1;
else ¬e.=0;
run;quit;
%mend;
... View more
Hi I am currently building a dashboard on viya for learners as part of my masters program and for one part I need to display values on a bar chart but I also would like to add a line on each bar that is the cut-off value but I can't find a object that allows me to do it in such a way. Is there any way I can do this ? This is how my Bar chart looks I have values for each year for the size but I still need to display the cut-off value on this bar chart in a line or something for each year can this be done in VA?
... View more
Hi, I have the following ODBC connection: LIBNAME IFRS17_H ODBC DATAsrc=IFRS17_HIVE SCHEMA=ifrs17catalog USER="rubence" PASSWORD="XXXXXXXXXXX"; When I try to use a WHERE clause, data KFS;
set IFRS17_H.key_figures;
where key_figures.pyear='2024';
run; SAS shows the following message: but if I do not use a WHERE clause, I have no problems and the var names in the new table follows the structure: TABLE_NAME.VAR_NAME. My questions are: a) How can I avoid to download the full table? b) Is It possible to use only the VAR_NAME and not TABLE_NAME.VAR_NAME? Many thanks for your great help.
... View more
Hello
I created a new library name called PanelOsh
I used this code and I see that the folder was created successfully
options dlcreatedir;
libname PanelOsh "/usr/local/SAS/SASUsers/LabRet/Credit_Scoring_Users/";
I want to create also sub-Folder within library PanelOsh that will be called Raw_Data.
What is the way to do it?
I run following code but the folder was not created
options dlcreatedir;
libname Raw_Data "/usr/local/SAS/SASUsers/LabRet/Credit_Scoring_Users/PanelOsh";
... View more