SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

How to save line break symbols in metadata object attributes after update?

Reply
Regular Contributor
Posts: 160

How to save line break symbols in metadata object attributes after update?

Hi all,

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:

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...

So in another words problem is:

How to save line break symbols in metadata object attributes after update.

Thanks!

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