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
|
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! ------
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?" |
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 |
Free forum by Nabble | Edit this page |