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 5388whenever 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 3515Post New Accenture SAS Interview Questions
Why do we use templates?
Give me sample test cases for smoke testing
How can i explain my project during interview?many time i expalain my project but they did't accept? please explain me.
What are types of indexes in sql?
How to sort an array in java without using sort method?
What is a replace command?
What is Schema on Read and Schema on Write?
What are the two ways to create rdd in spark?
Do I need to learn python for machine learning?
Everybody, I just have joined this Forum with a hope to get help from you all.Last Week I finished SAP CRM training and presently looking for jobs. Any help from you guyzs will be greatly appreciated. To start with if I can get INTERVIEW QUESTIONS & ANSWERS mailed to me at rajkumarfreblore@gmail.com.
What is the best server software?
What is mysql shell?
What is css radial-gradient() function?
How to Show two forms allowing the first to retain focus ?
Is c++ still in demand?