Hi all, have data in the following format:
X Y Z Count
1 0 1 2
1 1 0 1
0 1 1 2
which i need to translate to:
X Y Z
1 0 1
1 0 1
1 1 0
0 1 1
0 1 1
Whats the most efficient way to do this in sas, I had assumed there was a built in way in the data step but I havent found it. Any help would be appreciated.
X Y Z Count
1 0 1 2
1 1 0 1
0 1 1 2
which i need to translate to:
X Y Z
1 0 1
1 0 1
1 1 0
0 1 1
0 1 1
Whats the most efficient way to do this in sas, I had assumed there was a built in way in the data step but I havent found it. Any help would be appreciated.