Answer Posted / sastechies

Often we need to add a prefix to some or all variables in a
dataset before we might have to merge datasets that have
similar column attributes...This macro would allow you to
do that....

Try it for yourself....

/**
SAS Macro to add a prefix to some or all variables in a
data set...
to be used like this...
%prefixvars(inpdsn,prefix,outdsn,excludevars=);
inpdsn - input dataset name libname.dsnname
prefix - prefix that you want to assign
outdsn - output dataset name libname.dsnname
excludevars - vars that you do not want to rename with the
prefix
**/

%macro prefixvars(inpdsn,prefix,outdsn,excludevars=);

/* split the excludevars into individual macro var names
for later use*/
%let num=1;
%let excludevar=%scan(%upcase(&excludevars),&num,' ');
%let excludevar&num=&excludevar;

%do %while(&excludevar ne );
%let num=%eval(&num + 1);
%let excludevar=%scan(&excludevars,&num,' ');
%let excludevar&num=&excludevar;
%end;
%let numkeyvars=%eval(&num - 1); /* this is number of
variables given in the exclude vars */


%let dsid=%sysfunc(open(&inpdsn)); /* open the dataset
and get the handle
*/

%let numvars=%sysfunc(attrn(&dsid,nvars)); /* get the
number of variables
*/

data
&outdsn;


set &inpdsn(rename=(
/*rename all the variables that are not in the
excludevars=
*/

%do i = 1 %to &numvars;
%let flag=N;
%let var&i=%sysfunc(varname(&dsid,&i));
%do j=1 %to &numkeyvars;
%if %upcase(&&var&i) eq &&excludevar&j %then %
let flag=Y;
%end;
%if &flag eq N %then %do;
&&var&i=&prefix&&var&i %end;
%
end;));



%let rc=%sysfunc(close
(&dsid));


run;


%mend
prefixvars;





/*Call the macro
now*/


%prefixvars
(sashelp.buy,fr_,work.out,excludevars=date)

Which statement does not perform automatic conversions in comparisons?

1855

---

How would you include common or reuse to be processed along with your statements?

2417

---

what is change analysis in sas di ? : Sas-di

1112

---

Explain what is data step?

1240

---

what is sas enterprise intelligence architecture? : Sas-bi

1019

---

Describe the function and utility of the most difficult SAS macro that you have written?

2625

---

how would you determine the number of missing or nonmissing values in computations? : Sas programming

1201

---

what is sas database server? : Sas-di

1191

---

What will calendar procedure do?

1114

---

If you were told to create many records from one record, show how you would do this using array and with proc transpose?

1542

---

what is a method for assigning first.var and last.var to the by groupvariable on unsorted data? : Sas programming

1041

---

Which are the statements whose placement in the data step is critical?

1308

---

What are the differences between sum function and using “+” operator?

1156

---

what can you learn from the sas log when debugging? : Sas programming

1140

---

Explain the difference between nodup and nodupkey options?

1089

---