It's been years but still no promising & exact answer to this problem... I have tried parsing the SAS Metadata logs but it could not provide me the logout timing for the user who logged in to SAS VA.   Have look at below log statements- 2022-12-14T17:33:38,935 INFO [36904070] :USER1 - New client connection (300281) accepted from server port 8561 for SAS token user USER1. Encryption level is Credentials using encryption algorithm SASPROPRIETARY. Peer IP address and port are [::ffff:172.25.85.35]:49844 for APPNAME=Visual Analytics Viewer 7.5.   2022-12-14T17:33:38,954 INFO [36904085] 300281:sas - Client connection 300281 for user USER1 closed.   How can the user be logged out in less than a second? How to get the correct logout information from the logs.   I have tried Environment Manager Reports APM/ACM etc. but it doesn't give the desired information & output.   Thanks in Advance ... View more

Hi: It might be more productive for you to open a track with SAS Tech Support. They will need to know some information about your installation and the folder path for the stored process you want to call with PROC STP. In our Stored Process self-study class, here: https://support.sas.com/edu/schedules.html?crs=YSP2&ctry=US we have an example of using PROC STP and for our system, we needed to know the metadata user and metadata password in order to connect to the metadata server BEFORE invoking PROC STP. In addition, we had to know the exact metadata folder path for the stored process value for the program= option. Here's our class example, as shown below: You might be able to get this information from your Platform Administrator or you might need to work with SAS Technical Support on this. Cynthia ... View more

With a modern version of SAS you could add the TRIMMED keyword to make sure the generated macro variable did not contain leading spaces.   So let's make a sample dataset with a datetime variable. data test; start = datetime(); format start datetime19. ; run; Now let's query that to get the raw number of seconds since 1960 into a macro variable. proc sql noprint; select start format=32. into :start trimmed from test; quit; Results: 20 %put &=start; START=1928747688 ... View more

can you please send me the details how to do Re: Dependency between drop down list .last step i didnt understand.i am new to sas ... View more

Library name should be upcase.   libname='MAPS'   also change ;set x.',memname into ;set maps.',memname ... View more

@Madelyn_SAS,   FYI, there is no distributed LASR server on Windows.   @vtodorov,   >> Ocasionally our LASR servers are crashing. Even they are stopped , the PID files are still not automaticlly deleted Most likely LASR servers have been crashed because you stopped/restarted either the object spawner or middle tier. In order to avoid that, use the autoloading process for starting LASR servers. ... View more

Hi Guys,   Sorry for the delay but I found the solution, what I did.   First, I took Slider for "select date" for single value   Then I took drop-down list object for the same date but converted in character format. You know very well that Drop-Down list object can't take Date/Datetime. So, for that reason, I converted the same date into character format and assign to drop-down list and create a parameter (Full Date_Char Parameter) to pass value.   And the right side panel, select "Required" option and create interaction between these two objects Slider and Drop-Down list.     Then I take a list table to display a revenue value.   Now, Select the same list table and go to right side panel "Filters" tab and click on "Add Filter" and create      Now what I'm doing here Let an example:-   We're going to take the same date : 23-Sep-2016 (an example Numeric value of the date- 206)     Pass the drop down list value which is a parameter (Full Date_Char Parameter) in the Parse function convert the character to Date format and then TeastAs function convert Date to numeric format.    you'll get value - 206   DayofMonth function converts the date to Day and then subtract by 1.     you'll get value from this formula:- (23 -1) = 22.   Subtract these two values and get the start of the month date..     Value :- 184 (1-Sep-2016)   The betweeninclisive function gives the range.   184 to 206 (1-sep-2016 to 23-sep-2016)   Through this the way you can get the date from the start of the month date to till selected date. Regards, Sunny Kumar Gupta ... View more

Day-wise interval can be used when your inner interval is set to _Inferred_.   However, as I understand it there are some technical issues calculating day-wise data over time. If your operator has an offset (like your example with RelativePeriod would have) then we return missing values.   I think this is something we are working to improve for the future.   Thanks, Sam ... View more

Actually, my first question was how to pass multiple values in a parameter in SAS VA? But if I haven't got any solution from SAS expert advisor that's why I tried to resolve my issue from "IF ELSE" operator but still I didn't got the value from this then I thought that maybe there were any tips and tricks to resolve this issue then I wrote this question " is there any loop function in SAS Visual Analytics?". So tell me is there any solution of my question?   Regards, Sunny Kumar Gupta ... View more

Hi Bailey,   I know very well that but i'm asking, is there tips and tricks to used same value for 2nd New Level?   Regards, Sunny Kumar Gupta ... View more