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
Base SASWhy PROC APPEND in SAS Beats SETEfficient concatenation of datasets is a frequent requirement in the realm of data management with…Subhro KarSeptember 09, 2023 7 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
Advanced SASThe Power of Proc SQL Subqueries in Data AnalysisPROC SQL is a powerful procedure in SAS that allows users to manage and retrieve data in a…Subhro KarAugust 12, 2023 9 min
Autocall Macro Facility in the SASWhen you submit a macro definition, the macro processor compiles and stores the macro in a SAS…August 05, 2023 5 min
How to convert a Unix datetime to a SAS datetimeYou can convert a Unix datetime to a SAS datetime by adding the number of seconds in 10 years. The Number of seconds between 01JAN1960 and 01JAN1970 is 315619200.April 30, 2023 1 min
Advanced SASTracking Changes in SAS Datasets -SAS Audit TrailSAS Audit trails are crucial in maintaining the integrity and accuracy of data. In the field of SAS…Subhro KarApril 09, 2023 4 min
Base SASUsing LIBNAME XLSX to read and write Excel filesReading Excel files with LIBNAME XLSX You can use the XLSX engine to read from and write to a…Subhro KarApril 06, 2023 1 min