Custom Transformation Challenge

Ronny_Dsouza — Fri, 06 Mar 2015 07:42:07 GMT

Hi,

Trying to create a custom transformation having the using the following code.

%macro soverign ;

proc means data=&_input median stddev ;

by id Legal_Entity_L1 Legal_Entity_L2 Instrument_Type Country;

var Exposure;

output OUT= &_output median = Median stddev=Stddev;

run;

%mend;

%soverign;

While testing, the transformation runs without an error, however when we try to see the worktable, it throws an error, saying that the metadata of the columns are not registered,

Any idea what am I missing here.

Regards

Ronnie

Re: Custom Transformation Challenge

LinusH — Fri, 06 Mar 2015 10:04:55 GMT

The first clue is the message "columns are not registered". What are the column definitions of the work table? It should/must match the physical table structure created by the custom code.

Then it's a bit odd that you have hard coded variable names in the proc, that takes away a bit of the usefulness of a generated transformation.

topic Custom Transformation Challenge in SAS Data Management

Custom Transformation Challenge

Re: Custom Transformation Challenge