08-10-2011 10:19 AM
I have interesting task - in huge amount of ETLs change pre-processing text,- change one word inside of text to another.
Off cource for this task I used metadata to achive these goals.
I wrote simple data step which first fiounds all neede ETLs in metadata repository, then founds their pre-processing codes, then update these codes by symple tranwrd sas function and in the end I use:
"metadata_setattr" function for changing old TextStore attribute to new value.
All these steps works correct but I've found one problem - data step change line break symbol(new line symbol) to simple space.
So now "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...
So in another words problem is:
How to save line break symbols in metadata object attributes after update.