Hi all, I'm very much a newbie with EG so applogies if this is something obvious, I'm trying to use EG to create a userdefined format from a dataset. My dataset is two date columns, I want to use the second as the label, however I keep getting the error - Variable label has been defined as both character and numeric. The dates are fien so I cant figure out what I'm doing wrong. My settings are: Any help appreciated
... View more
@CameronF My SAS contact has given me a possible way of achieving this, I have only had a chance to test very briefly so there may be a gottcha I've not hit yet but it seems to work at a simple level at least. Instead of creating an aggregated measure as the first step, duplicate your base measure and set the default aggregation to what you need it to be. Create a new aggregated measure and use the duplicate measure created above In my test I used a very simple data set to test an average of an average that also allows me to filter and group dynamically
... View more
It sounds like you want to automate the production of a chart for every combination of variables? If so SAS VA can't do this itself, as a work around it is possible to automate your browser via a script, somethiing like the link below may help http://www.howtogeek.com/113789/how-to-automate-repetitive-web-browser-tasks-with-imacros/
... View more
There are some online demos for logistic regression, decision trees and clustering using visual statistics here - http://www.sas.com/en_us/software/analytics/visual-statistics.html
... View more
This type of analysis is usually trying to identify combinations of categorical measures (age, gender, ethnicity etc) that predict a binary outcome (retained or not retained) logistic regression could be one suitable statistical techinque but I guess you would need to have the visual stats add on for that.
... View more
Have you created an aggregated measure? (click the arrow to the right of the bin symbol and select aggregated measure) Will look something like Sum [_ByGroup_] ('measure_name'n) in the text view
... View more
You will probably need to join the two tables outside of the report/exploration tools. VA has a data preperation tool that can do simple joins and manipluations of source data to create datasets that can then be used in reports. If the join is more complex you could use one of the other SAS tools like data integration studio to process or you could potentially carry out this step in the data source itself (we are using SQL Server to store and pre-process most of our data) Alternativley VA does support star schemas so if your second table is has a straightforward one to many join you could possibly link to it like that.
... View more
As a new VA user I have been reading this thread with interest, I've been a bit supprised by VA's lack of functionality in this area, forcing the user to pre-process the data seems to go against the advertised purpose of allowing non technical users to analyse data. "Self-service, ad hoc visual data discovery and exploration put lightning-fast insights within everyone's reach." Tableau has LOD & table calculations that give it this kind of functionality and even bog standard MS Excel can leverage DAX through power pivot to aggregate 100 million + rows to any level on the fly. The one advantage I can see of the SAS approach is that the final reports will be less complex for users (I guess it also stops VA canibalising the market for other SAS products)
... View more
Hi, Yes the grade will be categorical A sample of the data could be Staff_ID, Gender, Grade 1,M,G10 2,M,G8 3,F,G9 4,F,G1 Yes I did pick the butterfly example with no changes. Thanks
... View more
Hi All, Another newbie question I'm afraid! I was trying to create a butterfly chart in VA, I manged to create the chart using graph builder but got stuck at defining measures. My data is very basic: Staff_ID, Gender, Grade I want one side of the chart to show male and the other female. How do I create a male and female measure? (Grade will be the category) In MS Power BI I would just do calculate(counta(staff_id),gender="male") and that would create a measure that shows a sum off all males based on the context of the chart/table. Many thanks Phil
... View more
There was an interesting presentation at the UK SAS forum recently http://www.sas.com/content/dam/SAS/en_gb/doc/other1/sas-forum-2016/presentations/paul-johnson-sopra-steria-wednesday-28th-september.pdf
... View more
I'm a noobie with zero SAS VA experience so can't help with technical fix, however is it feasible to add one row of data that everyone can see and set the filter to that? As your not creating a grand total it shouldn't affect your other data Not ideal but may get you up and running
... View more
Hi all, We are new to VA and are looking at migrating a reporting tool from a legacy system as our first test of the system. One of the requirements is for users to create PDF output so that reports can be printed and taken to meetings or taken home for analysis. The reports in question cover module performance by students, the reports will be at module level and each have a number of graphs/analysis, there can be up to 300 modules per department and these will be subject to regular change, Is it possible to "paginate" VA reports so that all reports for a single department can be put into a single PDF? Any advice on how to approach this would be appreciated, I'm concious this may be slightly against the spirt of VA but its important for us to impliment a solution that combines interactive self service with the ability to also bulk export to cater for users/situations where manually selecting a module through a reporting tool is not practical.
... View more
Thanks for the help guys, I have a better idea now around where I was going wrong (especially whilst trying to use sasadm incorrectly). I have changed the permisions and now seem to be making some progress. One of my problems is that we have 2 licence files, I can only find how to apply one at a time so some aspects of the functionality are not working, I'll contact SAS about that (unless anyone knows how to apply two sid files?)
... View more
