Welcome to the North American Subaru Impreza Owners Club Tuesday March 19, 2024
Home Forums Images WikiNASIOC Products Store Modifications Upgrade Garage
NASIOC
Go Back   NASIOC > NASIOC Miscellaneous > Off-Topic

Welcome to NASIOC - The world's largest online community for Subaru enthusiasts!
Welcome to the NASIOC.com Subaru forum.

You are currently viewing our forum as a guest, which gives you limited access to view most discussions and access our other features. By joining our community, free of charge, you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is free, fast and simple, so please join our community today!

If you have any problems with the registration process or your account login, please contact us.







* As an Amazon Associate I earn from qualifying purchases. 
* Registered users of the site do not see these ads. 
Reply
 
Thread Tools Display Modes
Old 12-10-2003, 02:17 PM   #1
well_armed
Scooby Specialist
 
Member#: 15204
Join Date: Feb 2002
Default Any SPSS users here?

Just wondering if there are any SPSS experts here.

I need to find the quickest and cleanest way of exporting SPSS output files into Excel.

As of now I copy the table, paste special (unicode text), and it comes out clean. However, I have to do this one table at a time. I cannot select all the tables and paste special. Any ideas on how to do this for all the tables, and have it come out looking clean (exporting in HTML format, and pasting from there just sucks)?

Thanks,

Doug
* Registered users of the site do not see these ads.
well_armed is offline   Reply With Quote
Sponsored Links
* Registered users of the site do not see these ads.
Old 12-10-2003, 02:31 PM   #2
Kaiser
The Fellas fella
 
Member#: 7170
Join Date: Jun 2001
Chapter/Region: NESIC
Vehicle:
Aut Kaiser,
aut nullus.

Default

Don't know much about it, but it seems you can only easily do that in version 11.5 or later. Is that what you're running?

Quote:
Export SPSS output to Excel: Easily export pivot tables, including the current view or all layers, to Excel. Put SPSS tables (including those created in SPSS Tables) on the same sheet or on separate sheets in the same Excel workbook file.
http://216.239.59.104/search?q=cache...hl=en&ie=UTF-8
Kaiser is offline   Reply With Quote
Old 12-10-2003, 02:47 PM   #3
well_armed
Scooby Specialist
 
Member#: 15204
Join Date: Feb 2002
Default

Nope, we are running 9 or something. Thanks for the link, I will try and convince the big cheese that we need an upgrade cause it will improve efficiency.

dP
well_armed is offline   Reply With Quote
Old 12-10-2003, 04:49 PM   #4
BuddyChrist
Scooby Specialist
 
Member#: 35083
Join Date: Apr 2003
Default

go get 11.5 things becoem much easier with this version.
BuddyChrist is offline   Reply With Quote
Old 12-10-2003, 05:11 PM   #5
jashon
Scooby Newbie
 
Member#: 29067
Join Date: Nov 2002
Default

you have to play around w/excel macros once you output the spss data
jashon is offline   Reply With Quote
Old 12-10-2003, 05:12 PM   #6
JewPac42
Scooby Guru
 
Member#: 23260
Join Date: Aug 2002
Chapter/Region: BAIC
Location: -=3/1 Jew Crew=-
Vehicle:
Patr ick Willis
for Rookie of the year

Default

Quote:
Originally posted by well_armed
Nope, we are running 9 or something. Thanks for the link, I will try and convince the big cheese that we need an upgrade cause it will improve efficiency.

dP
ygpm
JewPac42 is offline   Reply With Quote
Old 12-10-2003, 05:29 PM   #7
well_armed
Scooby Specialist
 
Member#: 15204
Join Date: Feb 2002
Default

Quote:
Originally posted by BuddyChrist
go get 11.5 things becoem much easier with this version.
Yeah, but according to my boss it is only a little bit better

Every day I am at my job I want to shout at my boss: "You are a friggin moron...the only reason you are my boss is because everyone quit and you *poof*suddenly had seniority!"
well_armed is offline   Reply With Quote
Old 12-10-2003, 05:37 PM   #8
BuddyChrist
Scooby Specialist
 
Member#: 35083
Join Date: Apr 2003
Default

your boss is wrong, 11.5 is soooo much better then 9 and 10, alot easier to use. added more cool chart options.
BuddyChrist is offline   Reply With Quote
Old 12-10-2003, 05:45 PM   #9
well_armed
Scooby Specialist
 
Member#: 15204
Join Date: Feb 2002
Default

Well, I use excel for all my chart making. It is much more powerful and useful than SPSS will ever be for charts...getting the data into excel in a fast/clean way is what I am after.

I downloaded the trial, tomorrow I will test it out. Thanks!
well_armed is offline   Reply With Quote
Old 12-11-2003, 01:40 AM   #10
Sheep
Scooby Newbie
 
Member#: 43961
Join Date: Sep 2003
Location: San Francisco
Vehicle:
2004 WRX

Default

Try this.

http://pages.infinit.net/rlevesqu/Sa...#SampleScripts (under the Excel section)

I don't have SPSS on my home machine, but one of these scripts should do the trick. To use, just produce your output tables as you normally would. Then open this script file and run it--it should automatically open Excel and transfer all tables in your output window there.
Sheep is offline   Reply With Quote
Old 12-11-2003, 01:53 AM   #11
speedblind
Scooby Specialist
 
Member#: 42202
Join Date: Aug 2003
Chapter/Region: BAIC
Default

Side question: can you change the chart intervals in v.11.5? The version I have just "chooses" intervals for each axis and it drives me nuts.
speedblind is offline   Reply With Quote
Old 12-11-2003, 02:04 AM   #12
CosmoTheCat
Scooby Newbie
 
Member#: 3409
Join Date: Jan 2001
Chapter/Region: NWIC
Location: Oly
Vehicle:
98 My FMIC
Is bigger than yours.

Default

ugh. I hate SPSS. Er, perhaps I just don't care about statistics so it bores me to death.


Have fun with that Doug.
CosmoTheCat is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Any drixoral users here? Einzelherz Off-Topic 3 05-23-2008 03:36 PM
Any proactiv users here? Starscream Off-Topic 75 09-02-2006 08:13 AM
Any Netflix users here? athakur999 Texas Impreza Club Forum -- TXIC 21 08-25-2005 06:22 PM
OT: any Linux users here? henryh Vancouver Impreza Club Forum -- VIC 1 04-10-2003 11:08 AM
Any Handspring users here? redobs New England Impreza Club Forum -- NESIC 13 09-27-2000 05:59 PM

All times are GMT -4. The time now is 02:53 AM.


Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Powered by Searchlight © 2024 Axivo Inc.
Copyright ©1999 - 2019, North American Subaru Impreza Owners Club, Inc.

As an Amazon Associate I earn from qualifying purchases.

When you click on links to various merchants on this site and make a purchase, this can result in this site earning a commission
Affiliate programs and affiliations include, but are not limited to, the eBay Partner Network.