Load procedure parameters from data file

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Load procedure parameters from data file

djhurio
Hi,

I have defined a procedure wit hseveral parameters. Parameters are for example:
1) The name of database;
2) The name of table;
3) The names of variables;
4) Some other parameters...

I have defined the procedure with macro command.

For example:

define !read_var(table=!tok(1)
 /class_var=!tok(1)
 /in_var_1=!tok(1)
 /in_var_2=!default (na) !tok(1)
 /out_var=!tok(1)
 /year=!tok(1)
 /source=!tok(1))

*** Data transformation comands.

 !end.


I want to run the procedure several times by changing the parameters. All the parameter values are saved in datafile as variables. For example:

year source Table in_var_1 in_var_2 out_var
2008 A augstskolas1 aile1 na var1
2008 A augstskolas2 aile3 na var2
2008 A augstskolas2 aile4 na var3
2008 A augstskolas2 aile5 na var4
2008 A augstskolas2 aile7 na var5
2007 A augstskolas2 aile9 na var6
2007 A augstskolas1 aile8 na var7
2007 A augstskolas1 aile12 na var8
2007 A augstskolas1 aile13 na var9
2007 A augstskolas3 aile1 na var10
etc...

What would be your suggestions to run the procedure according the defined parameter values? I could use WRITE OUT procedure to write the syntax file.

I am using SPSS17.