Hello,   I'm using SAS 9.4 and SAS Visual Analytics 7.1 on Windows. I have tables in SQL Server that I'd like to register for data sources. I have successfully registered tables using SAS Management Console (SASMC). However, since access to server is limited, registering tables via web SAS Environment Manager (SASEV) was considered.  Been trying to register tables via SASEV, but the tables didn't appear, no available tables to be registered. The tables appeared in SASMC. I used the same user login in SASMC and SASEV.  What do I miss here? Please help.     ... View more

Hello,   Is there any way in SAS VA to get value from the previous date (one day before), for example from this table: -------------------------------------------------------- |    Date   | Company Name | Trx Value | Trx Value D-1 | -------------------------------------------------------- | 01Jun2016 | ABC          |    10,000 |               | | 01Jun2016 | DEF          |    11,000 |               | | 01Jun2016 | XYZ          |    12,000 |               | | 02Jun2016 | ABC          |    33,000 |        10,000 | | 02Jun2016 | DEF          |    44,000 |        11,000 | | 02Jun2016 | XYZ          |    55,000 |        12,000 | | 03Jun2016 | ABC          |    60,000 |        33,000 | | 03Jun2016 | DEF          |    70,000 |        44,000 | | 03Jun2016 | XYZ          |    80,000 |        55,000 | -------------------------------------------------------- The Trx Value D-1 is New Calculated Item that I would like to get.   Regards, Karina ... View more