Hello, I would like to add varname='TotalDaidzeinEquivalents'; value=daidzein ( value)+254.24/416.38*daidzin (value); varname='TotalGenisteinEquivalents'; value=genistein ( value)++270.24/432.38*genistin ( value)+; varname='TotalGlyciteinEquivalents'; value=glycitein ( value)++284.46/446.41*glycitin ( value)+; to the dataset ( simple sample dataset list below, my real data has bunch of other values and samples). I will keep sampleid and other variable same as its source ( daidzin, genistin , glycitin) what I did was :select varname, transpose, calculate to get totals, get the variable name of the dataset to 3 totals and merge it back. I am just wondering if there is a easy way to do this. data have; input SampleID varname$ value1 value2 value3; datalines; 1 iron 0.7 1 0.05 1 copper 0.5 0 0.05 1 glycitin 532 1 200 1 glycitein 4.8 1 2 1 daidzein 5.76 1 2 1 daidzin 1200 1 200 1 genistein 4.8 1 2 1 genistin 2750 0 200 2 iron 1.2 0 0.05 2 copper 0.96 0 0.05 2 glycitin 478 0 200 2 glycitein 6.7 0 2 2 daidzein 7.5 0 2 2 daidzin 960 0 200 2 genistein 6 0 2 2 genistin 3000 0 200 ; run;
... View more