***** To join INSNA, visit http://www.insna.org *****
You can get it via SQL query in Access... Assuming there is a table
(affiliations) that have two columns/fields (groupID,legislatorID),
where each row indicates that a certain interest group made a donation
for the corresponding legislator, then to get your one mode network the
query will be
select A.legislatorID,B.legislatorID, count(*) as weight from affiliations as A inner join affiliations as B on A.groupID=B.groupID where A.legislatorID<B.legislatorID group by A.legislatorID,B.legislatorID;
The above query will result in edges between legislators with weight field indicating the number of donations received by both legislators by the same interest group.
Hossam S. Sharara
University of Maryland - College Park
***** To join INSNA, visit http://www.insna.org ***** I have two-mode network data (legislators and interest groups, 435 and thousands respectively) that I'm trying to convert into one mode data. Basically, all I'm looking for are the number of common links between legislators where links are defined as donations from the same interest group. We've failed thus far to get this task done in Acess and we do not have the requisite skills to write our own computer code. Has anyone run into a similar problem and how have you solved it? Any advice would be welcome.
Scott D. McClurg
Associate Professor of Political Science
Department of Political Science
Southern Illinois University
Carbondale, IL 62901
(e) [log in to unmask]
_____________________________________________________________________ SOCNET is a service of INSNA, the professional association for social network researchers (http://www.insna.org). To unsubscribe, send an email message to [log in to unmask] containing the line UNSUBSCRIBE SOCNET in the body of the message.