About Albert0

Albert0 · ‎05-23-2020

Thank you. Your suggestion works as I wanted..

Albert0 · ‎05-23-2020

Sorry to trouble you. The format I have in my example is in DD/MM/YY.

Albert0 · ‎05-23-2020

Sorry the format is DD/MM/YY

Albert0 · ‎05-19-2020

Hi Guys, I have some sample data below and wanted to calculate the SUM_TAG column. ID KEY DATE VALUE SUM_TAG 1 A 01/01/20 10 1 2 A 01/02/20 20 1 3 A 01/04/20 30 1 4 A 01/07/20 40 1 5 A 01/11/20 50 2 6 A 01/01/21 60 2 7 A 01/07/21 70 3 8 B 01/08/20 80 1 9 B 01/10/20 90 1 10 B 01/02/21 100 2 The logic on how I populate the column SUM_TAG is first is to group it by column KEY. Once grouped, the DATE value in each row should be within 3 months of the above row. For example, the SUM_TAG of ID 1 and 2 is 1 because the DATE of ID 1 and 2 is within 3 months which is 01/01/20 and 01/02/20. Also ID 3 is has a SUM_TAG of 1 because the DATE value is 01/04/20 which is within 3 months of ID 2 which has the DATE 01/02/20. Starting from ID 5 the SUM_TAG is 2 because the DATE value of the record is more than 3 months to the DATE value of ID 4. I tried using first., last. and lag function to compare the rows but the result is as desired. Can anyone help me? Thanks. Albert0

Albert0 · ‎02-18-2020

Hi @Anand_V , Thank you for your fast reply. I think I understand now. Thanks.

Albert0 · ‎02-18-2020

Hi @Anand_V , Thank you for your prompt reply. I understand from reading the documentation that this will allow me to create an R program and run it in the VIYA Environment to produce result. What if I wanted to run my R program inside R Environment? Do I still need to install the client package in order for the R program to produce the output into VIYA Environment? Thanks. -Albert0

Albert0 · ‎02-17-2020

Hi SAS Users, I am new to SAS VIYA and heard about integration of JAVA, R, Python etc.. to SAS. I would like to ask about outputs of R program going directly to SAS CASLib. I wanted to know what are the requirements if I have run an R program in a different server but I wanted the output of the R program to be accessed directly in VIYA without exporting and importing it to the VIYA server? Can anyone make a suggestion? Thanks. Albert0

Albert0 · ‎11-05-2018

Hi All, I would like to ask how to troubleshoot or what could be the cause of not showing options from Esri maps service? If you are a new User to our VA environment and would like to use Geo Maps on reporting, you need to configure this setting and go to Report Designer > File > Preferences > SAS Visual Analytics Designer > Geo Map. You need to change the Map Provider from OpenStreetMap to Esri and click the Edit button for Esri map service. From there, there should be an options. But since last week the options are not showing. For the old Users who already configured this option is not having a problem loading the ESRI map in their report. - Albert0

Albert0 · ‎08-09-2018

Hi All, I am currently enforcing our row level security using a batch script to grant data access to our User Groups in our company. But we are trying to implement multiple projects that involves granting all our Users to view their own data only. So I come here to ask are the following: * Is it possible that Row level Access can be tied up to our Active Directory, so that when a User log-in it will automatically grants that person to his/her records? * Because our company has 1000+ employees, coding the batch script for each individual would take a lot of effort in testing. Are there any alternative method to implement this? * Next year we are moving to the latest version of VIYA, Are there any new features in future release that will cater this same scenario in order to use the VIYA security at ease? Thanks. Albert0

Albert0 · ‎07-26-2018

Hi All, I experience the error below when trying to migrate my Data Query from development to production : Do anyone know what cause the error and how to fix it? It is working properly in the development. Thanks. Albert0

Albert0 · ‎07-06-2018

Hi All, I would like to ask your help in finding an alternative approach in my problem. Currently, I'm doing my transformation in Data Builder of SAS VA 7.1. I need to convert my code below into a DataQuery. proc sql; create table a as select t1.receive, t1.due, t2.date, t2.value from TableA as t1 left join TableB as t2 on (t1.receive >= t2.date and t1.due <= t2.date); quit; I know for a fact that Data Builder of SAS VA only support equal value joining. Can anyone suggests an alternative way? Thanks. Albert0

Albert0 · ‎05-24-2018

Hi All, I just want to ask if there are anyways to sort a stacked bar chart with by its measure? I have a bar chart below and I want to sort it by its value from 597,276,241,235,101,39 and 35 respectively. I tried breaking the groups by creating 4 measure that each represent 1 stack but I can only sort 1 stack or measure at a time without sorting the whole bar. Thank you! -Albert0

Albert0 · ‎04-16-2018

Hi, I'm working with the URL parameter of SAS Viewer and I want to remove the SAS Visual Analytics Banner and I found a way using the reportViewOnly = true. But the print report or the menu is also remove. Are there anyway to retain the Menu and remove the SAS Banner? Thanks. Albert0

Albert0 · ‎03-20-2018

Hi All, I'm trying to create a query in Data Preparation of SAS VIYA 8.2 and I want to distinct or make a unique records of my column. But unfortunately I can't find a tick box or built in transformation. Unlike SAS VA Data Builder it has an option on the target table to make the records unique. Below are the only transformation I can find on the options. Do someone knows where can I find this option on VIYA? -Albert0

Albert0 · ‎03-06-2018

Hi ChrisNZ, Basically, the housekeep program that I made is to delete all LASR tables that are not used anymore and backup all the LASR table by creating a SAS datasets counterpart of the table. BTW, I've found a solution to call and delete the table in my sas code by adding string literal n to the table name or macro. E.g. Summary Table 1 => 'Summary Table 1'n. Albert0

Online Status	Offline
Date Last Visited	‎05-23-2020 11:52 AM

Re: Summation of comparison of dates within Rows

Re: Summation of comparison of dates within Rows

Re: Summation of comparison of dates within Rows

Summation of comparison of dates within Rows

Re: R Integration to SAS VIYA

Re: R Integration to SAS VIYA

R Integration to SAS VIYA

ESRI Map Option not showing on VA 7.1

Row level Access tied in Active Directory

Error in deploying data queries in SAS VA 7.1 Data Builder

Re: Do Loop Dates macro

Re: Do Loop Dates macro

Re: SAS VA User Access Information

Re: Programmatically start/stop SAS VA LASR server issue

SAS VA Migration from 7.1 to 8.1

Error in deploying data queries in SAS VA 7.1 Data Builder

Re: SAS VA Migration from 7.1 to 8.1

Re: Do Loop Dates macro

Re: Summation of comparison of dates within Rows

Re: Summation of comparison of dates within Rows

Re: Summation of comparison of dates within Rows

Summation of comparison of dates within Rows

Re: R Integration to SAS VIYA

Re: R Integration to SAS VIYA

R Integration to SAS VIYA

ESRI Map Option not showing on VA 7.1

Row level Access tied in Active Directory

Error in deploying data queries in SAS VA 7.1 Data Builder

SAS VA 7.1 Data Builder Range Join

Bar Chart sorting by Group

Working with Parameterized URL SAS VA 7.1

How to distinct values in SAS VIYA Data Prep

Re: Delete LASR Table with Special Character