Adding data to a SAS dataset
tom
This short article describes how to add two files with data to a SAS dataset. Assume both files use the same format for the data. The first approach uses a…
Exporting data from Teradata
Recently, I came across the so-called fast export facility in Teradata. This facility allows you to export data from Teradata in a relative fast way. Let us look at the…
Teradata BTEQ
Teradata is a DBMS that is more or less created to handle massive amounts of data. I now work with it and this DBMS is able to handle 500 million…
SVN version controller
Recently, I came accross the SVN version control mechanism. The idea is that we have a so-called working directory that acts as a source for a final version of some…
SAS en Teradata
Currently, I work with SAS and teradata. I notice, we have two possibilities to connect SAS to teradata. One possibility is to create a remote library. The definition is: libname…
Getting data from an API
Once an API is running, we may start a client. This client fires a call. This call is fired with “requests.get”. Between the brackets, we see a call that could…
Server App for APIs
I found a brilliant script to handle API requests. I noticed three elements here: it contains a server process, it is able to receive a call and it is able…
Python using API
A small example on using an API is provided below. I have attempted to make the programme as small as possible. It shows how the response is derived. This response…
Python retrieve data from an API & store in a table
This script combines many Python features, I used in the last few months. The idea is a file is read that contains parameters that are used is a API call.…
Function in Python Dataframe
Whenever we have a data in a dataframe, we might have the urge to change the values. Below, three situations will be investigated. The first situation is the situation, whereby…