Convert a DDF File to a Excel File.

We noticed that someone recently ran a search on our blog to try and find out how to convert a DDF to excel. This is a simple thing to do and to be honest there will be lots of examples in the DDL. Just install the DDL and then check the following directory out,

“C:\Program Files\IBM\SPSS\DataCollection\7\DDL\Scripts\Data Management”.

If you don’t have the DDL installed then read on.

Read more

Q&A : Using the {@} in loops

Recently in the comments section we where asked,

Hi. I am working on a survey where we need to have a summary of responses at the end of the survey. I am using script which was posted in IBM help that would put the question in the first column and the answer in the second. However I have a grid in my survey and instead of the question name appearing, the grid question is repeated throughout. Any suggestions on how to get the question name in the table instead of the grid question?

In this case the answer was to use the {@} in the loops , for example

G1 "G1 - Text  " loop
        A "This is the question A",
        B "This is the question B"
    } fields -
        SQ "SQ Text {@}"
        categorical [1..1]
            Y "Y",
            N "N"

    ) expand;

Q&A : Quota Full popup box

A few weeks ago we where asked the following

Q: I just want to show a popup box says “Quota Full” and send the participant to end of the survey. Any help about this ?

In this article we will address the popup box and the jump to the end of the survey. If you would like to see how you check the quotas then you can take a look at the related articles shown at the end of the post.

Read more

De-dupe your data files

In this article I will show you one way that you could use to de-dupe your data collection datafiles. I am not sure how you would get duplicates in it in the first place , but let’s just assume you do have them. This example will use the Museum.ddf file in the DDL. This file & the ddf can be found here “.DDLDataData Collection File”

Read more

Terminate an interview

When we create surveys our aim is to collect valid answers on a particular subject from a valid respondent. We are not actually interested in some respondents answers because they might not fit the profile of the survey. For example if we were running a survey on women’s makeup we would not really want any men to fill in the survey. In this article we will see some ways in which the survey can be terminated so that we do not waste peoples time answering questions that are not really for them.

Read more