|
Yaw,
As long as you define ID as a format z3. (or z whatever its length is)
I think you can get what you want with something like:
data have;
input id sex age ht;
format id z3.;
cards;
001 2 6 120
002 1 4 90
;
PROC EXPORT DATA= WORK.HAVE
OUTFILE= "c:\want.csv"
DBMS=CSV REPLACE;
RUN;
HTH,
Art
-----------
On Jan 24, 3:55 pm, Yaw <link...@gmail.com> wrote:
> Hi Community:
>
> I have this data set in SAS that I want export in the free column
> format(comma or space delimited) to enable me read it into another
> program.
>
> My current data is in this format:
>
> id sex age ht
> 001 2 6 120
> 002 1 4 90;
>
> and I want it in this format: 001,2,6,120,002,1,4,90.
>
> Any ideas?
>
> Thanks!
|