08-11-2011 02:34 AM
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:
CREATE TABLE TEST AS
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?