Documentation & FAQs

Here's what's available in terms of documentation:
  • Halgin D.S., & Borgatti S.P. 2012. An introduction to personal network analysis with E-Net. Connections. Vol. 31, 1: 37 - 48  [pdf]
  • Filtering data in E-Net [pdf]
  • Data formats [pdf]

Contents

  • Filtering egos, alters, ego-alter ties, alter-alter ties, etc. E-Net Data Filtering     Filter criteria consist of boolean phrases such as Size > 100. The syntax basically follows SQL Where clauses.   One thing to note: When you have string (i ...
    Posted Jul 2, 2012, 1:55 PM by Steve Borgatti
  • FAQ: Missing midas.dll If the program won't run because it is missing MIDAS.DLL, try downloading the midas.dll file (see DOWNLOAD page) to your E-Net program folder. If that doesn ...
    Posted Dec 18, 2011, 3:07 PM by Steve Borgatti
Showing posts 1 - 2 of 2. View more »



Filtering egos, alters, ego-alter ties, alter-alter ties, etc.

posted Jul 2, 2012, 1:55 PM by Steve Borgatti

E-Net Data Filtering

 

 

Filter criteria consist of boolean phrases such as Size > 100. The syntax basically follows SQL Where clauses.

 

One thing to note: When you have string (i.e., textual) values, you must use single quotes to reference them, as in ID = 'Smith'. For numeric variables you

do not use the quotes. How do you know which of your variables are textual? Look at variable names in the data grids. The EGO program uses

UPPERCASE to represent string variables, and lowercase for numeric variables.

 

Filter Comparison Operators

 

Function

Description

Example

=

Equality test

Name = 'John Smith'

<> 

Inequality test

ID <> 100

Less than

Birthday < '1/1/1980'

Greater than

Birthday > '12/31/1960'

<=

Less than or equal to

Salary <= 80000

>=

Greater than or equal to

Salary >= 40000

''

Empty string field

Name <> ''

 

 

Filter Logical Operators

 

Function

Example

And

(Name = 'John Smith') and (Birthday = '5/16/1964')

Or

(Name = 'John Smith') or (Name = 'Julie Mason')

Not

Not (Name = 'John Smith')

 

 

Filter Arithmetic Operators

 

Function

Description

Example

+

Addition. Can be used with numbers, strings, or dates/times.

Birthday + 30 < '1/1/1960';
Name + 'X' = 'SmithX';
Salary + 10000 = 100000;

Subtraction. Can be used with numbers or dates/times.

Birthday - 30 > '1/1/1960';
Salary - 10000 > 40000;

*

Multiplication. For numbers only.

Salary * 0.10 > 5000;

/

Division. For numbers only.

Salary / 10 > 5000;

 

 

Filter String Functions

 

Function

Description

Example

Upper

Uppercase

Upper(Name) = 'JOHN SMITH'

Lower

Lowercase

Lower(Name) = 'john smith'

SubString

Return a portion of a string

SubString(Name,6) = 'Smith' SubString(Name,1,4) = 'John'

Trim

Trim leading and trailing characters from a string

Trim(Name) Trim(Name, '.')

TrimLeft

Trim leading characters from a string

TrimLeft(Name) TrimLeft(Name, '.')

TrimRight

Trim trailing characters from a string

TrimRight(Name) TrimRight(Name, '.')

 

 

Filter Date/Time Functions

 

Function

Description

Example

Year

Returns the year portion of a date value.

Year(Birthday) = 1970

Month

Returns the month portion of a date value.

Month(Birthday) = 1

Day

Returns the day portion of a date value.

Day(Birthday) = 15

Hour

Returns the hour portion of a time value in 24-hour format.

Hour(Appointment) = 18

Minute

Returns the minute portion of a time value.

Minute(Appointment) = 30

Second

Returns the second portion of a time value.

Second(Appointment) = 0

GetDate

Returns the current date and time.

Appointment < GetDate

Date

Returns the date portion of a date/time value.

Date(Appointment)

Time

Returns the time portion of a date/time value.

Time(Appointment)

 

Other Filter Functions and Operators

 

Function

Description

Example

LIKE

Partial string comparison.

Name LIKE '%Smith%'

IN

Tests for multiple values.

-Year(Birthday) IN (1960, 1970, 1980)

*

Partial string comparison.

Name = 'John*'

 

 

 

FAQ: Missing midas.dll

posted Dec 18, 2011, 2:15 PM by Steve Borgatti   [ updated Dec 18, 2011, 3:07 PM ]

If the program won't run because it is missing MIDAS.DLL, try downloading the midas.dll file (see DOWNLOAD page) to your E-Net program folder. 

If that doesn't work, it probably means you used to have midas.dll installed in some folder, and the Windows Registry has recorded that fact, but now the file has moved and Windows is still looking for it in that same folder. The cure is to use REGEDIT to find the entry in the registry and delete it.

1-2 of 2