Date:         Fri, 9 Mar 2007 17:15:22 -0500
Reply-To:     "Fehd, Ronald J. (CDC/CCHIS/NCPHI)" <rjf2@CDC.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Fehd, Ronald J. (CDC/CCHIS/NCPHI)" <rjf2@CDC.GOV>
Subject:      Re: Multiple Columns Output
In-Reply-To:  <339F1EBB625D8B4A9058941E0FEBA4679731CC@HC-MAIL10.healthcare.uiowa.edu>
Content-Type: text/plain; charset=us-ascii

> From: Gao, Yubo
> Does anyone have experience in Multiple Columns Output?

This is known as a phone-book listing.
It is also used for indexes.

If you can possibly talk your way out of having to do this,
that would be a Good Thing.

otherwise you will have to write a
Data _Null_ report writer.

see Online Doc
file statement, details,
example 3: Arranging the Contents of an Entire Page

the options you want to check are:
file statement: n=pagesize
put statement: #, row pointer
               @, col pointer

Ron Fehd  the report writer (retired)
           or macro maven  CDC Atlanta GA USA RJF2 at cdc dot gov

> That means, if I have a dataset like
>
> Obs    ID
>
>   1    01006538
>   2    01082073
>   3    01204403
>   4    01224888
>   5    01325322
>   6    01413314
>   7    01524392
>   8    01546910
>   9    01558018
>  10    01589091
>  11    01634677
>  12    01667661
>  13    01674471
>  14    01802227
>  15    01822263
>  16    01830703
>  17    01979796
>  18    02096626
>  19    02105159
>  20    02111007
>
> I want to output it like (two columns)
>
> Obs    ID                   Obs   ID
>
>   1    01006538             11    01634677
>   2    01082073             12    01667661
>   3    01204403             13    01674471
>   4    01224888             14    01802227
>   5    01325322             15    01822263
>   6    01413314             16    01830703
>   7    01524392             17    01979796
>   8    01546910             18    02096626
>   9    01558018             19    02105159
>   10   01589091            20    02111007
>
> Or three columns format.
>
> Thanks,
>
> Yubo
>
>