BookmarkSubscribeRSS Feed
kann573
Calcite | Level 5
I need to use an iterative proportional fit technique on a series of tables and wanted to use the Call IPF subroutine in IML, however most of the examples I have found show the tables hardcoded into the program (not an option due to the number of tables involved). Does anyone know of an example that pulls the margins and starting values from a dataset? Also, I am not terribly familiar with IML and would be open to other suggestions on IPF programming.
1 REPLY 1
Rick_SAS
SAS Super FREQ
Look at the USE and READ statements in the IML documentation to read IML matrices/vectors from a SAS data set. For an (r x c) table, the basic syntax is:
use libref.mytable;
read all var into InitialTable;
close libref.mytable;

use libref.rowmargin;
read all var into rowMargin; /* or read all var {nameOfVar} */
close libref.rowmargin;

use libref.colmargin;
read all var into colMargin;
close libref.colMargin;

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

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