whenever 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?
Answer / alok karan
if we have exactly same number of observation for each BY value in two data sets and we use merge statement to merge them then within log window we got message"MERGE STATEMENT HAS MORE THAN ONE
ONE DATASET BY REPEATED BY VAIABLES"
| Is This Answer Correct ? | 0 Yes | 0 No |
1.What is the difference between _NULL_ , _ALL_, and _N_? 2.What are the uses of _NULL_ using in Data Steps? Can we _NULL_ in Proc Steps also? 3.How do call the macro variable in Data Steps? 4.How to construct Pivot tables in Excel Using SAS?
how to import HTML files into SAS datasets?
Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager
how the sas basic syntax style described? : Sas-administrator
Enlist the functions performed by sas.
what is intially documentation for a sas programmer?
The Lion King is hosting an animal conference. All the animals in the world attend except one. Which animal does not attend?
What is a method to debug and test your SAS program?
Which is the best place to learn SAS clinicals and Oracle clinical in hyderabad?
What is the work of tranwrd function?
IS SAS COMPILER OR INTERPRETER? EXPLAIN?
3 Answers Aon Hewitt, HSBC, SCL, TCS,
what is option year cuttoff in sas