General discussion

Hi all,
I have recently moved roles from an commercial role to a consulting role. With the new role, I have noted that I would have to request for data extracts in order to perform analytics.
Would you be able to provide me with some tests that you would do to validate the data for completeness? Some of the tests I perform are:
- identifying blanks in key fields,
- verfiying the transaction dates to ensure the audit period is captured,
- number sequence check (where numbers are meant to be in sequence),

Good day Brian, I am confronted with the need to analyze numerous files in the SAS native structure. Is there a process whereby IDEA can read SAS files directly? They are available in a CSV flatfile structure as well, but they run to about 156,000 kb. Thanks, Bryan

Hi Brain,
I have extracted a single record to from source file to extracted File.
Then I need to edit the values in this column. Is it possible.
I tried to enable protect = False, but it's not working. I tried with the below code. could you please check this.
Dim db As Database
Dim table As Object
Dim newFieldObject As Object
Dim newFieldName As String
Dim newField As Object
 
Set db = Client.OpenDatabase(dbName)
    Set newField = db.TableManagement
    Set table = db.TableDef

Is anyone aware if its possible to connect Excel to an IMD file using ODBC -  ie the IMD file is the source.

I'm wondering if it's possible to use IDEA (v 10.4) to either prove or disprove a theory.  The theory is that training (online and classroom) improves turnover.  I have access to all the tables in the HR database which has the training area.  I pull termination dates and course completion dates but that is not enough to prove causation.  Has anyone done anything along these lines, maybe marketing/sales?

Good afternoon,
Does anyone have a crafty way to compare  multiple numeric fields (More than 2, I would otherwise use the @MAX function) in a database. I would like to take the highest numeric value and then do some testing on that... Thanks for any insight!

I have over 5000 time entries and I'm trying to check for overlaps on the same dates. I've tried using a date overlap script that I saw on here, but I cannot get it to work for the time. 
 
That data looks like this:

DATE
FIRST TIME IN
FIRST TIME OUT

2015/12/07
16:15:00
18:15:00

2015/12/07
19:00:00
21:00:00

2015/12/10
07:30:00
09:30:00

2015/12/10
12:30:00
14:30:00

2015/12/10
14:45:00
16:45:00

I'm working with a ton of medical claims data. I took claim data from 23 different offices and appened everything together. Then I ran the duplicate key using the recipients ID # (each patient's is unique) and the date of service. The result is 1.8 million duplicate claims. Also, each office has it's own unique billing number. From the duplicate results, they want me to take a specific office and find just the duplicates conencted to it. 

Hi Brain,
Is it possible to move a file inside to '+' as in the attached screenshot?
My child file is not grouped inside the + during the execution. is it possible to move it by code.
 
 

Hello,
I am Alice, I'm new in this forum and on IDEA.
I'm looking for some script/function whitch could : analyse a list with different parameters, and would be able to detect any duplication (perfect duplication on each paramater OR duplication for few parameters) . The result would be : the list with 1 item.
 
EXAMPLE:
my list :
NAME / COUNTRY / AGE
1 - Alice   - France - 30
2 - Paul - Canada - 30
3 - Alice - France - 30
4 - Alice - Spain - 20
RESULT 1 : detect perfect duplication =>