SPSS Tips & Tricks #1
Hi, Gunilla Rudander here. As I have a lot contact with SPSS users I sometimes get SPSS Statistics questions about commands or methods. So why not share this with you? I will call this tips & tricks.
#1 Copy Data Properties
Question: I often open Excel data files and have to put on value labels, missing values and so on. How can I reuse this labels, as I repeat exactly the same every week?
Answer: There are 2 answers. You can use the syntax language, but I will show you the other answer: to reuse all properties from one file to another like a template.
2. When you are ready with all your labels and definition within the variable view, save this data file.
Example of my preparation: Have a look of my yellow markings for the attitude question (att1):
I have put a variable label (Label), value labels (Values) and missing definition 6 (Missing).
4. Now I can copy the properties from the first data file (the meta data) easily from this command:
Data – Copy Data Properties
Then just go further and all variables with same variable names as the template will appear and be copied. Just click on “next”, “next”… and so on and finally “Finish”.
Hopes that will help you!