Link to home
Start Free TrialLog in
Avatar of careybroph
careybrophFlag for United States of America

asked on

SPSS - Generate Data Dictionary

I have a client using SPSS that wants to migrate some data to another environment. I don't use SPSS and they client is only a "user" of SPSS, not a guru. I'm looking for a way to generate a data dictionary of their table (1000+ fields). Doesn't have to be "perfectly formatted". But if I can get something close, that would be sufficient. In SQL, you can generate a "Make Table" query, that is a good start towards a data dictionary (field name, type, size...). MS Access has the "Document" feature that is helpful. Is there a way to accomplish something similar in SPSS??
ASKER CERTIFIED SOLUTION
Avatar of richdiesal
richdiesal
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of careybroph

ASKER

So, the links you provided were great, but not perfect. Oddly, when it generated the data dictionary, it re-ordered all of the fields alphabetically, which is kinda useless (imho). BUT, it did kinda put me on the right track. I ended up going to the "variable view" tab and I was able to manually copy the content and paste it into a spreadsheet. This gave me what I was looking for. It was very odd that I couldn't export it to a CSV or something.
Thanks for your help. It got the brain juices flowing!
Scott Carey