SPSSINC GETURI DATA

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

SPSSINC GETURI DATA

drfg2008
Is it possible to read in CSV-files with "SPSSINC GETURI DATA"?

SAV-file works fine:

SPSSINC GETURI DATA
URI="http://spss-seminar.de/tu-berlin.sav"
FILETYPE=SAV DATASET=frank
/OPTIONS
SHEETNUMBER=1 READNAMES=YES ASSUMEDSTRWIDTH=32767.


... and this would be the csv file ...

GET DATA
  /TYPE=TXT
  /FILE='C:\user\...\filename.csv'
  /DELCASE=LINE
  /DELIMITERS=";"
  /ARRANGEMENT=DELIMITED
  /FIRSTCASE=2
  /IMPORTCASE=ALL
  /VARIABLES=
  id F10.0
  name_de A45
  begin A16
  League A30
  StandardMarketVolume F15.0
  standard_Back_1 F15.2
  standard_Lay_1 F15.2
  standard_Back_2 F15.2
  standard_Lay_2 F15.2
  PB2SMarketVolume F15.0
  pointbet2sets02back F15.2
  pointbet2sets02lay F15.2
  pointbet2sets12back F15.2
  pointbet2sets12lay F15.2
  pointbet2sets20back F15.2
  pointbet2sets20lay F15.2
  pointbet2sets21back F15.2
  pointbet2sets21lay F15.2.
CACHE.
EXECUTE.

... but however combining both, I only get error messages ...
Dr. Frank Gaeth

Reply | Threaded
Open this post in threaded view
|

Re: SPSSINC GETURI DATA

David Marso
Administrator
As usual Frank,
You fail to provide the essential information necessary for others to assist you!
How are you "combining" these?
What are the error messages?
From what I glean reading *THIS* thread which you initiated in Feb,
http://spssx-discussion.1045642.n5.nabble.com/get-data-td3403038.html
unless something has changed then SPSSINC GETURI DATA reads
SPSS,XLS,SAS,STATA...

From Jon Peck's post in that thread!
"Here is the beginning of the help (SPSSINC GETURI DATA /HELP).
spssinc geturi data/help.
SPSSINC GETURI DATA URI="uri including filename"
FILETYPE={SPSS* | XLS | SAS | STATA}  ....."
HTH, David
* Please be more complete with diagnostic information/error messages... in future posts!
------

drfg2008 wrote
Is it possible to read in CSV-files with "SPSSINC GETURI DATA"?

SAV-file works fine:

SPSSINC GETURI DATA
URI="http://spss-seminar.de/tu-berlin.sav"
FILETYPE=SAV DATASET=frank
/OPTIONS
SHEETNUMBER=1 READNAMES=YES ASSUMEDSTRWIDTH=32767.


... and this would be the csv file ...

GET DATA
  /TYPE=TXT
  /FILE='C:\user\...\filename.csv'
  /DELCASE=LINE
  /DELIMITERS=";"
  /ARRANGEMENT=DELIMITED
  /FIRSTCASE=2
  /IMPORTCASE=ALL
  /VARIABLES=
  id F10.0
  name_de A45
  begin A16
  League A30
  StandardMarketVolume F15.0
  standard_Back_1 F15.2
  standard_Lay_1 F15.2
  standard_Back_2 F15.2
  standard_Lay_2 F15.2
  PB2SMarketVolume F15.0
  pointbet2sets02back F15.2
  pointbet2sets02lay F15.2
  pointbet2sets12back F15.2
  pointbet2sets12lay F15.2
  pointbet2sets20back F15.2
  pointbet2sets20lay F15.2
  pointbet2sets21back F15.2
  pointbet2sets21lay F15.2.
CACHE.
EXECUTE.

... but however combining both, I only get error messages ...
Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me.
---
"Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis."
Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?"
Reply | Threaded
Open this post in threaded view
|

Re: SPSSINC GETURI DATA

Jon K Peck
In reply to this post by drfg2008
No.  GETURI DATA does not support CSV format.  It supports sav, SAS, Stata, and Excel IIRC.

Regards,

Jon Peck (no "h")
Senior Software Engineer, IBM
[hidden email]
new phone: 720-342-5621




From:        drfg2008 <[hidden email]>
To:        [hidden email]
Date:        08/14/2011 12:43 AM
Subject:        [SPSSX-L] SPSSINC GETURI DATA
Sent by:        "SPSSX(r) Discussion" <[hidden email]>




Is it possible to read in CSV-files with "SPSSINC GETURI DATA"?

SAV-file works fine:

SPSSINC GETURI DATA
URI="
http://spss-seminar.de/tu-berlin.sav"
FILETYPE=SAV DATASET=frank
/OPTIONS
SHEETNUMBER=1 READNAMES=YES ASSUMEDSTRWIDTH=32767.


... and this would be the csv file ...

GET DATA
 /TYPE=TXT
 /FILE='C:\user\...\filename.csv'
 /DELCASE=LINE
 /DELIMITERS=";"
 /ARRANGEMENT=DELIMITED
 /FIRSTCASE=2
 /IMPORTCASE=ALL
 /VARIABLES=
 id F10.0
 name_de A45
 begin A16
 League A30
 StandardMarketVolume F15.0
 standard_Back_1 F15.2
 standard_Lay_1 F15.2
 standard_Back_2 F15.2
 standard_Lay_2 F15.2
 PB2SMarketVolume F15.0
 pointbet2sets02back F15.2
 pointbet2sets02lay F15.2
 pointbet2sets12back F15.2
 pointbet2sets12lay F15.2
 pointbet2sets20back F15.2
 pointbet2sets20lay F15.2
 pointbet2sets21back F15.2
 pointbet2sets21lay F15.2.
CACHE.
EXECUTE.

... but however combining both, I only get error messages ...

-----
Dr. Frank Gaeth
FU-Berlin

--
View this message in context:
http://spssx-discussion.1045642.n5.nabble.com/SPSSINC-GETURI-DATA-tp4697639p4697639.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

Reply | Threaded
Open this post in threaded view
|

Re: SPSSINC GETURI DATA

drfg2008
Thanks Jon

@David:

As usual Frank,
You fail to provide the essential information necessary for others to assist you!


- as usual?
Dr. Frank Gaeth