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
Explain how merging helps to combine data sets.
what are validation tools that are used in sas? : Sas-administrator
In sas, what are the areas that you are most interested in? : sas-grid-administration
What are the features of SAS?
how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?
Are you involved in writing the inferential analysis plan? Tables specifications?
What is interleaving in SAS?
What are the features of base sas system?
Which are the statements whose placement in the data step is critical?
how would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable? : Sas programming
Describe the function and untility of the most difficult SAS macro that you have written.
what is the limit of the number of the rows and columns available in the worksheet? : Sas-bi
what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi
how would you determine the number of missing or nonmissing values in computations? : Sas programming
Mention the difference between ceil and floor functions in sas?