Data input problem

[twylite]

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.

 

[dblan]

This should work.

data have;
  input x y z count ;
  datalines;
1 0 1  2
1 1 0  1
0 1 1  2

;
run;

Data want;
set have;
do i=1 to count;
    output; 
end;
run;

You can add (drop=count i) right behind Want to remove those 2 variables.

 

[twylite]

thanks alot, i will give that a try