Answer Posted / kumar

If it is Interview Question I would do say something like this.

/* Running the renaming macro */
options macrogen mprint mlogic;
%macro rename(lib,dsn);
options pageno=1 nodate;
proc contents data=&lib..&dsn;
title "Before Renaming All Variables";
run;
proc sql noprint;
select nvar into :num_vars
from dictionary.tables
where libname="&LIB" and
memname="&DSN";
select distinct(name) into :var1-
:var%TRIM(%LEFT(&num_vars))
from dictionary.columns
where libname="&LIB" and
memname="&DSN";
quit;
run;
proc datasets library=&LIB;
modify &DSN;
rename
%do i=1 %to &num_vars;
&&var&i=NEWNAME_&&var&i.
%end;
;
quit;
run;
options pageno=1 nodate;
proc contents data=&lib..&dsn;
title "After Renaming All Variables";
run;
%mend rename;

how could you generate test data with no input data? : Sas programming

1197

---

How do dates work in sas?

1147

---

What is a put statement?

1209

---

what versions of sas have you used (on which platforms)? : Sas programming

1077

---

what are the benefits of data integration? : Sas-di

1113

---

Did you used proc test? when?

2048

---

how do you want missing values handled? : Sas programming

965

---

What is SAS informats?

1114

---

for what purpose would you use the retain statement? : Sas programming

1103

---

How would you define the end of a macro? : sas-macro

1097

---

What are the default statistics for means procedure?

1259

---

What is interleaving in SAS?

1123

---

What is connection profile? : sas-grid-administration

1180

---

explain the function of substr in sas? : Sas-administrator

1020

---

Describe crosslist option in tables statement?

1229

---