Advanced SASRetrieving DBMS Data with a Pass-Through QueryThis article will describe retrieving DBMS data using the SQL Procedure Pass-Through Facility. A…Subhro KarMay 29, 2024 2 min
Advanced SASCount(*) vs Count(variable) in Proc SQLOne of the most common questions that SAS users have when they use Proc SQL "is": what is the…Subhro KarDecember 29, 2023 2 min
Advanced SASHow to Use SAS Macros with QuotesEver found yourself scratching your head over SAS macros with quotes ? You're not alone. SAS macros…Subhro KarSeptember 16, 2023 1 min
Advanced SASHandling Variable Arguments in SAS MacrosSAS macros use parameters to define and call them. Default values can be set for some parameters…Subhro KarSeptember 03, 2023 2 min
Advanced SASUnlock the Power of SAS ViewsDo you find SAS data manipulation to be too complex? If so, there's a solution that can make your…Subhro KarSeptember 02, 2023 5 min
Advanced SASHow to Create New Columns in PROC SQL Without a Data Step?Do you want to learn how to use the proc SQL calculated keyword in SAS? This lets you create new…Subhro KarAugust 26, 2023 4 min