|

How to Fix Your SPSS Truncated Data File

ByAnnMaria De Mars

CoffeeWell, this morning started out annoying, and not just because I had to be at LAX at 8 a.m. I am sitting here trying to analyze an SPSS file someone sent me last night and I get this … Command: CORRELATIONS Incomplete (truncated) SPSS Statistics data file: /Users/annmaria/blahblah.sav Execution of this command stops. I tried the copy I had on a USB drive and my backup copy and got the same thing all over again. Grr. On a moment’s reflection, though, it occurred to me that since SPSS had opened the file and there was just a problem with how the file had been saved – something was missing that identified the end of file, I am guessing – that perhaps it could be fixed by simply saving the file as something else and reading it back in. So … I saved the file as .csv, by just selecting SAVE AS from the FILE menu and selecting csv as the type. Then, I went to FILE and selected READ TEXT DATA,  opened the .csv file, accepted all of the defaults and was back in business to merrily analyze away. — all before I boarded my flight. Pretty productive considering that all of the coffee in Columbia could not make me a morning person.

Similar Posts

The hardest errors to find are the things that aren’t there: A PHP example

ByAnnMaria De Mars

In my defense, the actual program is longer than this … <?php require ‘connect.php’; // Create variables ; $id = strtoupper(trim($_REQUEST[‘id’])) ; $application_date = $_REQUEST[‘yr_of_apply’] . “-” . $_REQUEST[‘month_of_apply’] .”-“. $_REQUEST[‘day_of_apply’] ; $assessment_date = $_REQUEST[‘yr_of_assess’]. “-” . $_REQUEST[‘month_of_assess’] .”-“. $_REQUEST[‘day_of_assess’] ; $eligibility_date = $_REQUEST[‘yr_eligible’].”-“.$_REQUEST[‘month_eligible’] .”-“. $_REQUEST[‘day_eligible’] ; $ipe_date = $_REQUEST[‘yr_ipe’].”-“.$_REQUEST[‘month_ipe’] .”-“. $_REQUEST[‘day_ipe’] ; $notify_rights =…

| |

Don’t Believe Other People are Smarter Than You + Github is awesome

ByAnnMaria De Mars

If you want to be a programmer, entrepreneur or a statistician, the best advice that I can give is, “Don’t believe other people are smarter than you.” Sometimes that is hard advice to take. I read an interesting blog post by Ali Berlinksi, “I miss being stereotyped”, about being Asian-American and moving to an area…

|

SAS Enterprise Guide as a Programming Aid – Finding Functions

ByAnnMaria De Mars

While I believe SAS Enterprise Guide was developed to make statistical analysis easier for non-programmers, it is also a useful tool for experienced programmers. Often, I find myself thinking, “I KNOW there is  a function that does that ….” but I just can’t remember exactly what it is. Take today as an example. I have…

| |

Interestingness from WUSS: Part 2 Condensing Big Data

ByAnnMaria De Mars

Sometimes the benefits of attending a conference aren’t so much the specific sessions you attend as the ideas they spark. One example was at the Western Users of SAS Software conference last week. I was sitting in a session on PROC PHREG and the presenter was talking about analyzing the covariance matrix when it hit…

2 Comments

  1. Hi, I am writing my dissertation and im looking at the relationship teacher power (5 dep. variables) has on learner empowerment (3 dep. variables) for ELL students. I read your canonical correlation post Aug. 30 and I am doing a CONCORR on these 2 sets of variables. My question, is CONCORR doable for a small sample size? I keep reading you need 200+ for it. If not, what other procedure can be used on small sample sizes if CONCORR cannot be used? Im sorry ive been typing for 12 hours today. Thank you!

Leave a Reply

Your email address will not be published. Required fields are marked *