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
I have a variable has values like 0,100 miles, 200 miles,3000 miles. I want to remove the miles part. I used substr function. Miles_new=substr(miles,1,length(miles)-5) However, it gave me the error Character has been converted to numeric values and Invalid numeric data. How can I fix 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
Hi All, I want to build a log linear variance model and test the slices for the interaction term. I know I can use the proc genmod procedure. However, it only gives me the plot of slices test. I am thinking that whether I can use proc mixed procedure to build the log linear model? anyone knows how to do that? Thanks!
... View more