if then query

[woo]

Hello friends - please help to get this done

i have dataset "a" like this; (lets say all var are character except "var1")

var1            var2      var3     var4

300956       x           a           y

300956       x           a           y

300956       x           a           y

300956       x           a           y

300956       x           a           y

300956       x           b       

300956       x           b

300956       x           b

300956       x           b

i want output like this

var1            var2      var3     var4

300956       x           a           y

300956       x           b       

how can i get this done?

Thank you....

[Ksharp · Accepted solution]

proc sort data=have out=want nodupkey;by var1-var4;run;

[woo]

Thanks Xia it worked...:)