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 5645whenever 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 3769Post New Accenture SAS Interview Questions
what is dc injection braking?
What does guid stand for?
What is endurance limit and what is its value for steel ?
What is a delegate how is it type safe?
Explain the operation of grid connected central solar inverter ?
What is the minimum amount of money that should be remitted through rtgs?
What is http / console kernels in laravel?
Which is the worlds smallest and ferocious mammal?
What does ctrl z do in linux?
How do I force chkdsk?
What is front end technology in java?
Popular term ‘mobile first design’ was introduced in bootstrap from beginning?
What roles of leadership have you performed in your career so far?
Explain app bundle?
Explain the difference between a dialog program and a report?