LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous (more recent) messageNext (less recent) messagePrevious (more recent) in topicNext (less recent) in topicPrevious (more recent) by same authorNext (less recent) by same authorPrevious page (January 2007, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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?


Back to: Top of message | Previous page | Main SAS-L page