Spss data analysis
Hi, I am trying to find out the demographics (age, gender, ethnicity etc) of my final subject pool on SPSS. I used a survey type questionnaire, and want to know which subjects completed all the measures of interest. I f I do a cross tabs with ageXgender, for example, I don’t know which of THESE [...]
Answer Question
| July 25, 2008 1:07 AM
Business Intelligence, Data analysis, SPSS
Hi, I am trying to find out the demographics (age, gender, ethnicity etc) of my final subject pool on SPSS. I used a survey type questionnaire, and want to know which subjects completed all the measures of interest. I f I do a cross tabs with ageXgender, for example, I don’t know which of THESE [...]
Answer Question
| July 25, 2008 1:07 AM
Business Intelligence, Data analysis, SPSS
Data analysis, SPSS
Hi, I am trying to find out the demographics (age, gender, ethnicity etc) of my final subject pool on SPSS. I used a survey type questionnaire, and want to know which subjects completed all the measures of interest. I f I do a cross tabs with ageXgender, for example, I don’t know which of THESE [...]
Answer Question
| July 25, 2008 5:00 PM
Data analysis, SPSS
Hi, I am trying to find out the demographics (age, gender, ethnicity etc) of my final subject pool on SPSS. I used a survey type questionnaire, and want to know which subjects completed all the measures of interest. I f I do a cross tabs with ageXgender, for example, I don’t know which of THESE [...]
Answer Question
| July 25, 2008 5:00 PM
Data analysis, SPSS
How do I receive java-agent-backend-data in UI
I need help! a doc is open in UI. After pressing a button, the doc ist opened in a dialogbox for extra input. dlg_res = workspace.DialogBox( “DMS_Indizierung”, True, True, False , False , True, False, _ “In eAK überleiten …”, ,True, False, True ) In Queryclose there are more checks and an agent is started. [...]
Answer Question
| July 22, 2008 6:22 AM
Agents, Data analysis, Java, UI, Web services
I need help! a doc is open in UI. After pressing a button, the doc ist opened in a dialogbox for extra input. dlg_res = workspace.DialogBox( “DMS_Indizierung”, True, True, False , False , True, False, _ “In eAK überleiten …”, ,True, False, True ) In Queryclose there are more checks and an agent is started. [...]
Answer Question
| July 22, 2008 6:22 AM
Agents, Data analysis, Java, UI, Web services
Database Question.
Hello all .. I am doing an Internship with a company in Nashville that does community branding. Recently I received a project to design a database which would house all of the information that we would need to show to potential clients to gain their business. Such as particular information about different years growth statistics [...]
Answer Question
| July 31, 2008 5:33 PM
Data analysis, Data Junction, Data management and storage, Data warehousing applications, Database design, Database issues
Hello all .. I am doing an Internship with a company in Nashville that does community branding. Recently I received a project to design a database which would house all of the information that we would need to show to potential clients to gain their business. Such as particular information about different years growth statistics [...]
Answer Question
| July 31, 2008 5:33 PM
Data analysis, Data Junction, Data management and storage, Data warehousing applications, Database design, Database issues
Live production numbers as screen saver
We count the cattled killed in a slaughter facility and this data changes every 2.6 min. I want the screen saver (windows) to reflect the current kill number and will update say every three minutes.
Answer Question
| June 23, 2008 3:35 PM
Business Intelligence, Data analysis, Real time analytics, Windows
We count the cattled killed in a slaughter facility and this data changes every 2.6 min. I want the screen saver (windows) to reflect the current kill number and will update say every three minutes.
Answer Question
| June 23, 2008 3:35 PM
Business Intelligence, Data analysis, Real time analytics, Windows
Working with totals
I am trying to run cross-tabs (year x gender) on a data set made up of total scores (rather than frequencies) in each cell, but the output only gives me counts. Is there a command to let SPSS know that the cell figure is a total?
Answer Question
| June 11, 2008 9:19 AM
Data analysis, SPSS
I am trying to run cross-tabs (year x gender) on a data set made up of total scores (rather than frequencies) in each cell, but the output only gives me counts. Is there a command to let SPSS know that the cell figure is a total?
Answer Question
| June 11, 2008 9:19 AM
Data analysis, SPSS
uploading an excel spreadsheet to the as/400
I’ve seen a developer with an Excel spreadsheet on the iseries server, how do I upload an Excel spreadsheet to the iseries and populate it with data so I can then download the finished product to my PC?
Answer Question
| August 18, 2010 9:23 PM
AS/400, Data analysis, Microsoft Excel
I’ve seen a developer with an Excel spreadsheet on the iseries server, how do I upload an Excel spreadsheet to the iseries and populate it with data so I can then download the finished product to my PC?
Answer Question
| August 18, 2010 9:23 PM
AS/400, Data analysis, Microsoft Excel
How to create blocks in SPSS
I have a data file with 12,00 trial inputs. When I run my descriptives, I want to combine every 100 trials together as 1 block so instead of comparing 12,00 trials, I am looking at 120 blocks and comparing those. Is there anyway to do this without first going through and running the statistics on [...]
Answer Question
| May 2, 2008 3:04 PM
Data analysis, Data mining/analysis, SPPS
I have a data file with 12,00 trial inputs. When I run my descriptives, I want to combine every 100 trials together as 1 block so instead of comparing 12,00 trials, I am looking at 120 blocks and comparing those. Is there anyway to do this without first going through and running the statistics on [...]
Answer Question
| May 2, 2008 3:04 PM
Data analysis, Data mining/analysis, SPPS
Crystal report
I just started a job as a data analyst and wanted to see if any want can help me build a report on crystal report. Claims billed by month Claims outstanding by month Monthly report showing write off ‘bad dept’ Thanks
Answer Question
| April 4, 2008 12:26 AM
Crystal Reports, Data analysis
I just started a job as a data analyst and wanted to see if any want can help me build a report on crystal report. Claims billed by month Claims outstanding by month Monthly report showing write off ‘bad dept’ Thanks
Answer Question
| April 4, 2008 12:26 AM
Crystal Reports, Data analysis
Define a field using a query
I’m trying to create a date field from a numeric field and can’t seem to get the syntax correct and can’t find any help on line.
Answer Question
| July 26, 2007 10:54 AM
Data analysis
I’m trying to create a date field from a numeric field and can’t seem to get the syntax correct and can’t find any help on line.
Answer Question
| July 26, 2007 10:54 AM
Data analysis
Need help for Dynamic tables
In a normal table all the field are defined before.. For example; let’s say that we have a Cars Table, it probably will be like this: TABLE_CARS CAR_CODE BRAND MODEL VERSION SPEED COLOR GEAR_TYPE PRICE In such a table a single row contains all the data for a single car, so by querying any field [...]
Answer Question
| June 6, 2007 9:45 AM
Data analysis
In a normal table all the field are defined before.. For example; let’s say that we have a Cars Table, it probably will be like this: TABLE_CARS CAR_CODE BRAND MODEL VERSION SPEED COLOR GEAR_TYPE PRICE In such a table a single row contains all the data for a single car, so by querying any field [...]
Answer Question
| June 6, 2007 9:45 AM
Data analysis
Select last 3 transactions
Hello Can someone help me to put together an SQL statement to select the last 3 transactions from a transaction file. In TransactSQL I would do something like this: select top 3 CustID, TransDate, Amount from Trans where CustID= ’12345′ order by TransDate desc. I believe there must be a more effcient way of getting [...]
Answer Question
| May 15, 2008 6:54 AM
Data analysis, Data warehousing applications, Database, DB2, DB2 Universal Database, Development, Oracle, PC/Windows Connectivity, SQL
Hello Can someone help me to put together an SQL statement to select the last 3 transactions from a transaction file. In TransactSQL I would do something like this: select top 3 CustID, TransDate, Amount from Trans where CustID= ’12345′ order by TransDate desc. I believe there must be a more effcient way of getting [...]
Answer Question
| May 15, 2008 6:54 AM
Data analysis, Data warehousing applications, Database, DB2, DB2 Universal Database, Development, Oracle, PC/Windows Connectivity, SQL
Updating one record with a field of another record where two other fields match
I have the following Table: XREF Group Projid id1 id2 —– ——– —– ———– AEEC SOCAL 71 442760 CAG AWPE 71 442780 CAG MONDPL 71 447585 CAG PLANDI 71 442780 CAG SMCECA 71 442780 CAG AWPE 84 442781 CAG MONDPL 84 447588 AEEC MONDP 84 447589 CAG PLANDI 98 288923 CAG SMCECA 98 288923 CAG [...]
Answer Question
| March 2, 2007 3:53 PM
Data analysis, Database, DB2, Oracle, SQL
I have the following Table: XREF Group Projid id1 id2 —– ——– —– ———– AEEC SOCAL 71 442760 CAG AWPE 71 442780 CAG MONDPL 71 447585 CAG PLANDI 71 442780 CAG SMCECA 71 442780 CAG AWPE 84 442781 CAG MONDPL 84 447588 AEEC MONDP 84 447589 CAG PLANDI 98 288923 CAG SMCECA 98 288923 CAG [...]
Answer Question
| March 2, 2007 3:53 PM
Data analysis, Database, DB2, Oracle, SQL
datamining SQL with access
I have been asked by the sales department to datamine our SQL database and pull the names and e-mails of all our guests for the last few years for a contact list. I am new to SQL but have worked with access in the past. Using access, how do I set things up so that [...]
Answer Question
| July 4, 2008 4:29 PM
Access, Data analysis, Data mining/analysis, Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server
I have been asked by the sales department to datamine our SQL database and pull the names and e-mails of all our guests for the last few years for a contact list. I am new to SQL but have worked with access in the past. Using access, how do I set things up so that [...]
Answer Question
| July 4, 2008 4:29 PM
Access, Data analysis, Data mining/analysis, Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server
How to create our own set up file in VB 6.0
Dear friends, I want to know how to create setup file of our project in VB 6.0. Wait…I know how to create setup file using package and deployment tool but I want to know how can I create a file in which we can include images, pictures, some animations. I mean setup file with our [...]
Answer Question
| April 19, 2013 6:19 AM
Career development, Data analysis, Development, Lifecycle development, Project management, Training, Visual Basic
Dear friends, I want to know how to create setup file of our project in VB 6.0. Wait…I know how to create setup file using package and deployment tool but I want to know how can I create a file in which we can include images, pictures, some animations. I mean setup file with our [...]
Answer Question
| April 19, 2013 6:19 AM
Career development, Data analysis, Development, Lifecycle development, Project management, Training, Visual Basic
Windows Server 2003 connection problems
I am seeing converstions with my IIS6 server terminate after about 15 min during a download of a large file. A tcpdump shows the server is sending out a rst/ack packet (not good) followed by 20 more rst packets to the destination IP. I was able to capture the failure as it happened but I [...]
Answer Question
| November 24, 2007 1:08 PM
Data analysis, DataCenter, Networking, Web site design & management
I am seeing converstions with my IIS6 server terminate after about 15 min during a download of a large file. A tcpdump shows the server is sending out a rst/ack packet (not good) followed by 20 more rst packets to the destination IP. I was able to capture the failure as it happened but I [...]
Answer Question
| November 24, 2007 1:08 PM
Data analysis, DataCenter, Networking, Web site design & management
RUN TIME ERROR 339
I have an application written in Visual Basic. The application runs on windows XP system with oracle 8i and Crystal report 8.5 The application suppose to interface with an oracle 8i database. In attempt to run the application it gives this error: ‘Run-Time Error 339 component ‘CRYSTL32.OCX’ or one of its dependencies not correctly registed [...]
Answer Question
| December 8, 2006 11:42 AM
Data analysis, Database, DB2, Development, Interoperability, Oracle, Software, Tech support, Windows
I have an application written in Visual Basic. The application runs on windows XP system with oracle 8i and Crystal report 8.5 The application suppose to interface with an oracle 8i database. In attempt to run the application it gives this error: ‘Run-Time Error 339 component ‘CRYSTL32.OCX’ or one of its dependencies not correctly registed [...]
Answer Question
| December 8, 2006 11:42 AM
Data analysis, Database, DB2, Development, Interoperability, Oracle, Software, Tech support, Windows
Excel Spreadsheets
We developed some kind of database with excel spreadsheets to draw monthly stats for diffrent departments. It works as follows: Individual spreadsheets(formulated)feeds into a master Link spreadsheets(data) we then use Pivots for our reports. The problem that I now expierence is that: 1. The masterlink does not update automatically, we have to open the individual [...]
Answer Question
| May 9, 2011 2:42 AM
Data analysis, Database, DataCenter, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL Server
We developed some kind of database with excel spreadsheets to draw monthly stats for diffrent departments. It works as follows: Individual spreadsheets(formulated)feeds into a master Link spreadsheets(data) we then use Pivots for our reports. The problem that I now expierence is that: 1. The masterlink does not update automatically, we have to open the individual [...]
Answer Question
| May 9, 2011 2:42 AM
Data analysis, Database, DataCenter, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL Server
Mail sending error in certain domains through excahnge server 2003
Hi all Recently I have installed exchange server2003, and configured outside email also its working fine, I can send and receive mails form yahoo, hotmail, gmail, but some domain I can not send but I can receive mails from these domains. I am getting following error message Your message did not reach some or all [...]
Answer Question
| November 22, 2006 8:41 AM
Business/IT alignment, Data analysis, Exchange, Exchange security, Microsoft Windows, Networking
Hi all Recently I have installed exchange server2003, and configured outside email also its working fine, I can send and receive mails form yahoo, hotmail, gmail, but some domain I can not send but I can receive mails from these domains. I am getting following error message Your message did not reach some or all [...]
Answer Question
| November 22, 2006 8:41 AM
Business/IT alignment, Data analysis, Exchange, Exchange security, Microsoft Windows, Networking
Conversion Project
We are currently working on a project which will at a later date will require alof of data conversion on our existing system to fit the new file structures which are currently been developed. The project is been developed using COBOL on an iSeries, the old and new files will all be physical files. I [...]
Answer Question
| April 19, 2010 6:46 AM
Application development, AS/400, Data analysis, DB2 Universal Database
We are currently working on a project which will at a later date will require alof of data conversion on our existing system to fit the new file structures which are currently been developed. The project is been developed using COBOL on an iSeries, the old and new files will all be physical files. I [...]
Answer Question
| April 19, 2010 6:46 AM
Application development, AS/400, Data analysis, DB2 Universal Database
