|
Add the colon format modifer. Example
1 data _null_;
2 file log dlm=',' dsd;
3 set sashelp.class;
4 put name:$quote100. age sex:$quote100. height weight;
5 run;
"Alfred",14,"M",69,112.5
"Alice",13,"F",56.5,84
On 1/24/07, Todd Welsh <twelsh@aaamidatlantic.com> wrote:
> 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?
>
|
