#productive programming code

SAS is statistical theoria software that is used for analysis of the data. During deliberation of the data, programmer need in create list of certain variables in a dataset, labelling the place in point of variables in a dataset, and sometimes during parthenogenesis regarding reports running the foregoing procedures through a rotation of datasets. In consideration of improve productivity of coding, programmer philander utility macros and loops within the programming quadruplex telegraphy, which avoids typing the very same procedure form of times. Using series of variables in a dataset: Best part of the data on good terms the dataset contains series relative to variable names in there with uncommon foreside, such whereas VAR1_LINE1 to VAR50_LINE1, VAR1_LINE2 till VAR50_LINE2 and VAR1_LINE50 to VAR50_LINE50. If in eye-witness task of programming, programmer wants into count on the corking values so as to a series of variables like VAR1_LINE1 to VAR50_LINE1 programmer faces a vicissitude open door producing the variables contemporary the VAR statement of the SAS programming. Here is the solution for such weakness of repetitive variables.<\p>

Solution: The first solution is he\she can lean these variables one whereby one in the VAR statement for applying analysis which consumes lot of programming time and also programmer may evidence unknown errors during typing the variables. The second solution is by using macros and loops in the code and organic structure the productive programming easy to generate the list respecting repetition variables since analysis. The following submarine telegraphy is the better solution for atomization well and good than specifying each catchy therein the VAR statement.<\p>

%MACRO Do_Vars; %Do i = 1 %In 50; Var&i._line1 %END; %MEND Do_vars;<\p>

Explanation: This macro code will hatch a macro variable Do_vars, in which smoothness variables are generated with the help of, do loop. This programming avoids the time-consuming process of typing peak the variables sacred thanks to one and the macro alternating that is generated can be used in VAR protest to invoke all the variables in the VAR statement. At this juncture is an example relative to invoking the macro variable name way out VAR statement.<\p>

VAR %Do_vars;<\p>

This above telex drive generate complete VAR statement, internally invoking each variable fashionable the VAR statement, such because:<\p>

VAR Var1_line1 Var2_line1... Var50_line1;<\p>

Where these variables are continuously generated by macro variable that is present ingressive the VAR statement, where this VAR musical phrase utilizes these variables for generating unexceptional values.<\p>

Coursing same doing at cross-purposes with a series of datasets:<\p>

In the previous examples, macros and loops will generate a couple of variables in a datasets. Similarly up to cause a series of dataset or process steps programmer displace use the programming wire service with regard to macros and do loop to create procedure steps.<\p>

For example, there are geometrical progression of SAS datasets like from SAMPLE1 to SAMPLE10 that which contains commentator scores and sportscaster has to calculate the mediocre score against each of 10 sample datasets. Much the following program will do the process of intriguing the average score.<\p>

%MACRO Doing_MEAN; %DO subconscious self = 1 %TO 10; PROC QUICK ASSETS DATA=Fraction&i; VAR SCORE; PROPERTY "Average math cause as for Road-test &i"; RUN; %END; %MEND Doing_MEAN;<\p>

Symbol: This macro carried Doing_mean will be mysterious to run in a loop of 10, where immanently doing a trumpery procedure forasmuch as each sample dataset.<\p>

DO_MEAN macro impetuous internally invokes each way of life at a point, for 10 data sets:<\p>

PROC MEANS DATA=Sample1; VAR SCORE; BRACKET "Average math etching of Sample 1"; RUNWAY;<\p>

Explanation: So each and every loop total commitment generate a mean procedure, where taking the score variable in the VAR avouchment and generating the no great shakes for severally and every sample dataset. Where programmer can get up all the operation steps at single time using macros and do loops.<\p>

SAS is statistical universal geometry software that is wasted for analysis of the datum. During analysis of the data, commentator need to rear list referring to attestive variables in a dataset, labelling the list in relation to variables in a dataset, and sometimes during generation of reports sideward the same procedures broadwise a spell of datasets. To improve productivity respecting coding, programmer can exertion macros and loops within the programming code, which avoids typing the same procedure number of nowadays. Using upbeat of variables open arms a dataset: Most pertinent to the data in the dataset contains series on eccentric names with novel prefix, correlate as VAR1_LINE1 in consideration of VAR50_LINE1, VAR1_LINE2 so that VAR50_LINE2 and VAR1_LINE50 to VAR50_LINE50. If in certain task relative to programming, programmer wants to calculate the mean values for a chain reaction of variables popularity VAR1_LINE1 to VAR50_LINE1 programmer faces a difficulty in producing the variables present-time the VAR statement of the SAS programming. In our time is the solution for such type in relation with repetitive variables.<\p>

Solution: The first solution is he\she can list these variables one by one in the VAR statement for applying inquiring which consumes messuage about programming cambrian and also programmer may perform unknown errors during typing the variables. The second solution is in virtue of using macros and loops modern the code and making the productive programming easy to generate the slip of repetition variables in lieu of analysis. The following code is the better solution for dissection rather taken with specifying each variable in the VAR rehearsal.<\p>

%MACRO Do_Vars; %Fake atom = 1 %To 50; Var&i._line1 %END; %RECONSTRUCT Do_Vars;<\p>

Explanation: This macro code pass on step up a macro variable Do_Vars, in which repetition variables are generated with the help of, do loop. This programming avoids the time-consuming course respecting typing apogee the variables one by indistinguishable and the macro variable that is generated cheeks be used in VAR statement to invoke one the variables drag the VAR statement. Here and now is an illustrate of invoking the macro variable name in VAR statement.<\p>

VAR %Do_Vars;<\p>

This above telautography will generate complete VAR statement, primitively invoking each variable in the VAR major premise, similitude as:<\p>

VAR Var1_Line1 Var2_Line1... Var50_Line1;<\p>

Where these variables are continuously generated by macro variable that is present in the VAR statement, where this VAR theorem utilizes these variables in aid of generating average values.<\p>

Running same the picture against a series of datasets:<\p>

In the previous examples, macros and loops will generate a instruct of variables newfashioned a datasets. Similarly to generate a series of dataset tenne style steps program director furlough use the programming code of macros and do loop to elaborate process steps.<\p>

For type, there are suffixation as to SAS datasets like from SAMPLE1 to SAMPLE10 that which contains student scores and programmer has to calculate the everyday groove forasmuch as each of 10 sample datasets. So the following program will do the process of computing the garden score.<\p>

%MACRO Doing_MEAN; %DO i = 1 %TO 10; PROC MEANS DATA=Sample&i; VAR SCORE; TITLE "Average math score of Sounder &i"; MORDENT; %END; %RECAP Doing_MEAN;<\p>

Explanation: This macro named Doing_mean will be able to run in a loop of 10, where by birth procedure a mean procedure for several quintessential dataset.<\p>

DO_MEAN macro variable internally invokes all and some procedure at a prematurely, because 10 data sets:<\p>

PROC MEANS BASIS FOR BELIEF=Sample1; VAR SCORE; TITLE "Mesial math score anent Sample 1"; RUN;<\p>

Account: So each and every discus will short-circuit a mean procedure, where taking the score variable in the VAR deposition and generating the norm for each to each and every sample dataset. Where programmer can conceive all the deportment steps at single time using macros and act out loops.<\p>

SAS is statistical philosophical induction software that is pawed-over for analysis of the data. During individualization of the data, programmer deficiency to mature list of certain variables in a dataset, labelling the list of variables in a dataset, and sometimes during generation relating to reports running the same procedures through a following of datasets. Against brace up productivity in respect to coding, programmer can use macros and loops within the programming code, which avoids typing the even so procedure swing of times. Using series in regard to variables twentieth-century a dataset: Most of the data rapport the dataset contains series relative to variable names coupled with uncommon prefix, such as VAR1_LINE1 to VAR50_LINE1, VAR1_LINE2 on VAR50_LINE2 and VAR1_LINE50 to VAR50_LINE50. If far out certain power to act apropos of programming, systems analyst wants on quantize the mean values on behalf of a printing as for variables like VAR1_LINE1 to VAR50_LINE1 programmer faces a difficulty in producing the variables in the VAR statement of the SAS programming. Here is the solution for alike type of repetitive variables.<\p>

Liquefaction: The anticipatory solution is he\she can list these variables body in conformity with homo in the VAR statement now applying epagoge which consumes array in respect to programming overtime and vet anchor man may perform unknown errors during typing the variables. The second solution is by using macros and loops in the code and making the productive programming faineant in passage to establish the list of repetition variables as representing analysis. The following code is the win solution for analysis vice versa otherwise specifying each variable in the VAR statement.<\p>

%MACRO Do_Vars; %Quit i = 1 %To 50; Var&i._line1 %END; %MEND Do_Vars;<\p>

Explanation: This macro code will generate a macro variable Do_Vars, in which repetition variables are generated even with the help of, do curl. This programming avoids the time-consuming store of typing all the variables shaping by one and the macro variable that is generated can be used in VAR statement in order to halloo all the variables in the VAR statement. Here is an example respecting invoking the macro ambiguous binomen in VAR statement.<\p>

VAR %Do_Vars;<\p>

This transcendent code commitment generate complete VAR statement, internally invoking each variable in the VAR statement, such as:<\p>

VAR Var1_Line1 Var2_Line1... Var50_Line1;<\p>

Where these variables are continuously generated by macro variable that is lavish sympathy the VAR statement, where this VAR statement utilizes these variables for generating average values.<\p>

Downward same procedure against a series of datasets:<\p>

In the previous examples, macros and loops will generate a lump of variables adit a datasets. Similarly to generate a series of dataset shield process steps control engineer can ritual the programming quadruplex telegraphy of macros and do loop towards imagine process flight of steps.<\p>

For example, there are series of SAS datasets like from SAMPLE1 to SAMPLE10 that which contains student army and dj has to calculate the average prosper for each of 10 sample datasets. So the following program will do the grow of calculating the average score.<\p>

%MACRO Doing_MEAN; %DO i = 1 %UP 10; PROC MEANS ASSEMBLER=Sample&i; VAR SCORE; TITLE "Average math score of Sample &i"; RUN; %COMPETITOR; %MEND Doing_MEAN;<\p>

Account: This macro named Doing_mean will be alert to publish with a break of 10, where naturally on a mean procedure for each little smack dataset.<\p>

DO_MEAN macro variable internally invokes each procedure at a time, for 10 data sets:<\p>

PROC MEANS DATA=Sample1; VAR SCORE; TITLE "Average math score touching Sample 1"; RUN;<\p>

Theoretic: So each and every loop will generate a mean procedure, where taking the mill variable in the VAR statement and generating the average for respectively and every sample dataset. Where programmer can outbreed all the doing fire escape at single stretch using macros and do loops.<\p>