Hello, THIS IS ON SAS VIYA 3.4 This is my date slider right now.   This is a GLOBAL FILTER on my report! I want to "convert" it into two drop down lists. One for the start of the period I want to examine and one for the end. Important here is to maintain the functionality of my report which has to be untouched. Thanks. ... View more

Hello, The Platform here is SAS Viya 3.4 I have a task and I am not able to implement it with my current knowledge on Reporting. The report which I working on has ~20 tabs. There are 3 Global filters. Right now my client is sharing this report to his clients via URL. This URL contains the company name of each client every time. ( so this is unique for every client and every client has access to his data ) On the Report, one of global filters is filtering based on the client's name (Company Name). The previous Report editor ( before me ) implemented this via a parameter. ( I do not know how )   Task 1) The request that I have to implement is to add on the sharing URL the date period in order to be predifined for the Companies when they open the Report. Task 2) In addition to that my client wants from me to disable the on the report the 2 Global Filters ( Company name, dates flter ) once these two will be defined on the URL Before the user opens the report. I think these two filters can be hidden in order to do their jobs but not be accessible from the users. Most important is the Task 1. I hope that I was clear, but If its a need I can share more detalis about it. Just ask me. 😀   Thanks in advance! My client wants to share it with his clients. ... View more

Hello, I will give what I want to implement with an example below. After this I will give you my two approches. I am working on a 3.4 SAS Viya Platform. EXAMPLE: I have a table (MYTABLE) and this table is promoted on a global caslib (CKCAS). This table contains 10 rows and 5 columns.   MYTABLE column1 column2 column3 column4 date aaa 4567 gtt 44 20210201 aa 5535 faas 44 20210202 fd 23 axv 44 20210203 sd 736 azxq 44 20210204 ghy 9008 feet 44 20210205 lk 3339 wqopp 44 20210206 yj 112 poo 44 20210207 trr 3634 piuy 44 20210208 hrfthr 689 iuyt 44 20210209 rt 2345 uio 44 20210210   The client asked from me to delete a few rows from the table. His goal here is to retain the latest (by column 'date')  5 days. Below is the "desired" table: column1 column2 column3 column4 date lk 3339 wqopp 44 20210206 yj 112 poo 44 20210207 trr 3634 piuy 44 20210208 hrfthr 689 iuyt 44 20210209 rt 2345 uio 44 20210210 IMPORTANT! The table needs to be promoted and accessible from all sessions! Right now, there is a job every day that collects data for the client and append them on MYTABLE. This implementation will not change! APPROCHE 1 cas christos; libname KAPPA cas caslib="CKCAS";   proc sql; delete from KAPPA.MYTABLE where date<20210206; quit; cas christos terminate;   If I execute the code below, will I achieve the goal table? Will the table MYTABLE be promoted after the deletion of the rows?   End of APPROCHE 1 APPROCHE 2 The second approche that I thought is to save the table for memory to hard drive of the server. Procced with the deletion there and then to promote the table again in memory. With code:     cas christos; caslib _all_ assign; casdatalimit=ALL; libname pathtohd '/tmp/tempo_directory/'; libname KAPPA cas caslib="CKCAS"; data pathtohd.MYTABLE; set KAPPA.MYTABLE; run; proc sql; delete from pathtohd.MYTABLE where date<20210206; quit;   proc casutil; load data=pathtohd.MYTABLE casout="MYTABLE" outcaslib="CKCAS" replace promote; run; cas christos terminate;   end of APPROCHE 2 My clients' tables are containing hundredths of millions of rows and the most important is that the tables are on a Production Environment. I think this implementation needs to be in memory. Do you have any better idea? Will any of my approches work? **This implementation needs to be on over 100 tables + these tables updating from SAS jobs daily. So, my second approche seems not the most appropriate. Thnaks in advance,   ... View more