205 Codes trouvés ETL
RéinitialiserETL Job Status Configuration
Macro to configure the ETL job status file which will store the status of each job.
Analysis and Transformation of Automotive Data with CAS
This SAS script configures the CAS environment, loads data from SASHELP to CAS, and then applies various transformati...
DATA Step execution example with end-of-file variable
Script illustrating the use of the END= option in a DATA step to detect the last observation and perform cumulative c...
Using the ?? modifier in INPUT
Example of using the ?? modifier to suppress read error messages.
Export SASHELP.CLASS data to CSV
This SAS script exports the content of the standard SASHELP.CLASS table to a CSV file named class.csv, including colu...
Exporting Data to CSV
Exports the sashelp.class table to a CSV file.
Manipulating Date and Datetime Formats with ANYDATE
This SAS script demonstrates the use of ANYDATE informats to read and convert different date and datetime formats int...
Data Creation and Deduplication with PROC SORT
This SAS script creates an internal dataset, then demonstrates two deduplication methods using PROC SORT: NODUP for c...
Downloading FRED Economic Data
SAS macro to download specific economic data from the FRED (Federal Reserve Economic Data) database via a URL.
SDTM DM Dataset Creation
This SAS script configures the environment, generates a Demographics (DM) domain dataset for SDTM using the %dm_creat...
Creation of Metadata for the DM Table
This SAS script creates a dataset containing metadata (column name, type, length, label) for a 'DM' table, typically ...
Investment Simulation over 5 Periods
Calculation of the future value of investments over 5 iterations via a loop.
Demonstration of DO loops in SAS
This script illustrates the difference between repetitive manual calculation and the use of a DO loop for iteration i...
Date and Time Manipulation and Formatting
This SAS script demonstrates the creation, manipulation, and formatting of date and time variables, as well as the us...
Date component extraction and manipulation
Script illustrating the extraction of temporal elements (day, month, year, quarter, weekday) from a date variable.
Dataset creation with heterogeneous dates
Example of reading dates in different formats (text, numeric) in a DATA step.
Implementation and Comparison of the '_INFILE_' Technique for Data Delimitation
This SAS script demonstrates and compares two methods for delimiting complex character strings into multiple variable...
DATA Step Partitioning and Sorting in CAS
Example of optimizing data loading into CAS with partitioning and sorting, followed by group processing.
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