Answer Posted / vij
Two types
One - to -one mergeing:
combine observations from two data sets into a single
observation in a new data set:
Match- Merging:combine observations from two data sets into
a single observation in a new data set according to the
values of a variable that is specified in the BY statement:
| Is This Answer Correct ? | 16 Yes | 3 No |
Post New Answer View All Answers
What makes sas stand out to be the best over other data analytics tools?
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?
what is the use of proc contents and proc print in sas? : Sas-administrator
Explain the use of proc print and proc contents?
How we can call macros with in data step? : sas-macro
How would you determine the number of missing or nonmissing values in computations?
How does the internal authentication work in sas? : sas-grid-administration
how does sas handle missing values in sort order? : Sas programming
data data1; input dt account; format dt date9.; cards; 1745 1230 1756 1120 1788 1130 1767 1240 ; data data2; input startdt enddt total; format startdt date9. enddt date9.; cards; 1657 1834 12300 1557 1758 16800 1789 1789 12300 1788 1345 12383 1899 1899 13250 ; proc sql; create table data3 as select * from data1 as x left join data2 as y on x.dt>=y.startdt and x.dt<=y.enddt; quit; Here, we are getting cartision product. But,I want left join report consisting of this program. It should not get duplicate values. you can modify the program also.
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;
how does sas handle missing values in functions? : Sas programming
Describe the function and untility of the most difficult SAS macro that you have written.
What are the different servers in sas? : sas-grid-administration
name some data transformation used in sas di? : Sas-di
how to debug and test the sas program? : Sas-administrator
