Transcript IDAMS

United Nations Educational,
Scientific and Cultural Organization
IDAMS
Internationally Developed
Data Analysis and Management
Software Package
2004
WinIDAMS – what it contains
User Interface
Three modules for interactive data analysis
Data analysis and data management facilities
embedded in “programs”
Standard features
Powerful Recode language for construction of new
variables
2
System requirements
32-bit versions of Windows operating systems
(Windows 95, 98, NT 4.0, 2000 or XP)
Pentium II or faster processor
64 megabytes RAM
About 11 MB of disk space for each language version
Files for download (each version):
installation
7.3 MB
manual
2.6 MB
3
WinIDAMS User Interface
•
•
•
•
•
•
•
•
•
•
Application option
Dictionary window
Data window
Setup window
Option for executing IDAMS setups
Results window
Interactive data import/export facilities
Access to interactive data analysis components
Advanced text editing facilities
On-line access to the Reference Manual
4
Interactive data analysis
Multidimensional tables and their graphical presentation
Graphical exploration of data (GraphID)
Time series analysis (TimeSID)
5
Data analysis facilities
Univariate analysis
Univariate table and statistics
Distribution and Lorenz functions
Bivariate analysis
Bivariate tables and statistics
One-way analysis of variance
Scatter diagrams
Pearsonian correlation
6
Data analysis facilities
Multivarate explicative analysis
Lineal regression
Multiple classification analysis
Searching for structure
7
Data analysis facilities
Multivariate descriptive analysis
Principal components factor analysis
Analysis of correspondences
Stepwise linear discriminant analysis
Cluster analysis
Typology and ascending classification
Partial order scoring
Rank-ordering of alternatives
Multidimensional scaling
Configuration analysis
8
Data management facilities
Data verification and correction
Data editing and construction of an IDAMS dataset
Checking for non-numerical values
Checking of codes
Checking of consistency
Checking the merging of records
Correcting data
9
Data management facilities
Data transformation
Sorting and merging files
Importing and exporting data
Listing data
Subsetting data
Aggregating data
Merging data
10
Standard features
Case selection
Variable selection
Transforming data – Recode facility
Weighting data
Treatment of missing data
Treatment of non-numerical values
11
The Recode language
Elements of the Recode language
OPERANDS
variables, constants, functions, expressions
OPERATORS
arithmetic, relational, logical
FUNCTIONS
arithmetic, logical
STATEMENTS
assignment, control, initialization/definition
12
Data in IDAMS
IDAMS dataset
Data file + Dictionary file with data description
IDAMS matrices
square matrix
rectangular matrix
13
Data file
Any text file of fixed format, i.e. where the values for a
given variable occur in the same positions and in the same
record for each case.
Anne
John
Mary
Tom
…
6
2
3
1
…
f
m
f
m
…
35
55
44
58
…
1
2
3
1
…
7500
9500
900
11900
…
1153.8
1461.54
138.461
1830.76
…
14
Data file
Can contain:
• up to 4096 characters per case
• number of cases limited by the disk capacity and
by the internal representation of numbers
• up to 1000 variables
• up to 50 records per case.
15
Variables
• identified by a unique number between 1 y 9999
• reference – number preceded by V or R, e.g. V3
• numeric or alphabetic, stored in character mode
16
Variables
Numeric variables
• values integer or decimal, positive or negative
• blank fields are considered non-numerics
• maximum field width is 9 but only up to 7 significant
digits are retained in processing
Alphabetic variables
• any string of characters
• maximum field width is 255
• 1-4 first characters can be used in filters and in Recode
17
Data description – Dictionary file
It contains:
• the variable number, its type and its location in the data
record
• variable name, two missing data codes, the number of
decimal places, reference number and study ID
• labels (names) for different codes of qualitative variables
18
Data exchange
Interactive data import/export
Data: Tab (.txt), comma (.csv), semicolon (.csv)
IMPEX program
Data: free or DIF format
Matrices: free format
19
Executing IDAMS programs
Sequence of operations
preparation of instructions in a setup
execution of the setup
revision of results
20
IDAMS Setup file
$RUN program name
$FILES
file specifications
$SETUP
program control statements
$RECODE
Recode statements
21
Example of a Setup file
$RUN REGRESSN
$FILES
PRINT=regres.lst
DICTIN=cm.dic
DATAIN=cm.dat
$SETUP
‘Standard & stepwise regressions'
badd=md1 mdha=20 cate
v4(1,2)
depv=v11,vars=(v4,v9,v10)
meth=step,depv=v12,vars=(v4,v7,v9,v10)
22
IDAMS Results file
Structure and contents of results
release number and date
date and time of execution
listing of setup
Recode statements
program name, source, data of last updating
interpretation of setup
input and output dictionary(-ies)
results of execution
23