• Importing and Exporting Raw Data into SAS
    SAS

    Importing and Exporting Raw Data into SAS

    When kicking off a new data analysis project, your  data often comes in formats other than the native SAS dataset  (*.sas7bdat file)--such as  Excel spreadsheets or text files like CSV and TSV . Because SAS procedures require data in the SAS dataset format, external files must f…

    AndrewJanuary 04, 2024
  • Inserting New Rows Into Database Tables
    Database

    Inserting New Rows Into Database Tables

    The Oracle SQL command for inserting rows into a table is the  INSERT  statement. Primarily, it adds one row at a time. The basic syntax of the INSERT statement is as follows: INSERT INTO table_name ( column1 , column2 , column3 , ... ) VALUES ( value1 , value2 , value3 …

    AndrewSeptember 21, 2023
  • Table Joins
    Database

    Table Joins

    In a relational data model, it is often considered as the best practice to distribute data across multiple tables, rather than store it in a single table. This is because splitting data into related tables improves data organization, reduces redundancy and enhances data integrit…

    AndrewSeptember 11, 2023

Read more

Show more
Hands-on Guide to RegEx
inRegEx

Hands-on Guide to RegEx

"Some people, when confronted with a problem, think, 'I know, I'll…

February 25, 2024
PROC SQL: Conditional Branching with CASE-WHEN Expressions
inSQL

PROC SQL: Conditional Branching with CASE-WHEN Expressions

In certain scenarios, you may want your SQL logic to branch in different dire…

January 29, 2024
PROC SQL: Updating, Deleting, and Inserting Database Rows from SAS Studio
inSQL

PROC SQL: Updating, Deleting, and Inserting Database Rows from SAS Studio

kl jk;

January 29, 2024
PROC SQL: Writing Complex Queries
inSQL

PROC SQL: Writing Complex Queries

In our  previous tutorial,  we explored the fundamentals of writing SQL queries…

January 28, 2024
PROC SQL: A Beginner's Guide to Data Queries
inSQL

PROC SQL: A Beginner's Guide to Data Queries

SQL,  or  Structured Query Language,  is a standardized language used to intera…

January 27, 2024
Load More That is All