There are a few other ways to pull data into SPSS from a data warehouse using the data feed option.
One way is to use the LOAD DATA
procedure. This procedure allows you to load data from a variety of sources, including data feeds. To use the LOAD DATA
procedure, you will need to know the URL of the data feed. You can then use the following syntax to load the data into SPSS:
LOAD DATA
INFILE "https://www.example.com/datafeed.xml"
DBMS "XML"
REPLACE;
Another way to pull data into SPSS from a data warehouse using the data feed option is to use the GET DATA
procedure. This procedure allows you to import data from a variety of sources, including data feeds. To use the GET DATA
procedure, you will need to know the URL of the data feed and the format of the data. You can then use the following syntax to import the data into SPSS:
GET DATA
/TYPE=XML
/FILE="https://www.example.com/datafeed.xml"
/ENCODING="UTF-8"
/VARIABLES="variable1, variable2, ...";
Finally, you can also use the IMPORT
procedure to pull data into SPSS from a data warehouse using the data feed option. This procedure is similar to the LOAD DATA
procedure, but it allows you to import data into a variety of formats. To use the IMPORT
procedure, you will need to know the URL of the data feed, the format of the data, and the destination file. You can then use the following syntax to import the data into SPSS:
IMPORT
FROM "https://www.example.com/datafeed.xml"
OF XML
INTO WORKING MEMORY
/VARIABLES="variable1, variable2, ...";
I hope this doesn't dive away from your question !
------------------------------
Youssef Sbai Idrissi
Software Engineer
------------------------------
Original Message:
Sent: Wed November 02, 2022 10:50 AM
From: Art Jack
Subject: Data Feed from Data Warehouse
I'm trying to figure out how to pull data into SPSS from a data warehouse using the data feed option in the dw. I tried putting the data feed path into the get internet data in SPSS, but got an error message. Is there another way of doing this? thanks Art
- it's an atom feed
------------------------------
Art Jack
------------------------------
#SPSSStatistics