Yes Sam, I am created the link in IDP as Application. I wish SAS can add VA portets just like dashboard portlet. ... View more

Thanks Sam, I am able to get the report link that way, and posted it to the IDP. Using Shift key to open the link in new window works for now. If someone opens the link without pressing shift key is not taking back to the portal page. Hope this got fixed in future releases. ... View more

Hi Sam, I know this thread is couple of months old. I have similar issue. I am trying to add a VA (version 6.4_M1) report link to the SAS portal. Is it possible to get individual report link? if so, how to get the link from VA report and then add it as URL or create link as application. I tried to add URL as external link as suggested on SAS VA documentation, when I tried to open the link, I got error on the page saying SAS server cant accept this connection. Thanks in advance, Jit. ... View more

Thanks again Art, The code is working great. This is what I needed. Thanks, Jeeth. ... View more

Hi Art, Sorry if I wasn't clear. This is what I am getting with the current logic I have: ID            DOS                                          EOS                                             FLAG 1             06JUN2008:00:00:00                  17JUN2008:00:00:00                         1   1             17JUN2008:00:00:00                   27JUN2008:00:00:00                        1 2              25FEB2009:00:00:00                 03MAR2009:00:00:00                        3 2             04MAR2009:00:00:00                  25AUG2009:00:00:00                       4 3              01SEP2009:00:00:00                 14SEP2009:00:00:00                        5 4             11SEP2009:00:00:00                  19SEP2009:00:00:00                        5 This is what I need. 1             06JUN2008:00:00:00                  17JUN2008:00:00:00                         1   1             17JUN2008:00:00:00                   27JUN2008:00:00:00                        1 2              25FEB2009:00:00:00                 03MAR2009:00:00:00                        2 2             04MAR2009:00:00:00                  25AUG2009:00:00:00                       2 3              01SEP2009:00:00:00                 14SEP2009:00:00:00                        3 3             11SEP2009:00:00:00                  19SEP2009:00:00:00                        3 3           25SEP2009:00:00:00                29SEP2009:00:00:00                     4 There are multiple id's with different dates. I need to flag/group them based on ID and also the service start (DOS) and end dates (EOS). If the EOS of a previous record is same as the next record of DOS in bold, I need to group them together (Bolded dates). Your logic took care of this. I am not able to figure out the flag where the EOS has ended the previous day (03Mar2009) and next service for same ID has started very next day (i.e. on 04Mar2009). I am unable to figure this out. First two dates of ID 3 are overlapping. So, I need to flag them together. flag needs to be incremental based on these conditions. When a service is neither overlapping or continuous then count it as separate flag. Please let me know if I am still not clear. Code I have so far: data want;     set temp;     by ID ;        if first.ID and first.DOSand first.EOS then do;       flag=_N_;     end;      retain flag ;           flag=ifn(first.ID,_N_,             ifn((DOS <> EOS)and DOS le lag(EOS)+1 ,flag,flag+1)); run; if I have this flag=ifn(DOS le lag(EOS)+1,flag,_N_); then the counter is skipping the numbers if they are repetitive as below. 1 1 3 3 5 6 Thanks, Jeeth. ... View more

Hi Art, I do have to tie the IDs to the service effective and end dates. everything looks fine but my requirement is when the dates are overlapping or continuous, I need to tie the IDs based on that. I need: ID            DOS                                          EOS                                             FLAG 1             06JUN2008:00:00:00                  17JUN2008:00:00:00                         1    1             17JUN2008:00:00:00                   27JUN2008:00:00:00                        1 2              25FEB2009:00:00:00                 03MAR2009:00:00:00                        2 2             04MAR2009:00:00:00                  25AUG2009:00:00:00                       2 3              01SEP2009:00:00:00                 14SEP2009:00:00:00                        3 3             11SEP2009:00:00:00                  19SEP2009:00:00:00                        3 3            25SEP2009:00:00:00                 29SEP2009:00:00:00                      4 In this flag is 1 fro ID 1 because, both the dates are continuous. Similarly, ID-2 dates are continuous as well. ID-3 first 2 lines, dates are overlapping therefore, same flag. As the last line is neither continuous nor overlapping, so it will have flag 4. Only ID-2 is not getting resolved regardless of what I try. If the flag numbers are continuous it would be great. Thanks, Jeeth. ... View more

Hi Art, Your logic is working perfectly. Thanks again for your suggestion. I have one small issue though. When dates are continuous like below. I still need to group them as one. I tried it couple of ways, but its still not working for me. I need ID 2 as counted as 2 and 2 when the dates are continuous. ID            DOS                                          EOS                                             FLAG 1             06JUN2008:00:00:00                  17JUN2008:00:00:00                         1    1             17JUN2008:00:00:00                   27JUN2008:00:00:00                        1 2              25FEB2009:00:00:00                 03MAR2009:00:00:00                        3 2             04MAR2009:00:00:00                  25AUG2009:00:00:00                       4 3              01SEP2009:00:00:00                 14SEP2009:00:00:00                        5 4             11SEP2009:00:00:00                  19SEP2009:00:00:00                        5 I changed my logic to : data want;     set temp;     by ID ;         retain flag ;           flag=ifn(first.ID,_N_,ifn((DOS <> EOS)and DOS le lag(EOS)+1,flag,flag+1)); run; Please let me know how to fix it. I tried changing DOS le lag(EOS)+1 to DOS ge lag(EOS)+1. Its completely changing counter value. Thanks, Jeeth. ... View more

Hello Art, Thanks for the quick response. Actually I also have to group the ids when the dates are overlapping and only increment the counter when the dates are not continuous and/or overlapping. My logic took care of the overlapping part but not when dates are continuous. I will incorporate your logic in my code and let you know how it goes. Thanks, Jeeth. ... View more

Hello Rick, Thank you very much for your response on this. I agree with you 100%. Its the issue with the data . I will let you know how it goes. Thanks, Jeeth. ... View more