Date:         Tue, 25 Jul 2006 04:59:48 -0700
Reply-To:     "antje.schuele@googlemail.com" <antje.schuele@GOOGLEMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "antje.schuele@googlemail.com" <antje.schuele@GOOGLEMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: Select field of data set transposed
Comments: To: sas-l@uga.edu
In-Reply-To:  <1153819258.757117.55920@s13g2000cwa.googlegroups.com>
Content-Type: text/plain; charset="iso-8859-1"

Hi all,

I found the solution:

data test;
        length sth $256;
        set dataset;
        array some col1-col30;
        do cc = 1 to 30;
          select;
                when ((some(cc) eq "event" or some(cc) eq " ") AND sth
= " " )         sth = " ";
                when ((some(cc) eq " " AND some(cc) ne " ") sth = . )
    sth = some(cc);
                otherwise;
           end;
        end;
        drop cc;
run;

Thanks for your hints.

Antje