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 5612whenever 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 3730Post New Accenture SAS Interview Questions
Please introduce yourself?
What are on-page and off-page optimization?
What are the parts of a basic sql query?
C program execution always begins with a) #include b) comment (/*-------*/) c) main() d) declaration instructions
what is purpose of use stug.
What is the provider being used to access oracle database?
Who invented merge sort?
What does soap stand for?
How would you adapt a pre-trained model to a domain-specific task?
What is typings in angular 2?
What are the two main functions of queries in databases?
Are there any keywords present in XML that cant be re-used while describing tags ? If so, list them.
What are the uses of Amazon web services?
What are the causes involved in underdevelopment of the countries that are developing?
tell me what is the ? Is it necessary to use in html5