Extension for the case of larger sets (October 3, 2007):
Let us now add CS with the institutional addresses to the database by importing CS.dbf. (You may have to minimize a few windows before you are allowed to import external data.) Set the relations between CS and CORE using the relating field NR. In order to do so, you have to add the table CS first to the relationships by dragging it there. (Do not set a direct relation between AU and CS because this may lead to confusion.)
Create a Query in Design View and Add CS and CORE. Select from CS the field “country” and from CORE the field “py” (publication year). Select among the queries in Query at the top of the window “Crosstab Query.” You obtain an additional line in the design window entitled “Crosstab.” By clicking on the field you can choose the row and column captions. Choose “Row heading” for Country and “Column heading” for “PY.” Additionally, you need to specify what is counted in the table. For that purpose use NR from CORE. Specify at the line Total “Count” and at Crosstab “Value”. You should have it like this:
Run the query by hitting the red exclamation mark. This should provide you with crosstabulation of countries versus publication years. This cross tabulation can be copied into Excel for further processing if you wish.
The program Acc2ISI.exe allows you (in combination with ISI.exe) to go back and forth between the data manipulation in MS Access (or another database program and the so-called “tagged” format that is output of the Science Citation Index at the ISI Web-of-Knowledge.
To select, for example, all records from the United States (within Access), you first have to add an in-between table COUNTRY which provides one-to-one relations between country names and records in CORE because there can be records with more than one address in the USA. (They would then be counted twice.)
In order to make the same selection for the USA on AU, CS, and CR:
You can use the files AU.DBF, CORE.DBF, CR.DBF and CS.DBF as input to ACC2ISI.EXE. These files have to be in the same folder.
Acc2ISI.exe requires that you rename the exported files with the original names core.dbf, au.dbf, cs.dbf, and cr.dbf. These should be in the dBase format. It generates a file isi.txt that can be imported in HistCite™ or any of the programs available on this site for the bibliographic mapping (e.g., CoAuth.exe).
Loet Leydesdorff & Diana Lucio-Arias
Amsterdam, October 2007