Depending on the circumstances,this method can give you a tremendous increase in efficiency.Your goal is to join two (or more) similar data sets. When we say "similar," we mean that the data sets have the same variables and variable attributes.If you are adding records to a large master file from a small update file, the savings can be even greater.Compare the following two programs:
Example – INEFFICIENTDATA UPDATE;
Here you create data set UPDATE by processing data sets MASTER and NEW sequentially.You go through all of the overhead of processing both data sets. This is unnecessary if the goal is simply to append one data set to another.
Example – EFFICIENTPROC APPEND BASE=MASTER DATA=NEW; RUN;
In the efficient method, you merely add the observations of NEW to those of MASTER without processing either data set. Before running this procedure, you should run PROC CONTENTS on both data sets to be sure that they contain the same variables with the same attributes.If this is not true, you can use the FORCE option which will usually accomplish this, but be careful.You should fully understand this option before using it.Consult the SAS documentation for your operating system.
You can also restrict which observations from the DATA= data set are appended to the BASE= data set by using a WHERE= data set option. For example:PROC APPEND
You can also accomplish the exact same goal by using PROC DATASETS:LIBNAME libref 'SAS_data_library';
orLIBNAME libref 'SAS_data_library';
SAS Programming Related Tutorials
|SASS (Syntactically Awesome Style sheets) Tutorial||R Programming language Tutorial|
SAS Programming Related Interview Questions
|Logistics Interview Questions||SAS Programming,SQL server Interview Questions|
|Clinical SAS Interview Questions||SASS (Syntactically Awesome Style sheets) Interview Questions|
|SQL Server Analysis Services (SSAS) Interview Questions||R Programming language Interview Questions|
|SAS DI Interview Questions||Advanced SAS Interview Questions|
|Base Sas Interview Questions||SAS Macro Interview Questions|
|Clinical Data Management Interview Questions|
Sas Programming Tutorial
Input And Infile
Set, Merge, And Update
Table Lookup Tools
Proc Means And Proc Uimivariate
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.