data have; input Name $ var1 var; datalines; Usa 2 5 Mad . 4 bad . 4 sad 2 . pad 2 . India . 2 Mad . . bad 9 . sad . . pad . . Aus . .1 Mad . . bad 9 . sad . . pad . .1 ; have like this. wanted like below. Name var1 var New_Name Usa 2 5 Usa Mad . 4 Usa bad . 4 Usa sad 2 . Usa pad 2 . Usa India . 2 India Mad . . India bad 9 . India sad . . India pad . . India Aus . 0.1 Aus Mad . . Aus bad 9 . Aus sad . . Aus pad . 0.1 Aus
... View more