Spss vb

[sulakvea]

i've been using SPSS & Excel i don't even remember how long (started with SPSS DOS version in the 90's).

i had absolutely no idea that SPSS supported VBA (or rather some sort of VB). it was always given that i analyze in SPSS, and if SPSS was too "clunky" for certain things, i would tweak data in Excel. so today i accidentally clicked "scripts" and it opened what seems to be a VB editor, very similar to the one we're used to in Excel.

my question is - does anyone know what i can do with it? can i do things similar to VBA in excel, like work with columns, run reports, pull external data, etc? and is it even practical to use VB is SPSS?

P.S. i just found this. at a glance seems like you can do a lot with it
http://pages.infinit.net/rlevesqu/SampleScripts.htm#DataDoc

 

[BrianB]

A brief look at your link shows similarity with VB (not necessarily VBA)

A way to check compatibility would be to go to Excel VB editor Tools/References and see if there is anything that looks like SPSS.
If so, check it and run the Object Browser. Select the appropriate library and search the web for items there.

Try something simple first.

 

[lee91]

SPSS is a computer program used for statistical analysis.The many features of SPSS are accessible via pull-down menus or can be programmed with a proprietary 4GL command syntax language. SPSS can read and write data from ASCII text files, other statistics packages, spreadsheets and databases.