Hi all,   I am trying to work on an ensemble model, one of which being an auto regressive model. I have a grouping variable(ID) and I am not sure what the difference is between the Class and By statements for this proc. I have only been able to find information on the difference in other procs(a lot of proc means).   If someone could explain how the class statement would effect my output that would be great!     ... View more

Hi, I was wondering if SAS can be used on a cloud based server on an iPad. Additionally, if anyone has a review of how it run, looks, etc. that would be great! ... View more

Hi,  I am stuck on a problem where I need to find how many accounts make up the top 25% of sales by region.   Right now I have the data in this format: Region     Account     % of Regional Sales     Running total of % of Regional Sales     Count New York      "Name"         12.5                            12.5                                                        1 New York      "Name2"       10                                22.5                                                        2 ... There are multiple different regions.   What I need to do is figure out which observation pushes the running total of % above that threshold of 25% and then output the count variable for that observation. IE I am trying to find out how many accounts it took to get 25% of the sales for the New York region. Then the same for each subsequent region.   Thanks! ... View more

Hi,   I am trying to create a flag for the top N values in my dataset by region.   Right now I have the total amount of sales for each account and I need to find the number of accounts that make up the top 25% and top 50% of sales for the region they are in. The output I am looking for would be the dataset with a flag on the end that says whether or no this account is part of the top 25% of sales, top 50% of sales or neither.   When I say this I do not mean that this account accounts for 25% of the sales itself, rather this account and the subsequent accounts make up 25%.   I tried sorting by region and sales which gives me a list that looks like this: Region1 Account1 100 Region1 Account2 75 Region1 Account3 12 ... I then found the % of sales each account is responsible for in their region. Now I am stuck on aggregating the percents from top to bottom ... View more

Hi,   I have 2 datasets that do not share any variables. One has 100(cats) observations and the other has 1000(dogs) observations. I would like to create a new dataset where each of the 1000 dogs gets all of the data from each of the 100 cats appended onto it.   The final dataset would have 100000 observations and would look like this:      1. Dog1 <variables from dog1> <variables from cat1>      2. Dog1 <variables from dog1> <variables from cat2>      3. Dog1 <variables from dog1> <variables from cat3>      ...  101. Dog2 <variables from dog2> <variables from cat1>      ...   Any help would be appreciated! ... View more