A best practice in SPSS is to open and save all files with syntax. Like so, it can be easily seen which syntax was run on which data. One could use the syntax generated by Paste for this but there's a much shorter and better option.

Disadvantages of the Default Syntax

Each time you open a data file from the GUI, SPSS generates syntax that may look something like

GET FILE='C:\Documents and Settings\Work\Projects 2012\December\Some Customer\Survey data.sav'.

This exact specification of the folder and the file name is known as a absolute path. Using absolute paths has two disadvantages.

If you open and save several files, the total amount of syntax will be rather large. Especially if you write (rather than paste) your syntax, this may be a bit annoying even though you can copy-paste the folder specification
If you move your project to a different folder, you'll need to correct all paths in order for them to be valid again

Shortening the Syntax

The default syntax can basically be broken up into two parts: a folder specification and a file specification. The point here is that the folder specification is needed only once during a session. The syntax below demonstrates the idea.

*Set working directory.

cd 'C:\Documents and Settings\Work\Projects 2012\December\Some Customer'.

*Open data file.

get file 'Survey data.sav'.

How Does it Work?

The CD command sets a default directory. Whenever you open or save a file, it will be done from/to this directory. In case you're not sure what your default directory is, run SHOW DIRECTORY. In subsequent commands, you only have to type the file name, which is technically a relative path. Especially when you open or save multiple files, you'll need less syntax. More importantly, if you move your project to a different folder, you'll need to adjust only a single line of syntax (the cd command, that is). Especially when a project involves multiple syntax files, this may prove a major advantage, especially when combined with INSERT.

Using Subfolders

Whenever you use relative rather than absolute paths, SPSS quietly prefixes them with the default directory. When you'd like to access a file in a subdirectory of the default directory, you can specify only the subdirectory and the file name.
For example, if your default directory is C:\project, then GET FILE 'data\data_file.sav'. will open data_file.sav from C:\project\data.

Final Notes

CD applies to all files such as

data files (SPSS, Excel or any other format)
SPSS output files
SPSS syntax files when using INSERT
SPSS chart templates (only in SPSS version 19 onwards)

except tablelooks (“SET TLOOK ...”). I find this very annoying and I don't see why this hasn't fixed ages ago...

Command Syntax Reference Saying CD does not work for TLOOK

Thanks for reading!

THIS TUTORIAL HAS 16 COMMENTS:

By Ruben Geert van den Berg on October 9th, 2019

Hi Tolga!

You can get the current directory by running SHOW DIR. but the result ends up in the output and you can't readily use it.

If you use Python with SPSS, you can have Python look up the current directory and insert it into some syntax. Python cannot -however- look up the directory of the syntax file you're running.

However, unless you run this task daily or so, it's not worth the effort I think. Perhaps use a CD command in a master syntax file and have it INSERT any other syntax files. In this case, you need to change a single line of you move the project to some other folder.

If none of that works and it really is a problem, please provide us with some more details.

Kind regards,

SPSS tutorials

1 … 4

SPSS CD Command