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 5775whenever 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 3918Post New Accenture SAS Interview Questions
If we are selling Cement on credit with transport charges, we are paying transport charges on cash. and this transport charges will take separate from the customer, for Example 10 bags of cement sold. 10 x 250 + 100 ( transportation charges ) = 2500+100 = 2600/-.. How I will take this entry... please guide me.
What is an intermediate bank? : fi- general ledger accounting
Is li an empty tag?
I have passed in SBI clerical exam 2009 , pls tell me what question will be asked for interview .pls mail it on my email id sawant.supriya51@gmail.com
How to detect apoptosis?
Name the three major set of files on disk that compose a database in Oracle?
What are the disadvantages of using a spreadsheet?
Which type of website is good for seo purpose?
How do you check if smtp port is open?
What is ehcache in hibernate?
Explain metadata in c#.
Why django ? What is advantages of Django ?
Explain the procedure to calculate provident fund, esi, vat and sales tax.
What is wisdom teeth problems?
How can I handle floating-point exceptions gracefully?