Archive

Pendragon Tip #4: From Lookup List to STATA (Part 3)

Just arriving? Check out Part 1 and Part 2.

Link lookup list values to each variable

11. Import the question.xls and lookupEntry.xls files into a NEW MS Access database.

12. Create a relationship between the tables using the LookupID field in the lookupEntry table and the popupOptions field in the [...]

Pendragon Tip #4: From Lookup List to STATA (Part 1)

Since I started using Pendragon Forms 5.1 in 2007, my biggest gripe has been the lack of integration between Pendragon and statistical software packages like SPSS or STATA. Sure, you can export data to Excel or text files, but a lot of information is lost — namely numeric variable values and value labels.

Another Pendragon Forms / SPSS tip

I found a helpful trick yesterday that saved me a lot of time preparing my SPSS data file that was exported from Pendragon Forms 5.1 (Pendragon Forms –> MS Excel –> SPSS). I don’t claim to have discovered fire or the wheel or anything, but what I learned was useful for me. If you want [...]

Pendragon Forms and Automation

I use a great software program called Pendragon Forms 5.1 to conduct household surveys using PDAs. Overall, I highly recommend this program to others looking to use PDAs to collect data in the field. It offers a wide variety of input types (text, number, drop-down lists, signatures, etc), the ability to integrate peripherals such as [...]