Published on :
ETL CREATION_INTERNE

Monthly Sales Table Creation

This code is also available in: Deutsch Español Français
Awaiting validation
This script uses a standard SAS© DATA step to create the temporary table WORK.SALES_MONTH. The data, consisting of the manager's name, month, and sales amount in euros, is integrated directly into the source code via the datalines4 statement.
Data Analysis

Type : CREATION_INTERNE

Data is hardcoded in the script (datalines).

1 Code Block
DATA STEP Data
Explanation :
Creation of the WORK.SALES_MONTH table by reading internal data (datalines4). The variables AccountManager, Month, and Sales_EUR are defined and formatted.
Copied!
1DATA WORK.SALES_MONTH;
2 INFILE DATALINES dsd truncover;
3 INPUT AccountManager:$12. Month:32. Sales_EUR:32.;
4 FORMAT AccountManager:$12. Month:32. Sales_EUR:32.;
5datalines4;
6Alfred,1,1186
7Alfred,2,2125
8...
9;;;;
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.
Retour à la liste
Copyright © WeAreCAS 2014-2026
SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. WeAreCAS is an independent community site and is not affiliated with SAS Institute Inc.