Please suggest to get the output. Thank you
I need to replace mean,medain,cv with '-' if row with 'n' has less than 3.
for param='a', s2 column has 2 for n, so I need to change the mean,median,cv to '-'.
for param='b', s2 and s3 columns have 2 and1, so I need to change the mean,median,cv to '-'.
output needed:
3 2 4 n a 5 - 8 mean a 4 - 5 meadin a 10 - 15 cv a 3 2 1 n b 5 - - mean b 4 - - meadin b 10 - - cv b
data aa;
input s1 $ s2 $ s3 $ r3 $ param $;
datalines;
3 2 4 n a
5 6 8 mean a
4 7 5 meadin a
10 20 15 cv a
3 2 1 n b
5 6 8 mean b
4 7 5 meadin b
10 20 15 cv b
;
... View more