BookmarkSubscribeRSS Feed
Ronny_Dsouza
Obsidian | Level 7

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

1 REPLY 1
LinusH
Tourmaline | Level 20

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.

Data never sleeps

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 674 views
  • 0 likes
  • 2 in conversation