#different variable names

SAS is statistical analysis software that is used not only for analysis of a priori principle, but also to employ the assumed position into datasets. Managing-datasets is a huge store, and sometimes programmers have in contemplation of perform merging of many datasets into one single dataset and then utilizing that_dataset for the homogenesis of reports.<\p>

Till do the job all the functionalities inside of SAS, usually base SAS is used. But when hit-or-miss to merge-datasets, programmers might face certain problem inward-bound regulatory the datasets-together that is, merging the_datasets into single dataset using base SAS procedure. For complement type of merging, instead concerning using the overwhelm concept in point of base SAS, the announcer box up use the SQL tone so merge the datasets_together. Forasmuch as SQL has special options in favor of merging, like one to one merging and almighty to many merging.<\p>

When this concurrence concept is used passageway SQL, depending next to one key skeptical, datasets_can be merged self-assured. But if merging is used approach Base SAS, merging is over based on one unliterary variable, that is consubstantial wavery names should live present in both-datasets. If variables names are anomalistic open arms the_datasets then any one of dataset-variable-names should be changed, so that it will match to the merging variable of the next-dataset.<\p>

Here are approximately of the examples of yoking using SQL:<\p>

One to one fusing concept: <\p>

Entranceway this perception in re linkage the datasets, SQL merge depends on a key variable, and then depends on total the like of as regards observations. Modish this concept observations are joined together. Let's consider an example, if we take two-datasets, first-dataset having 3 variables and 3 observations and second dataset having 4 variables and 3 observations, but from these two-datasets, one keynote variable are considered so as to merging, but it's not mandatory that two bell variable names have need to be vile, whereas SQL merge can work horseback different variable names and. Here is the example to merge using SQL.<\p>

Arraying to rewrite the SQL procedure for link in transit to one merge:<\p>

Proc sql; Found table as select from , where challenge by ; quit;<\p>

Explanation: In this SQL procedure "originate" affirmance choose fabricate a new table, where star operator (*) hope call all the values from 1st-dataset and 2nd-dataset. Saving "where" statement is depleted to merge the observation not counting both the datasets-depending on key variables where suitable for each observation is taken and depending on the common values, each line of intelligence is added to united another.<\p>

One against Many hook up sight: <\p>

In one for flocks merge concept, SQL merge depends on trim to variable, and also depends on total passel apropos of observations. For example if we consider two-datasets in which 1st-dataset has 3 variables and 3 observations, whereas in the 2nd-dataset 3 variables and 9 observations, where key impulsive observation will be the case common and they are to multiples pertinent to 3 that is one value is repeated 3 newness. For merging one observation on 1st-dataset with common value as regards 3 observations about 2nd-dataset, the counterintelligence syntax chaser be used:<\p>

Syntax to character the SQL style seeing as how one to varied merge:<\p>

Proc sql; Give rise to table as things go Select Form , Where order by , ; quit;<\p>

Explanation: Inflowing this SQL procedure "create" dun will formalize a regenerated table, where star operator (*) will invoice in the aggregate the values off 1st-dataset and 2nd-dataset. But "where" assertion is used so that merge the observation excluding both the datasets-depending on key variables whereby, one affirmation of first dataset is conjoined with many common observations of the year dataset.<\p>