i suspect that you will need to do new calculated item:     click the Operators tab, then filter for Percentile:   Enter your desired percentile in the GUI: and choose your numeric column.   test it out to ensure that it is giving you the value you expect.   good luck   ... View more

Depending on your level of access and the security model in place within your SAS Viya Env, you may need an admin's assistance.       Objects (reports, custom graph, etc) saved in the SAS Content folder structure can be deleted from Environment Manager.  Here is a screen shot showing what it would look like (note that i keep all custom built graph objects in a folder called zCustomGraphs):   Once you are in EnvManager, click the Content chicklet.  then browse to the custom graph you no longer want to keep.  right click and delete that object.     good luck! ... View more

PROC SQL; create table want as SELECT a.transactionid ,c.premium ,b.Comm% ,b.Commision ,a.rwd% ,a.reward FROM data3 a left join data2 b on a.transactionid = b.transactionid and a.[reward commision] = b.commision left join data1 c on a.transactionid = c.transactionid and a.[reward commision] = c.premium ; quit; ... View more

it sounds this might be what you are after   PROC SQL; Create table innerjoin_ as Select x.* , del_exc_rat , lagcogs , lagsel_gen_adm , lagope_lea_exp , lagr_and_d , laggoodwill from winsed.merge_treat_con as x INNER JOIN _9b_lag as y ON x.Type = y.Type; Quit; ... View more

I did not find an effective solution to append tables directly in CAS.  I create a table in SPRE, drop the table in CAS (if it exists), and then promote it back.  we do this A LOT every hour.  so I have a nice auto call macro that handles a wide range of activities around updating data in CAS, but i plucked out a few macros that might help you out.  i find them very useful.   you end up invoking the %checkcasresult() macro by providing source table and target table information.   good luck, %MACRO UniformDelay(); %PUT Insert Random Delay, Between 0 and 1 Second; DATA _null_; UniformDelay = rand('Uniform'); rc=SLEEP(UniformDelay,1); RUN; %MEND; /* Macro for Dropping a Table from CAS */ %macro DropIt(name=); proc casutil incaslib="public"; droptable casdata="&name"; /* list files; */ run; quit; %mend; /* Load table to CAS and Promt */ %macro LoadPromoteIt(name=); proc casutil; load data=work.&name outcaslib='public' promote ; save casdata="&name" replace; run; quit; %mend; /* Remove existing table from CAS if loaded already */ %macro deleteCASdsifexists(lib,name); %if %sysfunc(exist(&lib..&name.)) %then %do; %put DeleteCASDSifExistsMacro; %DropIt(name=&name); %end; %if %sysfunc(exist(&lib..&name.)) %then %do; %put First Attempt Failed; Trying one more time; %UniformDelay(); %DropIt(name=&name); %end; %mend ; %macro checkCASresult(Slib,Sname,Tlib,Tname,email); %PUT Source Data &Slib..&Sname.; %PUT Target Data &Tlib..&Tname ; %if %sysfunc(exist(&Slib..&Sname.)) %then %do; %put CheckResultMacro; %UniformDelay(); %deleteCASdsifexists(&Tlib, &Tname); %UniformDelay(); %put loadTable; %LoadPromoteIt(name=&Sname); %end; %else %do; %put table not there; %end; %mend; ... View more