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 4844whenever 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 3075Post New Accenture SAS Interview Questions
Why is sorting and classifying important?
How many types of installations?
What is interceptor in angularjs?
Which method has beenintroduced in asp.net 4.0 to redirect a page permanently?
How do I download php for windows?
What are the phases of a formal review?
What is the purpose of pythonpath environment variable?
Explain an account group. What does it control?
Explain the callback functions in cakephp?
what is load capacity of 11 cm cylinder bor 100kg. pressor?
What does the term sticky session mean in a web-farm scenario? Why would you use a sticky session? What is the potential disadvantage of using a sticky session?
What is the difference between linux and android?
what is the extension of SPDS Dynamic cluster tables?
what is minimal vs. Verbose monitoring?
Can a pointer be volatile in c?