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 5633whenever 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 3759Post New Accenture SAS Interview Questions
Is it possible to change the color and font of the sheet tabs?
Explain about Declare Triggers?
Explain storage manager?
What are kernel objects?
How do I connect to a database in mysql workbench?
Is the infobus client side only?
How do you check if a variable has not been set in php?
How do I know if java is running on linux?
What is dpf in db2?
why they were using TRIAC instead relay in some controllers and what is the advantages.
What are the agents?
Explain ibm z?
How much does selenium license cost per client machine?
What is codebase?
in basic 2 phase will short means tripping the power but spot welding 2 phase shorting but not tripping it will welded why.....(Q)