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 4745whenever 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 2986Post New Accenture SAS Interview Questions
What is the use of functional interface?
What is the use of htmlentities in php?
What is cloud front?
If you define a user defined data type by using the struct keyword, is it a value type or reference type?
Define isolation?
Why your company do not pay the penalty, which was agreed in your contract?
About effort estimation ?
Explain blackberry internet service?
Does windows pro come with office?
Model a data structure for a DFA that takes an event as parameter and performs a desired action.
Which of different types of cast irons is stronger? Is their strength superior to steels?
What are activex files?
What is the difference between system.text.stringbuilder and system.string?
I need bhel electrical test pattern & paper
Apportionment of expenses