SAS Support Communities

Hi,    This could well be a dumb question but I am unsure and cannot find the answer online. I use SAS EG at work but I wish to learn Base SAS to expand my skills.   What is the best way to do this? I am writing as many manual programs as possible, rather than using the query builder, but I realise EG is still doing a lot of things I would have to code manually in Base, and I want to learn Base as comprehensively as possible.   Any advice would be appreciated.   Thanks   ... View more

Hi,   I have a feeling the solution I'm hoping for doesn't exist/isn't possible, but here goes:   - I have a dataset with 21 variables, one of which is ACTIVITY_TYPE which has 5 possible values - 1/2/3/4/5 - I want to look at all of the other variables against ACTIVITY_TYPE - what are the proportions of their responses across ACTIVITY TYPE? - EG; one of the variables is 'Organisation' - A/B/C/D. I want to see for each of A/B/C/D what % is ACTIVITY_TYPE 1/2/3/4/5 - I have used PROC FREQ to get such a one way frequency analysis (it is only the 'col pct' and 'frequency' that I am interested in) - I know I can use PROC FREQ to output multiple tables showing the results, but I will then be left with manual process to bring them together in one table   - Is there any way to shorten this? I am using EG.   Any advice would be appreciated.   Thanks  ... View more

Hi,   I have a table which is a list of transactions, with customer numbers and products.   I want to group transactions by customer and month and find the months where volume changes >10% vs the last month they transacted (which may be several months before).   Ideally the output would show Customer, Month, Volume, Change vs Last Month Traded.   I am very new with SAS and have no idea how to do this, any help would be great.   Thanks   Jamie ... View more