how to write code for left outer join in SAs using datastep?
Answer Posted / pnprasad
There is no such Inner & Left Joins. In SAS only one join
i.e Right Join. If you want Left Join you have to use the
data set in the second place. For example: D1 D2 are the
data sets for D2 you want to make, UPDATE D1 D2;
| Is This Answer Correct ? | 1 Yes | 22 No |
Post New Answer View All Answers
What is SAS?
What versions of SAS have you used (on which platforms)?
In sas admin differentiate between roles and capabilities? : sas-grid-administration
If you have a dataset that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variables?
explain the key concept of sas? : Sas-administrator
Mention what is SAS data set?
What are the scrubbing procedures in sas?
how to do user inputs and command line arguments in sas?
what is metadata? : Sas-bi
What are the parameters of scan function?
Are you sensitive to code walk-throughs peer review or QC review?
if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation
In proc transpose and data step with arrays which one you pick?
What is the command used to find missing values?
What is the use of %include statement?