Hi All,
(Sytax #1) I merged two datasets, got no errors and the dataset looks as expected (23 variables).
(Syntax #2) Next I wanted to make the IN= variables permanent. I got no errors but the merged dataset is exactly the same as the previous code where # of variables=23. To test that SAS was functioning I deliberately reversed the variables on either side of the equal sign and got an error.
(Syntax #3) Then I decided to create a ‘Match variable’ with 3 different categories. But the merge dataset is still identical to before and the new match variable was not added to the dataset.
SAS 9.4 recognizes if I insert an error an also if I use the 'If a' or 'If b' options. Condensed synytax is below.
What gives?
(SYNTAX #1)
DATA all_rates;
MERGE archived_data (in=a)
recent_rates1 (in=b);
by procedure_code procedure_type;
run;
NOTE: The data set WORK.ALL_RATES has 17842 observations and 23 variables.
(SYNTAX #2)
DATA all_rates ;
MERGE archived_data (in=a)
recent_rates1 (in=b);
by procedure_code procedure_type;
archived=a;
recent=b;
run;
NOTE: The data set WORK.ALL_RATES has 17842 observations and 23 variables.
(SYNTAX #3)
DATA all_rates ;
MERGE archived_data (in=a)
recent_rates1 (in=b);
by procedure_code procedure_type;
if a and b then match='match';
if a and not b then match='archived';
if b and not a then match='recent';
run;
NOTE: The data set WORK.ALL_RATES has 17842 observations and 23 variables.
.
