Hello,   Need help with detecting anomalies in my dataset    data hdfs_kim.node_monitoring; input  date node1 node2 node3 node4 node5  datalines ; 01-02-2020 0.45 0.44 0.78 0.32 0.99 02-02-2020 0.34 0.32 0.89 0.56 0.77 03-02-2020 0.89 0.65 0.76 043 0.81 04-02-2020 0.73 1.34 0.66 0.33 0.49 05-02-2020 0.23 0.44  0.54 0.66 0.66 06-02-2020 0.88 0.76 2.56 0.61 0.71 ; run;   Can help me find anomalies in this dataset - I have used    proc rpca data=hdfs_kim.node_monitoring lambdaweight = 3.5 outsparse=hdfs_kim.sparsemat2; id date; run; proc print data=hdfs_kim.sparsemat2; run; proc rpca data=hdfs_kim.node_monitoring scale center; id date; anomalydetection; savestate rstore=hdfs_kim.store; run; proc astore; setoption rpca_projection_type 2; score rstore=hdfs_kim.store data=hdfs_kim.node_monitoring out=hdfs_kim.scored; run; proc print data=hdfs_kim.scored; run;   I was not able to interpret results using RPCA  when i have node1 -16, any help with other process or procedure i am willing try.   Thanks  Rahul  ... View more

Hi,   I using SAS Viya 3.5, and trying to solve a problem where i need to save an in memory dataset back to hive database, also would like to know if it is possible to load the data from hive to inmemory using embeded processing ?   PROC CASUTIL; save incaslib=HIVE_CLM_KIM casdata="STOCK_MOBILE_WEEK_AGG" outcaslib=HIVE_CLM_KIM casout="STOCK_MOBILE_WEEK_AGG"; QUIT; Any help on Embeded processing on hive is much appreciated.   Thanks  Rahul    ... View more

I have been Trying to perform updates on CAS tables.   I am able to perform simple updates in CAS, but not a complex ones.   proc cas; cas_table.name ="CI_CUST_CONTACT_HISTORY_STAGE"; cas_table.where = "CONTACT_MONTH = 201907";  table.fetch / table = cas_table; run;   table.update / table=cas_table set={ {var="SEQUENCE_NO", value="SEQUENCE_NO*10"} }; run; table.fetch / table = cas_table; run;   How do i update  if i CONTACT_MONTH  more than 10000 contact_month  in where condition and variable to update SEQUENCE_NO is specific to the contact_month this is a complex update that am unable to do in CAS.   But what i tried to do use a loop that is time consuming.   %MACRO SCANLOOP; /* First obtain the number of */ /* records in DATALOG */ DATA _NULL_; IF 0 THEN SET hdfs_kim.CONTACT_UPD_JULY2019 NOBS=X; CALL SYMPUT('RECCOUNT',X); STOP; RUN; /* loop from one to number of */ /* records */ %DO I=1 %TO &RECCOUNT; /* Advance to the Ith record */ proc cas; cas_table.name ="CONTACT_UPD_JULY2019"; cas_table.where = "contact_key=442276500"; run; table.update / table=cas_table set={ {var="SEQUENCE_NO", value="SEQUENCE_NO*100"} }; run; %END; %MEND SCANLOOP; /* Call SCANLOOP */ %SCANLOOP; RUN;   Any help is much appreciated.   Thanks  Rahul ... View more

proc fedsql does not support macro 'into' facilty unlike the proc sql.     PROC FEDSQL sessref=mySession ; SELECT MAX(CONTACT_KEY)+1  INTO :V_CONTACT_KEY FROM caslib.CI_CUST_CONTACT_HISTORY; quit;   PROC sql ; SELECT MAX(CONTACT_KEY)+1  INTO :V_CONTACT_KEY FROM oralib.CI_CUST_CONTACT_HISTORY; quit;   does anyone know how to max value from caslib dataset and store it in macro ? I am aware that it can be done with  %let ( ofcourse ) and CALL SYMPUT, but with proc fedsql it isnt working. ... View more

Is it possible to run Oracle stored process in SAS Viya using proc  fedsql or any other means? similar to the below example in SAS 9.4   proc sql; connect to oracle (user=userid password=password path=database_name); execute (execute st_pr_name('parm')) by oracle; disconnect from oracle; quit; ... View more