Would't it work with last on the date as well? ... View more

Hi! Why use a slider at all? For me it seemes better to use a parameter connected to a text box and then use that parameter in a filter. Wouldn't that get what you want?   Otherwise you could try to achieve this by using parameters and linking with "help" objects so that you filter data in several steps. I did som testing but lacking time to give you an example 🙂 ... View more

If I get you right 🙂   You can use the EG-macro:   proc sql; select * from sashelp.class where %_eg_WhereParam( sex, kalle, IN, TYPE=S, IS_EXPLICIT=0 ) ; quit;   Kalle is the name of my prompt, sex is the variable in sashelp.class.   You can also resolve the macrovariables your self, but then you need some macro coding. https://communities.sas.com/t5/General-SAS-Programming/Do-loop-using-a-prompt-generated-macro-variable/td-p/82348 ... View more

I don't fully understand why you need a stored process, are you using SAS EG? If so you can use a dynamic prompt. By default you can search for values using that prompt 🙂   Sorry 'bout the swedish, hope you get it. //Fredrik   ... View more

Maybe you need to use session variables, could be so that there is a new session for each step you have. Check this link, I have succesfully used sessions in some of my web applications.   http://support.sas.com/rnd/itech/doc9/dev_guide/stprocess/sessions.html   //Fredrik ... View more

Why not just using the tabs that already exist? 🙂 There is a way to create "buttons" with links, create a heat map with a custom category with only on value (this value is shown on the "button") and assign it to the heat map. Then create a link from the heat map to the desired tab. ... View more

I think the fastes and easiest way is to do some dataprep in a data step before you load the data into VA. Then you can handle for example time gaps and other "defects" in your data. With retain and firs/last you will get full control 🙂 //Fredrik ... View more

Create a custom HTML input form where you have full control 🙂   http://support.sas.com/kb/37/050.html ... View more

How about some more macro....:)   %macro showName(_name); %put Actual name: &_name; %mend;   %macro t; /* open table */ %let dsid = %sysfunc(open(sashelp.class));   %if (&dsid) %then %do; /* iterate over the rows */ %do %while(%sysfunc(fetch(&dsid)) ne -1); %let name = %sysfunc(getvarc(&dsid,%sysfunc(varnum(&dsid,name)))); %showName(&name); %end; /* close table */ %let _rc = %sysfunc(close(&dsid)); %end; %mend; %t;   ... View more

Maybe loading the dataset into memory can help you (SAS(R) 9.2 Language Reference: Dictionary, Fourth Edition). It might help whn you read it multiple times.... ... View more

hmm, like this....:) proc sql; create table res as select * from (select *, id_group as id_group_new from kk.test)   union   ( select a.*,b.id_group_new from kk.test as a    inner join (select *,id as bid,id_group as id_group_new from kk.test where id_group eq 10) as b        ON      b.date_consensus             >      a.date_forecast                 AND     b.date_forecast_minus90d      <=    a.date_forecast_confirmation        AND     b.date_forecast_minus90d      >=    a.date_forecast     and a.id_group eq 1 ) union ( select c.*,d.id_group_new from kk.test as c    inner join (select *,id_group as id_group_new from kk.test where id_group eq 100) as d        ON      d.date_consensus             >      c.date_forecast                 AND     d.date_forecast_minus90d      <=    c.date_forecast_confirmation        AND     d.date_forecast_minus90d      >=    c.date_forecast     and c.id_group eq 1 ) ; quit; ... View more

Something like this??? data test_new; set test; match = 0; /* id 10 */ if  date_consensus (26.01.1998) > date_forecast (07.10.1997)     and date_forecast_minus90d (28.10.1997) <= date_forecast_confirmation (16.01.1998)     and date_forecast_minus90d (28.10.1997) >= date_forecast (07.10.1997) then do;       id_group_new = 10;    match=1;    output; end; /* id 100 */ if  date_consensus (27.01.1998) > date_forecast (07.10.1997)     and date_forecast_minus90d (29.10.1997) <= date_forecast_confirmation (16.01.1998)     and date_forecast_minus90d (29.10.1997) >= date_forecast (07.10.1997) then do;       id_group_new = 100;    match=1;    output; end; /* original post if not met by any condition above */ if match eq 0 then do;   id_group_new = 1;   output; end; run; ... View more

Something like this..... proc sql; select distinct var2 into :var2values separated by ' ' from temp where var2 ne . ; select var1 into :missvar separated by ' ' from temp where var2 eq . and var1 in (&var2values) ; quit; data out; set temp; if var2 in (&missvar) then var2 = .; run; //Fredrik ... View more