Hi Is there any way the range slider date control can get automatically refreshed. We update data daily for the previous day. So supposed I view my report today, I have to manually click on the range slider (the small clock icon) and choose the rigth hand side date as 20th Nov. I save the report. When tomorrow I login, again I have to choose the right hand side clock date as 21st Nov. I want this to happen automatically. In other words as soon as the data is refreshed and I log into the report I should see the end date (meaning the right hand side clock date) as 21st Nov, instead of having to manually choose it. Thanks Manish ... View more

Hi I need some help with dates. I have put up the range slider date controls however I want it in a way such that whenever I open the report, it should automatically show me the data for the last 7days or for last 7 months (in monthly reports). Can anyone let me know the code for this? Also is there any other alternative for date controls other than the range slider (I feel it occupies too much space). Thanks Manish. ... View more

    Hi Please see the attached snapshot. I need to do conditional formatting (display rules) on the fields In_time, Out_time and login hours. I cannot convert them to numeric as there are other problems occuring then. Cross Tab report does not allow display rules on category variables but only on numeric. Thanks Manish ... View more

Hi I need to remove [" from the word say ["Mumbai"]. I am able to remove the [ and ] using functions like Tranwrd however I want to know how to remove the " as the function syntax itself has an opening " and a closing " and I am unable to remove the " (which is itself a part of the input). SAS does not seem to be accepting the " within the opening " and closing ". I will appreciate any help. Thanks Manish ' ... View more

Hi Need some urgent help in EG. I wish to send automated email reports (with excel attachment) to our top 200 customers - report will have data such as their last purchase date, amount, etc. I have a dataset that consists of data related to these top 200 customers. I want to make a program that loops through every record (one record for every customer) in the dataset, creates a list report in EG, and then pastes that list report in Excel and send it through email (outlook) to the customer. This entire process should be automated in EG. I know Base SAS language but do not know Macro programming. Can anyone please help me? It will be great if someone can help me with the code. Thanks Manish ... View more

Hi Is there any way SAS VA can automatically adjust to the user's screen resolutions. I have made the reports in my laptop with a screen resolution of 1600 * 800 and the reports are working fine. However, some parts of the screen appear hidden/do not appear properly in the screens of some users that have a lower resolution system (that cannot be increased to 1600*800). For some users, it works fine. I cannot keep changing the reports.... Is there any solution in VA whereby it automatically takes the screen resolution into account and displays the reports correctly. Thanks Manish ... View more

Hi I need some urgent help on an aggregate measure. I have an MTD report that shows data like 1st to 22nd April, 1st to 22nd March, 1st to 22nd Feb, 1st to 22nd Jan and likewise. It is an MTD like-for-like period monthly comparison report. In my company we upload data daily for the previous day. Please see the attached screenshot. In this aggregated measure, I want to know how instead of manually changing the date every day, I can set the date formula so that it automatically considers yesterday's date. PS - There is another option in the field and that is TODAY however if I choose this option, figures will not appear correctly as for April (assuming I run the report today 23rd April) it will show data from 1st to 22nd April (as mentioned above we have data till yesterday 22nd april in our servers) but for Mar and preceding months, it will show from 1st to 23rd instead of 1st to 22nd. Please...any help will be appreciated. Thanks Manish ... View more

Hi I have a report in which I have names of customers and I DO NOT want to show their contact numbers together. I want that the user should click on the agent name and another smaller link report should appear that should show me the contact number of only that customer. Is it possible in the current version of SAS VA (I am using 6.3 and will install the version 7 when it arrives). What I am hinting is at a parameter pass through mechanism or any other solution that can be worked out. Thanks Manish ... View more