topic Re: Proc Export - New line in SAS Programming

Proc Export - New line

helannivas88 — Thu, 23 Jul 2020 09:41:56 GMT

Hi,

In our SAS dataset which we have extracted the data from SAS , we have value as like below

"QWERTY
, xxx/ABCc Financial Services Ltd/XYX Wealth Limited"

not in a single line. When I proc export the dataset into a txt file , the line is getting broken and the below one (xxx/ABCc..) as a separate row in the txt file.

How to rectify the problem?? I think we have to resolve in the SAS dataset load rather than in proc export.

I have used compress = yes while creating the work.dataset but nothing works.

Please let me know the solution for this? Thanks.

Re: Proc Export - New line

Kurt_Bremser — Thu, 23 Jul 2020 10:01:32 GMT

You may have linefeeds in your data. Inspect the column in which the line break happens by displaying it with a $HEX format (format length must be double the defined variable length).

Linefeeds are hex 0A, carriage returns 0D.

If that is the case, use the TRANSLATE function to replace these special characters with blanks.

Re: Proc Export - New line

Tom — Thu, 23 Jul 2020 12:31:16 GMT

SAS does not know how to read (or write) delimited files with end of line characters embedded into the value of a variable.

Best solution is to remove those characters from the value before writing the delimited file. For example by replacing them with spaces.

data for_export;
  set have;
  array _c _character_;
  do over _c;
    _c = translate(_c,'  ','0A0D'x);
  end;
run;

proc export data=for_export dbms=csv
  file='want.csv'
;
run;

Re: Proc Export - New line

helannivas88 — Thu, 23 Jul 2020 13:35:11 GMT

Thanks Both.

The issue is with the line feed (Hex value - 0A). I have used compress function to resolve the issue.

NAME= compress(NAME, ,'kw');