205 Codes trouvés ETL
RéinitialiserExamples: Combining data one-to-one
This example illustrates the use of two SET statements to combine observations from two datasets ('animal' and 'plant...
Examples: Concatenating Data
This document explains how to concatenate SAS datasets using various methods, including the SET statement, PROC SQL p...
Data Types
This document describes the data types supported by the SAS Viya CAS server, including traditional SAS types (CHARACT...
Creating a Group-By Table
This example groups the CreditQualify table by State variables and State FIPS codes, then uses Credit_Score as a weig...
Creating Variables and Filtering Data with the DATA Step
This example shows how to use the DATA step to create new variables and conditionally filter data. It uses LENGTH and...
Applying Labels and Formats
This example applies labels and formats to columns of a CAS table using the ALTERTABLE action, then displays the form...
Sans titre
This action allows you to append the rows of a source table to the end of an existing target table in a SAS Cloud Ana...
Add a CAS table with the WHERE parameter
This feature allows adding rows from a source table to an existing target table in CAS, using the 'WHERE' parameter t...
Generation of test data for process simulation
This SAS script generates a synthetic dataset simulating electronic component tests for different vendors, then expor...
Extracting Statistical Data from the KOSIS API
Macro script to extract statistical data from the Korean public API (KOSIS), transform it, and save it as SAS tables.
Calculating Grades and Averages for Students
This SAS script illustrates different ways to calculate averages, assign grades based on thresholds, and use logical ...
Data Processing and XML Export
This SAS script defines a default data source, retrieves metadata about this source, then exports its content in XML ...
Creating and Displaying School Grade Data
This SAS script illustrates basic operations of creating data tables via DATALINES, calculating new variables, modify...
Loading Data with CAS Connector (Example)
This SAS script demonstrates how to use the SAS data connector to load data from an external relational database mana...
Example of DATA STEP usage with PROC APPEND
This SAS script illustrates table creation and deletion, particularly managing dependencies when creating tables from...
SAS Table Manipulation (Filtering, Selection, and Formatting)
Fundamental DATA step examples for filtering observations, selecting variables, and applying formats.
MERGE Operations with IN= Option
This SAS script illustrates the use of the MERGE statement with the IN= option to perform different joins between two...
Executing an iterative DO loop
This script illustrates the use of an iterative DO loop in a DATA step to generate multiple output records from a sin...
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