I have multiple variables and I want to concatenate all the the values in the variables and i do not want same value twice. In the below example i want to create new variable called var6 by concatenating all the values from var1 to var5 for each ID. but i do not want a value repeated. for instance, for ID 1 as advil twice. but in var6 i want it to be seen only once . ex: Var6 = mic,advil,keyboard,mouse data chk; input id var1$ var2$ var3$ var4$ var5$; datalines; 1 mic advil keyboard advil mouse 2 mouse mouse keyboard perfume notebook 3 book wire plug desktop charger 4 mobile laptop mouse desktop phone ; run; Thank you in advance.
... View more