ssms-database-drop-create-object.jpg

<div>
<div class="content wysiwyg-content">
Experts,<br />
<br />
I have moved from a SAS environment where I was able to use macros for repetitive code. &nbsp;My environment know is SQL through DBX. &nbsp;The queries are basically the standard SQL/ &nbsp;Is there a way to use macros?
</div>
</div>


Experts,

I have moved from a SAS environment where I was able to use macros for repetitive code.  My environment know is SQL through DBX.  The queries are basically the standard SQL/  Is there a way to use macros?

Macros in Sql

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

The Statistical Analysis System (SAS) programs consist of two steps, the DATA step and the PROC step. The DATA step reads data and prepares it for use by subsequent DATA or PROC steps. A SAS procedure (PROC) is a collection of statements that execute a certain task. SAS procedures have their own statements and commands, but many are shared among procedures. JMP is the graphical user interface for SAS, and is used in applications such as Six Sigma, quality control and engineering, design of experiments and scientific research.