Date:         Wed, 2 May 2007 07:34:55 -0700
Reply-To:     SAS LEARNER1 <kappel_chris@YAHOO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         SAS LEARNER1 <kappel_chris@YAHOO.COM>
Organization: http://groups.google.com
Subject:      How to create a pipe delimited format!!
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset="iso-8859-1"

Hi all,

Please help me out!!!

I need to prepare a input file in the following pipe delimited format:

example- |||XX|V1|V2|V3.

and The three leading pipe characters and the uppercase XX are
required. The
V3 value is optional. If the V3 value is provided, it  will be written
to the V3 column in the member table for each row that is updated. One
pipe character separates the XX, V1, V2, and V3 fields. There is no
trailing pipe on each line; however, if the
V3 value is left blank, the last character on that line would be the
pipe following the V2 value. Every line will contain 6 pipes.

Can someone help me out. I dont know how to do it!

Thanks in advance!

Chris