Date: Mon, 30 Jan 2006 15:33:40 Z
Reply-To: Dirk Nachbar <Dirk.Nachbar@DWP.GSI.GOV.UK>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Dirk Nachbar <Dirk.Nachbar@DWP.GSI.GOV.UK>
Subject: iml
Content-Type: text/plain; charset="us-ascii"
dear all
i have a data set with paramters called two which looks like this
Obs _NAME_ PAY
1 INTERCEPT -1033.55
2 LPAY 0.77
3 AGE 49.86
4 AGEMALE 28.30
5 MALE -522.86
i also have a data set called home.privpa2 which has a lot of variables
(including those in the _name_ column, except intercept). i want to multiply
parm*vars within proc iml. in line 5 in the code below I need a clever way of
multiplication of parm*vars if _name_ is equal to column name in vars.
1 proc iml;
start prog1;
use two; read all into parm;
use home.privpa4 (where=(time=24)); read all into vars;
5 pay=parm(1,2)+parm(&i,2-end(parm))* ;
create privpa25;
finish prog1;
run prog1;
quit;
help is appreciated
Dirk Nachbar
Assistant Economist
Pensim2
Department for Work and Pensions
Level 4, The Adelphi
1-11 John Adam St
WC2N 6HT London
020 796 28531
**********************************************************************
This document is strictly confidential and is intended only for use by the addressee.
If you are not the intended recipient, any disclosure, copying, distribution or other
action taken in reliance of the information contained in this e-mail is strictly prohibited.
Any views expressed by the sender of this message are not necessarily those of the Department
for Work and Pensions.
If you have received this transmission in error, please use the reply function to tell us
and then permanently delete what you have received.
Please note: Incoming and outgoing e-mail messages are routinely monitored for compliance
with our policy on the use of electronic communications.
**********************************************************************
The original of this email was scanned for viruses by the Government Secure Intranet (GSi) virus scanning service supplied exclusively by Cable & Wireless in partnership with MessageLabs.
On leaving the GSi this email was certified virus-free