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 4932whenever 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 3156Post New Accenture SAS Interview Questions
What are the trigger best practices?
How display code or Text of Stored Procedure using Sql query in Sql Server ?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
Would you be able to clarify blue prism lifecycle?
Can you put two constructor with the same structure in a class?
When should be sqlscript used in sap hana? : hana sql script
Low water in boiler drum is unsafe because it may result in overheating of water tubes in furnace. Why it is unsafe to have high water condition in boiler drum ?
What are rpa robots?
What do I need to submit an application?
how do I troubleshoot daos related database problems?
How can we enable visualforce editor? : salesforce visualforce
What does rdbms stand for?
What are the difference between directive and component in angular 4?
What does valet park?
Can you explain pdq priority?