Date: Wed, 24 Jan 2007 09:10:03 -0500
Reply-To: Todd Welsh <twelsh@AAAMIDATLANTIC.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Todd Welsh <twelsh@AAAMIDATLANTIC.COM>
Subject: Create Comma Delimited File with Double Quotes
I need to create comma delimited files with double quotes around text
fields. My first attempt with this produced undesirable results. Here is
a sample of the PUT Statement and the OUTPUT.
Put @01 MembershipID $quote10.
','
FirstName $quote20.
','
LastName $quote30.
','
Address1 $quote30.;
The output looks something like this:
"01234567", "Todd" , "Welsh" , "123
Main St."
As you can see there is a lot of extra space after the last double quote
and before the comma. I would prefer the results to look like this.
"01234567", "Todd", "Welsh", "123 Main St."
Any suggestions?
|