Date:         Mon, 24 Nov 2008 14:44:39 +0530
Reply-To:     Anindya Mozumdar <anindya.lugbang@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Anindya Mozumdar <anindya.lugbang@GMAIL.COM>
Subject:      Re: helppppppppppppp
Comments: To: nikki <nikkihathi@gmail.com>
In-Reply-To:  <2916fd87-dd85-4501-82b2-a43572bc75bd@e1g2000pra.googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1

Here you go - test3 is your 1st output and test4 your 2nd output

data test;
        input v1-v5;
        datalines;
1 1 1 1 1
2 2 2 2 2
3 3 3 3 3
4 4 4 4 4
5 5 5 5 5
;
run;

data test2;
        set test;
        array v{*} v1-v5;
        do i = 1 to dim(v);
                vo = v{i};
                output;
        end;
run;

data test3;
        set test2(keep = vo);
run;

proc sort data = test2(keep = i vo) out = test4(keep = vo);
        by i;
run;

On Mon, Nov 24, 2008 at 2:24 PM, nikki <nikkihathi@gmail.com> wrote:
> i want some codeing help..
> i have a dataset with 20 * 20 numerical values...
> for example:   1   1    1   1   1
>                       2    2   2   2   2
>                       3   3    3   3   3
>                       4   4    4   4   4
>                       5   5    5   5   5
>
> i want output to be....
> 1
> 1
> 1
> 1
> 1
> 2
> 2
> 2
> 2
> 2
> 3
> 3
> 3
> 3
> 3
> 4
> 4
> 4
> 4
> 4
> 5
> 5
> 5
> 5
> 5
>
> or
> 1
> 2
> 3
> 4
> 5
> 1
> 2
> 3
> 4
> 5
> 1
> 2
> 3
> 4
> 5
> 1
> 2
> 3
> 4
> 5
> 1
> 2
> 3
> 4
> 5
>
>
> i'm just learing the sas coding ....
> COuld anyone help me with this Query
>
>
>
> Thank you in advance
>



--
Anindya Mozumdar
http://www.anindyamozumdar.com