Published on :
ETL CREATION_INTERNE

Creation of the Info Table

This code is also available in: Deutsch Español Français
Awaiting validation
This program disables page numbering via global options, then uses a DATA step to create a table named 'info'. It defines four variables (City, Country, CountryCode, CityCode) with static values for 'Sao Paulo', 'Brazil' and their associated codes. The code contains educational comments regarding syntax error handling (semicolons).
Data Analysis

Type : CREATION_INTERNE


Data is manually created within the DATA step by simple variable assignment.

1 Code Block
OPTIONS
Explanation :
Environment configuration to not display page numbers in the output.
Copied!
1OPTIONS NONUMBER;
2 Code Block
DATA STEP Data
Explanation :
DATA step generating the 'info' table. It creates a single row with the specified values for city and country.
Copied!
1DATA info;
2 City = "Sao Paulo";
3 * Semicolon missing for exercise ;
4 * Omitting smicolon produces 1 error, 2 warnings, and 3 notes;
5 Country = "Brazil";
6 CountryCode = 55;
7 CityCode = 11;
8RUN;
This material is provided "as is" by We Are Cas. There are no warranties, expressed or implied, as to merchantability or fitness for a particular purpose regarding the materials or code contained herein. We Are Cas is not responsible for errors in this material as it now exists or will exist, nor does We Are Cas provide technical support for it.