A space for data analytics & AI related technical resources and discussions.
Files that do not use the WPD format are regarded as external files. Files in the WPD format have the extension .wpd. Examples of external files are flat text files and comma-separated variable files. External files can be specified using operating system pathnames, or using a filename reference. A filename reference is…
The Introduction to the DATA step article describes the general structure of the DATA step. Various statements can be used in the DATA step that enable you to read and write data, format data, manipulate data, control the order of execution of statements in the DATA step, and so on. The format of the DATA step is as…
The article Introduction to the DATA step: Reading from and writing to databases described how to access databases from the DATA step. This article discusses how you can read data from and write data to other types of files. To read and write external files, such as text files, you specify the name and location of the…
The articles Introduction to the DATA step and Introduction to the DATA step statements introduced the DATA step and describe using it with datasets. This article discusses how you can input data from, and output data to, other types of files. The DATA step can be used to read and write data using many types of file,…
The DATA step is one element of a computer program written in the SAS language; other elements include global statements, procedure steps and macros. A SAS language program does not require a DATA step – you can create a valid program using only other elements of the language, such as macro statements or procedures. The…
A DATA step view is a DATA step that has been saved in a format that enables it to be run and used as a data source by other DATA steps or procedures. The data output by the DATA step view is read as if it is a dataset. There are many reasons you might want to use a DATA step view. You can use DATA step views to create…
A catalog is a special type of file in an Altair SLC library. It can contain source code, data, logs, other entities resulting from the execution of a SAS language program. A catalog is stored in a library, and consists of a collection of catalog entries. A catalog entry has a particular type, which identifies the kinds of…
Monarch Classic vs Monarch Data Prep Studio (DPS) * Have you ever wondered what the difference is between Monarch Classic and Monarch Data Prep Studio? * When to use Classic, and When to use Data Prep Studio? * What you can do in Classic that you can't do in Data Prep Studio? * What you can do in Data Prep Studio that you…
Fiserv EFT Platform processes daily transactions related to Debit Cards and ATMs. EFT generates many reports that are critical for managing operations such as; * CD10 – Cardholder Detail * IC10 – PIN Correction File * IF66 – Fees by Network * CM40 – Merchant Unusual Activity * TD10 – Terminal Tran Detail * CM60M –…
Sagent LoanServ Platform processes daily transactions related to Mortgage Servicing. LoanServ generates many reports that are critical for managing operations such as; * RP0018-0021 MTD New Mortgage Loans * RP0260-001 Escrow Analysis Process * RP4005-000 Investor Remittance Report * RP0008-007 Mortgage Investor Trial Bal…
There's a wealth of content waiting for you to explore! Need support or have a question? Login or join our community.