What are the joins,types of joins and thier functions?
Answer Posted / mehul.v.thakkar@gmail.com
There are basically three types of joins in SAS,
1. Inner Join
2. Left Join
3. Right Join
Inner Join gives the records which are present in both the
datasets.
Left join gives all the records that are present in left
dataset irrespective of whether they have a matching record
in the right dataset.
Right join gives all the records in the right dataset
irrespective of whether they have a matching record in the
left dataset.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
how does sas handle missing values in formats? : Sas programming
i have a dataset with 100 obs i want to generate title from 20th obs onwards with total observations. that should contain 100 obs.dont use firstobs and dnt split the data. use dataset block or proc report? how can we genarate;
what is sas metadata repository? : Sas-bi
what is the difference between floor and ceil functions in sas? : Sas-administrator
Describe crosslist option in tables statement?
Give an example where SAS fails to convert character value to numeric value automatically?
What are the data types in sas?
Explain the main difference between the sas procedures and functions? : Sas-administrator
what is the purpose of _error_? : Sas programming
what is the primary data source for the wrs? : Sas-bi
sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately
Hi Jeevan/Akshara I have tried to contact SASI Vats for latest Advanced SAS Programming Certification Dumps (A00-212) but have not got any response. I would highly and gratefully appreciate your assistance in this regard. If you guys have access to this, would you be kind enough to forward it to me ? I would abide by all the terms you have for this. Please, note my email id: upretigopi@yahoo.com Preti Sharma
what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming
What Proc glm does?
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