Hi Sspakh,   I am getting an exact error as follow. I want to know that did you find out any solution on the same.   Please assist me.   Regards, Sunny ... View more

Please follow the 2nd page of my tag message. Already explained and attached the snapshots and video for your reference. ... View more

69 data _null_; 70 set sashelp.vmember(keep=libname memname where=(libname='Maps')); 71 call execute(catt('data work.',memname,';set x.',memname,';stop;run;')); 72 run; NOTE: There were 0 observations read from the data set SASHELP.VMEMBER. WHERE libname='Maps'; NOTE: DATA statement used (Total process time): real time 0.12 seconds cpu time 0.12 seconds     I'm not getting any observations from this code. ... View more

59 data _null_; 60 set sashelp.vcolumn (where=(libname="Maps")); 61 by memname; 62 if first.memname then do; 63 call execute('proc sql; create table work.'||strip(memname)||' ('); 64 call 64 ! execute(strip(name)||ifc(type="char","CHAR("||strip(put(length,best.))||")","NUM")); 65 end; 66 else call 66 ! execute(","||strip(name)||ifc(type="char","CHAR("||strip(put(length,best.))||")","NUM")); 67 if last.memname then call execute(');quit;'); 68 run; NOTE: The map data sets in library MAPSGFK are based on the digital maps from GfK GeoMarketing and are covered by their Copyright. For additional information, see http://support.sas.com/mapsonline/gfklicense. NOTE: There were 0 observations read from the data set SASHELP.VCOLUMN. WHERE libname='Maps'; NOTE: DATA statement used (Total process time): real time 12.31 seconds cpu time 1.10 seconds     I'm not getting any observations from this code. ... View more

Hi Madelyn, Actually, I need to make a dataset for SAS Visual Analytics Users login and logout details daily, weekly, monthly and yearly. Like Sno.   Username      login_time                     logout_time                     Attempted 1         Sunny           13/06/2017 16:09:10     13/06/2017 18:09:10      Successful login 2         Kumar           12/06/2017 20:09:10                                            Unsuccessful login -------------------------------------------------------------------------------------------------------------------------------   Is it possible to create a dataset like this with more details of login and logout? ... 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

Hi Linush,   There are only three specifics interval i.e _ByMonth_, _ByQuarter_, _ByYear_ but there were no any _ByDay_ interval option available.   ... 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