205 Codes trouvés ETL
RéinitialiserCAS Table Partitioning and Sorting
Demonstration of CAS performance optimization through data partitioning and sorting during loading.
Using LAG and DIF Functions
This SAS script demonstrates the use of LAG and DIF functions within a DATA STEP to create new variables based on pre...
Creating permanent and temporary SAS tables
SAS script demonstrating the creation of a permanent and a temporary data table from internal data, followed by displ...
Creation of sample addresses
This SAS script creates a dataset containing sample addresses from various locations using embedded data (datalines).
Creation of a 'ratings' dataset
This script creates a SAS dataset named 'ratings' containing numerical ratings and their associated textual description.
Creation of the PROPERTY_COSTREVENUE table via DATALINES
Creates the temporary table WORK.PROPERTY_COSTREVENUE from data integrated directly into the SAS script.
Creation of historical sales data
This SAS script creates a dataset named WORK.SALES_HISTORIC containing historical sales data for various Account Mana...
Monthly Sales Table Creation
Generation of a dataset containing monthly sales per account manager.
Creation and Addition of ContactType Data
This SAS script creates a temporary dataset `work.ContactType` from literal data (datalines) and then appends it to a...
Table creation and column filtering
Script creating a table with dynamic variable selection and displaying the result.
Case Management in SAS String Comparisons
This SAS script demonstrates different methods of managing case during string comparisons to assign a status based on...
Calculation of New Columns and Formatting
This program uses a DATA step to create a new table from SASHELP.CARS, by filtering data, calculating new columns, ap...
Data Creation with Variable Filter and Display
Generation of a temporary table filtering variables by prefix, followed by its printing.
Test of the LENGTH function
Simple demonstration of the LENGTH function's behavior on various character strings.
Simplified String Concatenation
Demonstration of CATX function's efficiency for string concatenation compared to traditional methods.
Merging datasets and creating reports
This SAS script creates two datasets, sorts them, then merges them in different ways (standard, inner, outer). The re...
SAS Data Concatenation and Appending Techniques
Comparative demonstration of three methods to concatenate datasets: Data Step, Append Procedure (encapsulated in a ma...
Data Creation and WORK Library Management
The script creates a temporary SAS dataset named THREEROWS and executes PROC DATASETS on the WORK library.
Derniers codes ajoutés
All categories Action Administration Algorithme Algorithmic Base SAS CAS CASL Chart Code Quality / Unit Test Combine Data Configuration Connectivity Control Flow Data Data Access Data Access and Manipulation Data Analysis Data Analysis, Data Exploration Data Creation Data Exploration Data Exploration and Reporting Data Integration Data Loading Data Management Data Manipulation Data Preparation Data Processing Data Processing and Reporting Data Quality DATA Step DATA Step Programming Date Functions Development Development/Debug Documentation Documentation/Information Dynamic Programming ETL ETL, Data Transformation ETL, Macro, Performance Analysis ETL, Reporting ETL, Reporting, Statistics ETL/Reporting Export FedSQL File Management Finance Flow Control Function Function / Macro Fundamental Concepts Général Graph Graphic Graphic Utility Graphical Reporting Interface/Legacy Interoperability / Web Service Invalid Syntax Language Language Fundamentals Library Management Machine Learning Macro Macro / Documentation Macro / System Macro & ETL Macro Documentation Macro Programs Macro Test Macro, ETL Macro/Function Mapping Mixed Modeling Natural Language Processing (NLP) Other Performance Predictive Modeling Programming Quality / Test Reporting SAS Engines SAS Functions SAS Library Management SAS Macro SAS Programming SQL SQL Query Language Statistic Statistical Statistical Modeling Statistics Statistics, Administration Statistics, ETL, Reporting Statistique System Utility Test Test / Code Quality Test / Macro Test, Macro Tests Text Analysis Text Analysis, Machine Learning Tools Troubleshooting Tutorial / Reports Unclassified Unit Test Unit Tests Utility Utility Macro Variable Control Visualization Web Service Web Services Web/Reporting