Hi All, I have a dataset of store IDs with its performance related to Customer enrollment. I am running a reward program for around 150 stores for getting customer enrollment with  proper customer data. Stores are encouraged to do customer enrollment for loyalty program but many stores didn't collect all required details, such as Mobile no, Email id, communication preferrence , gender, date of birth. a sample data row looks like this--   Store id- 0001 Count of Enrollment- 1200 % of customer Mobile number present= 85% %of Email present=90% %of dob mentioned= 82% % of gender mentioned= 80% %of communication preference mentioned= 70%   total record count (/stores) = 150   so, we have to decide on what weightage to give on each variable and then come up with a solid logic to rank stores.Finally top10 and bottom 10 leader board is intended.   What analysis, logic/ statistical procedures should I be using?   Thanks for reading this. please reply. ... View more

Dear members,  I have created a dashboard in SAS VA, it has multiple tables and graphs. some table has a scroll bar to view entire data. But, when I am trying to save a particular table (in report Viewer mode), in image format, its only  saving the portion that is visible no the entire table data. How to resolve this?  My users will need to save full image of any table that is there.    Regards, Partha   ... View more

I have a report with customer ID, customer Name, and account count field.. i have inserted a cross tab to display customer Name wise  account count. It has more than 1000 records (rows). Now i wast to insert a input field, where user can type/paste a set of names (e.g. Alfed,Carol, Henry) and the corresponding value should appear there in cross tab or graph.  I have already tried 'Text-input' option but it could take only one value to filter, not taking multiple.    We would like to paste set of customer name or upload a excel/csv file to filter out the report in the view. User can accordingly view interested record and download if needed.    you may consider below data for example... and need a filter button on dashboard of SAS VA to filter data by names.     data WORK.CLASS(label='Student Data'); infile datalines dsd truncover; input Name:$8. Sex:$1. Age:32. Height:32. Weight:32.; datalines; Alfred M 14 69 112.5 Alice F 13 56.5 84 Barbara F 13 65.3 98 Carol F 14 62.8 102.5 Henry M 14 63.5 102.5 ;;;;   Regards, Partha  ... View more