set statement is used to create a new data set using
existing data set sothat we can add new variables ,create
merge statement when we want to match the observation of
one dataset with observation of other dataset
what is the difference between SET and MERGE?
set statement is used to create a new dataset by using
already existing datasetname/and this statement is used to
concotinate the number of datasets.whenever we are using
set statment it will be added as obsevation by obsevation
level where as when we use merge it will be added as
variable by variable level.
Set and merge statement perform similar function, in case
of set statement, the two data sets are merged under
unconditional criteria, but while using merge, it works
under conditional criteria by applying the PROC SORT
procedure ., i.e., by statement used.
my problem is to export my report to xsl.i can do that.but
the problem is my report has 3 headings first heading
should be printed with the merging of (1-5)cells and
heading 2 should be of merge(2-4)cells?how to do this