Rather than having SAS throw an error when it encounters alphabetic characters, blanks, special symbols and other invalid data in a character variable you are trying to make numeric, the ?? informat allows you to automatically assign a missing value during the character-to-numeric conversion. The post Eliminate Invalid Data Hassles with the ?? Informat Modifier appeared first on 9TO5SAS ..read more

Tired of repetitive SAS tasks? Want to generate insights faster? Google's Gemini AI Model might be the solution. Let's explore how to bring its power into your SAS environment... The post Integrating Gemini AI into SAS: appeared first on 9TO5SAS ..read more

Your current working directory is the default location SAS uses for file input and output. Learn how to easily determine this directory and organize your SAS projects effectively. The post 2 ways to Find the Current Working Directory in SAS appeared first on 9TO5SAS ..read more

Learn how to easily change your working directory using the DLGCDIR function for optimized project organization. The post How to Change Your SAS Working Directory with DLGCDIR (Tutorial) appeared first on 9TO5SAS ..read more

Closures refer to functions that capture variables from their enclosing scope, allowing those variables to be used even after the enclosing scope has finished executing. In simpler terms, a closure is a function that retains the context in which it was defined. The post Closures in Python appeared first on 9TO5SAS ..read more

Google Colab provides a free, collaborative, and cloud-based environment for writing and executing Python code. It's possible to use SQL within Colab using Python's SQLite library or magic commands. The first method involves creating a connection to an SQLite database and executing SQL queries, while the second method uses SQL magic commands to interact with a SQLite database. The post 2 ways to use SQL in Google Colab appeared first on 9TO5SAS ..read more

SAS abbreviations in SAS EG let you quickly insert code snippets by typing custom-defined abbreviations. This feature saves time and minimizes effort, especially for frequently used code blocks. You can create, modify, delete, and share abbreviations, streamlining coding processes and improving code readability. The post Save Time and Effort: Leveraging Abbreviations in SAS EG for Code Reusability appeared first on 9TO5SAS ..read more

The blog post "Free Resources to Learn SAS and Data Science" provides a curated list of free learning materials for individuals interested in acquiring knowledge and skills in SAS and data science. The resources include SAS OnDemand for Academics, free SAS programming courses, statistics playlists, advanced SAS topics, data science courses, certificate courses, free open datasets, and a tool for generating custom-formatted test data. By exploring these resources, learners can gain valuable knowledge and skills in SAS for various applications such as data science, research, and business analyt ..read more

Count(*) and Count(variable) are essential functions in Proc SQL. Count(*) returns the total rows in a table, while Count(variable) returns the non-missing values of a specific variable. When used with GROUP BY, their differences become more apparent. It's crucial to know when to use each function based on the requirement for counting in tables or groups. The post Count(*) vs Count(variable) in Proc SQL appeared first on 9TO5SAS ..read more

Learn how to check if a CSV file has data and import it into SAS. Explore different methods to check multiple CSV files for existence in SAS. The post Quick Guide: Verify Files Before Data Import appeared first on 9TO5SAS ..read more