The below code we are using for creating more than one macro variables in proc sql using into clause. How we can use same code to create macro variables vara, varb, varc instead of var1, var2, var3.? proc sql noprint; select count(distinct(patient)) into :var1 - :var3 from dataset1 group by trtreg1c ; quit;
1 4767whenever we using the merging through data set merging ,we can get note in log like this "MERGE STATEMENT HAS MORE THAN ONE ONE DATASET BY REPEATED BY VAIABLES" but the output has come in good manner,whenever in in sql(full join) we can get cartion product.so How do overcome this problem in sql?
1 3000Post New Accenture SAS Interview Questions
Explain the distinction between splunk and spark?
Tell me how is it possible to parse a configuration file?
What is the difference between snapshot and ami?
What is request user in django?
How do you train another QA engineer?
What is the full meaning of gui?
Why do we use ioc in spring?
If I bring a basic electric meter from the States and hook it up in Costa Rica in a development that has only one transformer for the 50 homes, will it still be accurate regarding the usage of kilowatt hours?
The Analysis of flow of funds through an organization can be very useful to the managment. Elucidate
What is header file in c?
What is the purpose of support package?
Why we use pwd command in linux?
What will happen if i replace a inductive proximity switch with photo sensor in a machine?
How to Get the windows directory?
What is SAP TAO? · Which Version you are using? · What is the Latest Version in SAP TAO? · What are the Advantages in SAP TAO? · What are the Patches required for SAP TAO? · What is BPT? · Difference between BPT & SAP TAO? · Which Framework using for SAP TAO? · What is CBASE? · What is the SAP TAO Architecture? · What are the Prerequisites for SAP TAO? · SAP Solution Manager Mandatory for SAP TAO 1.0? · SAP Solution Manager Mandatory for SAP TAO 2.X? · What is UI Scanner? · What is Inspector? · How many ways to Create a components using TAO 1.0? · How many ways to Create a components using TAO 2.x? · Which service pack required for SAP TAO 2.7? · What is Import/Export? · What is Consolidate?