SAS Institute. The Power to Know
Filter Results By:
Type Priority Fixed Release

Applied Filters: (Reset All Filters)

Type: Sample ( Reset Filter)

 
List:    – 10  of  10      Results per page:
Date Title Type
11/4/08 33814 - Collapse observations in BY-Group so values from duplicate observations have new names
There are two observations per BY-Group. The observations are collapsed into a single observation so that the values from the second observation in each group have new variable names. http://support.sas.com/kb/33/814.html, 20KB
Sample

2/28/08 24751 - Adding variables from a transaction data set to a master data set based upon a common variable
Produce a new data set by combining variables from a master data set and a transaction data set based upon a variable common to both data sets. Include only observations that the master data set contains. http://support.sas.com/kb/24/751.html, 20KB
Sample

2/21/08 24677 - One-to-many or many-to-one merge
Combine two data sets by common variables when there are duplicates in only one data set. http://support.sas.com/kb/24/677.html, 18KB
Sample

1/28/08 24752 - Perform a many-to-many merge based upon common variables
Combining multiple data sets based upon common variables when duplicates exist in more than one data set. http://support.sas.com/kb/24/752.html, 18KB
Sample

1/28/08 26061 - Updating a master data set with only nonmissing values from a transaction data set
Update a master data set with values from a transaction data set, execpt when the transaction data set contains missing values for the variable being updated. http://support.sas.com/kb/26/061.html, 19KB
Sample

1/28/08 26060 - MERGE data sets while conditionally overwriting common variables that are not the BY variable
Use a common variable to upate the values of variables in a master data set with the values of variables in a transaction data set without writing missing values to the revised master data set and without overlaying ... http://support.sas.com/kb/26/060.html, 19KB
Sample

1/28/08 24788 - Use formatted value to combine data sets
Merge multiple data sets using the formatted version of the BY variable(s) rather than the stored value. http://support.sas.com/kb/24/788.html, 18KB
Sample

1/28/08 24683 - Merge observations from multiple data sets based upon a common variable
Use match-merge to combine all data sets named on the MERGE statement based upon the variables listed on the BY statement. http://support.sas.com/kb/24/683.html, 22KB
Sample

1/28/08 24682 - Combining multiple data sets with differing attributes for the BY variable
Merge data sets with BY variables with different lengths or types. Use the format associated with a common variable from the second data set rather than the first data set. http://support.sas.com/kb/24/682.html, 20KB
Sample

1/28/08 24582 - Combine data sets based upon similar values
Encode character strings using SOUNDEX to aid in combining the data based upon similar but not exact values. http://support.sas.com/kb/24/582.html, 18KB
Sample

List:    – 10  of  10      Results per page: