Interested to Buy Any Domain ? << Click Here >> for more details...
describe about joins? briefly?
- 2 Answers
- 7111 Views
- CitiGroup, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / hardeep malhotra
Use proc sql for joins,
There are 5 types of joins in sas
1) Inner Join :- Output would be only matched cases.
2) left outer Join :- Output would be all the rows from
left table with corresponding matched value from right
table.
3) right Join :- vice versa of left Join.
4) Full outer join :- will take all matched & unmatched
rows of both the tables.
5) Product Join :- this will join the 2 tables without any
common variable.
| Is This Answer Correct ? | 11 Yes | 0 No |
we can use the set and merge commands to join the datas,use
merge if u like to joining data tables that has similar
observation and diff observation and relatted variable mean
use SET ,V can also use proc sql joing the data tables ,i am
beginner on sas so if any one have differ with my ans just
post to my mail kumarravi111@gmail.com
| Is This Answer Correct ? | 3 Yes | 1 No |
In a shcool there are 1000 students. After completion of every test in 6 subjects , each subject teacher submit the marks of every student at different times and loaded in the database commonly. How will you seperate the top two subject marks for each each studet using SAS?
1 new york 7,262,700 2 los angeles 3,259,340 3 philadelphia 1,642,900 how to read the above data using input statement consider the above data is in txt format externally u have to use infile and input statement.
Which date function advances a date, time or datetime value by a given interval?
how does sas handle missing values in a merge? : Sas programming
PROC SQL always ends with QUIT statement.Why cant you use RUN in PROQ SQL ?
How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?
what is the frontend and backend of sas? Is sas is a progaming langauge or tool? on which langauge sas depends?
What is run-group processing?
how to import XTP files into SAS datasets?
1 Answers Barclays, Institute For Plasma Research,
define table lookup and how may ways it can be done...explian
How do you control the number of observations and/or variables read or written? Approximately what date is represented by the SAS date value of 730?
what are sas bi dashboard components? : Sas-bi
Teradata 
