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;

for report generation which one you used proc report or data_null_?

7792

---

what is sas and what are the functions? : Sas-administrator

990

---

what is sas application server? : Sas-di

1078

---

What are the data types in sas?

1062

---

Mention the validation tools used in SAS?

1181

---

Hi all, If Anybody has Advance SAS Certification dumps??? Please share with me. Email: pramod.kalugade03@gmail.com

2029

---

what is the use of proc sql? : Sas programming

1133

---

explain the use of % includes a statement in sas? : Sas-administrator

1006

---

what are the new features included in the new version of sas i.e., Sas 9.1.3? : Sas programming

1079

---

How to sort in descending order?

1259

---

How would you identify a macro variable?

1092

---

what are the types of interactive display types? : Sas-bi

1100

---

explain the main difference between the nodup and nodupkey options? : Sas-administrator

1162

---

Define run-group processing?

1047

---

What do you know about sas and what we do? : sas-grid-administration

1147

---