When merging 2 datasets with a common variable (not merge
key), how to keep both?

Answer Posted / madhavi.nowduru@gmail.com

set dataset1 dataset2;
by var;

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Are you sensitive to code walk-throughs peer review or QC review?

2615


how does sas handle missing values in procs? : Sas programming

640


What is the difference between the proc sql and data step?

667


what is snowflake schema? : Sas-di

698


how do you test for missing values? : Sas programming

583






what is the one statement to set the criteria of data that can be coded in any step? : Sas programming

654


what is the use of proc contents and proc print in sas? : Sas-administrator

611


What is the sas data set? : sas-grid-administration

576


Are you involved in writing the inferential analysis plan? Tables specfications?

2119


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

846


How would you define the end of a macro? : sas-macro

612


if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming

549


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?

710


List down the reasons for choosing sas over other data analytics tools.

815


what is sas olap server? : Sas-di

691