Statistical programming, matrix languages, and more

Are there some query tools in IML

Reply
Grand Advisor
Posts: 9,336

Are there some query tools in IML

I am wondering if there are some query tools in IML?

Like MERGE in data step. LEFT JOIN in SQL .

Xia Keshan

SAS Super FREQ
Posts: 3,236

Re: Are there some query tools in IML

Not really. Most data preparation is done outside of IML by using the DATA step or SQL. There is nothing in SAS/IML that matches their power and convenience.

You can, of course, use the LOC function, in conjunction with subscripting and concatenation, to match and merge rows of matrices. The UNIQUE-LOC technique is often used to combine data by matching categories.  The EXPANDGRID function is a kind of joining operation, since it is a Cartesian product operation.

Grand Advisor
Posts: 9,336

Re: Are there some query tools in IML

Thanks . Rick .

Post a Question
Discussion Stats
  • 2 replies
  • 269 views
  • 3 likes
  • 2 in conversation