XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 Go to previous topicPrev TopicGo to next topicNext Topic
Megan DouglasSubject: SYNTAX not working
Author: Megan Douglas
Date: 29 Jul 2008 06:06 PM
I have a file in Excel -
(Excel file is all numbers)

I can open Excel in SPSS (version 16)

I am trying to use a syntax (used previously as text file) and will now not run on excel file

Syntax begins:

DATA LIST FILE = ‘C:\driveandlocation.xls” (not the actual file name, but close)

please see below for the warning I receive when I run the syntax: (there are more 1102, but I didn't want to totally bombard you)

>Warning # 1102

>An invalid numeric field has been found. The result has been set to the

>system-missing value.

>Command line: 20 Current case: 1 Current splitfile group: 1

>Field contents: '!'

>Record number: 1 Starting column: 18 Record length: 8192

>Warning # 92

>The limit of MXWARNS warnings in this data pass has been printed. Further

>warnings have been suppressed.

What is really strange, is that the syntax is performing all command, EXCEPT the first command, which is reading the original excel file

If you can please tell me where I went wrong, I would appreciate it greatly!

Tony LavinioSubject: SYNTAX not working
Author: Tony Lavinio
Date: 29 Jul 2008 09:18 PM
What does this have to do with Stylus Studio or XSLT?

Topic Page 1 2 3 4 5 6 7 8 9 Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.