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 5716whenever 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 3844Post New Accenture SAS Interview Questions
What is the proporties of application pool in iis?
what is the meaning of dynamic processing in vsam?
Explain what is a bundle?
What is the use of implements in lightning component?
Do I need a microsoft account to use outlook?
What return value must conversion operators have in their declaration?
What is sql keyword?
What does flatten do in pig?
What is coelom? To which structures do coeloms give birth?
What is antiforgerytoken mvc5?
Can anyone tell me please how can I go and introduce the discount condition type in the pricing procedure and how it’s going to impact with tax all the pricing getting to calculate in the order? For example, how specially I have a customer who I set out as an international customer and as a domestic customer what are the differences between that… is there tax is different, is there any fright different, is there any pricing different????
What is the block size in Hadoop?
i am venkat i got gre 930(verbal 270 quanta 660) and my toefl score 105..here question is why u got less score in gre ? what i supposed to tell...any chance of rejection is there...my accadamics record is very good
What is the use of member in pf?
What do sale t-code stand for?