Help using Base SAS procedures

Keep line breaks in ETL preprocessing text.

Reply
Regular Contributor
Posts: 161

Keep line breaks in ETL preprocessing text.

Hi all,

Small question regarding line break in SAS.

I have task - automatically update pre-processing text in huge amount of ETLs.

I made this task using datastep function and metadata_...  function, and I almost finish with it but in the end I've found issue - this pre-proc text obviously can has line breaks.

So after I copy this text to datastep variable - it loses line breaks and then after I insert new(updated) pre-proc. text to ETL - it looks not readble becouse all code is in one line, for example:

"nice code" from pre-processing  code:

PROC SQL;

     CREATE TABLE TEST AS

     SELECT *

...

converts to:

PROC SQL; CREATE TABLE TEST AS SELECT *     ...

Which is not so "nice" and isn't readable...

May be there is some option or some another approach which will allow to save all line breaks in pre-processing text?

Thanks!

Ask a Question
Discussion stats
  • 0 replies
  • 141 views
  • 0 likes
  • 1 in conversation