Raju,

Are you sure that the problem you need to solve is clearly stated and "below" indeed provides the necessary "required information"? For you to get help here, at least one of these components should be place.

Kind regards ------------ Paul Dorfman Jax, FL ------------

On Thu, 25 Jun 2009 07:06:02 -0700, drraju123 <drraju123@GMAIL.COM> wrote:

>Hi all, > >i have a dataset x and i want to convert it into dataset y. please see >below for the required information. thaks for your help. > >data x; > length var $60.; > qno = 1; > var = 'dem.x'; > output; > qno = 2; > var = 'dem.y'; > output; > qno = 3; > var = 'dem.abcde dem.qwertyu dem.asdfghj dem.zxcvb dem.hjkl'; > output; >run; > > >data y; > length var $60.; > qno = 1; > var = 'dem.x'; > output; > qno = 2; > var = 'dem.y'; > output; > qno = 3; > var = 'abcde'; > output; > qno = 3; > var = 'qwertyu'; > output; > qno = 3; > var = 'asdfghj'; > output; > qno = 3; > var = 'zxcvb'; > output; > qno = 3; > var = 'hjkl'; > output; >run; > > >regards, >raju