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 5713whenever 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 3838Post New Accenture SAS Interview Questions
What is meant by sequence control of ac voltage regulators?
how options are different than equities?
Is mongodb support null values?
Is mongodb a backend?
Give some examples of power electronics applications in the day-to-day life?
What are locks in sql?
What is the best alternative to wordpress?
How to find a specific value in an array?
How load testing can be done with silk international?
Define artificial active immunity, and give an example?
How can I make an AJAX call?
What is metadata in context of a datawarehouse and how it is important?
What is bootstrap breadcrumb?
What is struts2 in java?
What is 10base-t?