My data set looks like this
10001_t 10001_C1 10001_C2 10001_C3 10001_C4 10002_t 10002_B1 10001_B2 10001_B3
value1 value2 value3 value4 value5 value6 value7 value8 value9
value10 value11 value12 value12 value14 value15 valu16 value17 value18
value19 value20 value21 value22 value23 value24 valu25 value26 value27
value28 value29 value30 value31 value32 value33 valu34 value35 value36
Now, I want to divide all the values in 10001_C1 with values in 10001_t , similarly all values in column 10001_C2 will be divided by 10001_t ( which is like the total for that 'C' group, here 10001_C1 is considered as C group) . Division will take place till 10001_C4 column after that the denominator will change ( i.e earlier it was value2/value1 , value3/value1, value4/value1, value5,value1). Now everytime the column name had 't' at the end the denominator will change so when 10002_t comes the denominator will be value_6, so the new table will have percent value in 10002_B1 column as value7/value6, the column 10001_B2 will have vlaue8/value6 and 10001_B3 will have value9/value6.
I know its a bit confusing but it's all I have and would really appreciate if someone can suggest a way to solve it. I don't mind if we divide in same table or create a new one. Also the data set is quite big so the code has be dynamic. will really appreciate any help I can get.
Thanks
Hi, Thank you for your question. May i request you to provide sample data that would help to have something to work with and test please?
If you could please provide the community with a sample input data and a sample of expected output data so that you and the community can test/validate.
Thank you
Since your column names by default are not valid SAS variables show us what the variable names in your SAS data set actually are.
Pick a couple variables, show us actual values and what the actual desired output for those values looks like. Real actual numeric non-trivial (not all 1 or 2) numbers.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.