Hi Everyone,   I have a data set and I want to get the accumulative 25%,75%, 50% quantiles for several variables. That is, for every row, I want to get the quantiles for the column including all the data before that row. Anyone knows how to do that?   Thanks!   ... View more

Hi All,   I have a large dataset and I want to do the interpolation for each group based on four variables. I have split the datasets into multiple datasets. Each dataset is a group that I will do the interpolation. However, I still need to get the number of observations for each dataset and save them as macro variables in order to do the interpolation.   Attached is my SAS code. My macro variable macvar&i is not resolved and don't know is there anything wrong with my code.  Anybody can help with that? Thanks!!!       ... View more

Hi All,   Attached is part of my datasets.  I want to split the dataset into multiple datasets based on the Group, Product, Condition. Any suggestions? Thanks! ... View more

Group Product Condition Y           Group 1 A 10 -2           Group 1 A 10 -1           Group 1 A 20 0           Group 1 A 20 1           Group 1 A 20 2           Group 1 A 30 -19.5           Group 1 A 30 -18           Group 1 A 30 -16.5           Group 1 A 30 -15           Group 1 B 10 -14           Group 1 B 10 -13           Group 1 B 20 -12           Group 1 B 20 -11           Group 1 B 20 -10           Group 1 B 30 -9           Group 1 B 30 -8           Group 1 B 30 -7           Group 1 B 30 -6           Group 2 A 10 -2           Group 2 A 10 -1           Group 2 A 20 0           Group 2 A 20 1           Group 2 A 20 2           Group 2 A 30 -19.5           Group 2 A 30 -18           Group 2 A 30 -16.5           Group 2 A 30 -15           Group 2 B 10 -14           Group 2 B 10 -13           Group 2 B 20 -12           Group 2 B 20 -11           Group 2 B 20 -10           Group 2 B 30 -9           Group 2 B 30 -8           Group 2 B 30 -7           Group 2 B 30 -6           Hi All,   Part of my datasets is like above and I want to split my dataset into multiple dataset based on group, product and condition.   For example:               my first data set will be:             Group 1 A -2             Group 1 A -1                               my second data set will be:                               Group 1 A 0             Group 1 A 1             Group 1 A 2                               How can I achieve that?                               Thanks!                                                                       ... View more