Samples & SAS Notes > Common Programming Tasks
>
Combining Data
| Date | Title | Type | ||
|---|---|---|---|---|
| 10/5/09 |
37328 - SAS evaluates ALL the expressions in an IF statement All expressions in a IF statement are evaluated, even when the first one is false. http://support.sas.com/kb/37/328.html, 20KB |
Usage Note | ||
| 8/12/09 |
25273 - How to combine SAS generation data sets into one SAS data set Use PROC CONTENTS to obtain the information on how many generation data sets exist and the maximum number of generations that can exist. http://support.sas.com/kb/25/273.html, 18KB |
Sample | ||
| 5/7/09 |
24747 - Determine which data set contributed an observation Use the IN= data set option to create a boolean variable that is set to one or 'true' to indicate whether the data set contributed data to the current observation. http://support.sas.com/kb/24/747.html, 18KB |
Sample | ||
| 2/27/09 |
24652 - Generate every combination of observations between data sets Create a cartesian product between two data sets using the DATA step instead of <a href="http://support.sas.com/kb/25270.html">PROC SQL</a>. No common variable is required. http://support.sas.com/kb/24/652.html, 19KB |
Sample | ||
| 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 | ||
| 3/18/08 |
3947 - FIRSTOBS= OPTION is not applicable with MODIFY statement Since the MODIFY statement opens a SAS data set in update mode, the default value for FIRSTOBS= OPTION is 1. This cannot be changed by specifying the FIRSTOBS= OPTION with a higher value. This is currently ... http://support.sas.com/kb/3/947.html, 18KB |
Usage Note | ||
| 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 |
24685 - Merge two data sets with no common variable Perform a One-to-One MERGE by combining two data sets horizontally. No BY statement is used. http://support.sas.com/kb/24/685.html, 17KB |
Sample | ||
| 2/21/08 |
24679 - Merging data sets by a common variable and create output data sets based upon observation origin Combine multiple data sets based upon a common variable. Create new data sets: one for observations found in both data sets and 2 other data sets for observations found in one data set only. http://support.sas.com/kb/24/679.html, 21KB |
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 | ||
