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 a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?
why is sas considered self-documenting? : Sas programming
What do you understand by the term Normal Distribution?
Give an example where SAS fails to convert character value to numeric value automatically?
name several ways to achieve efficiency in your program? : Sas programming
What are the functions which are used for character handling functions?
what are the categories that sas informats are used to the place the data? : Sas-administrator
Which are the statements whose placement in the data step is critical?
How necessary is it to be creative in your work?
What sas features do you use to check errors and data validation?
what do the sas log messages "numeric values have been converted to character" mean? : Sas programming
what is sas data set?
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 the difference between %local and %global? : sas-macro
how would you determine the number of missing or nonmissing values in computations? : Sas programming