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 necessary is it to be creative in your work?

2526

---

How does proc sql work?

1147

---

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

1148

---

What is the difference between reading data from an external file and reading data from an existing data set?

1232

---

What system options would you use to help debug a macro? : sas-macro

1149

---

How are numeric and character missing values represented internally?

1712

---

What are the statements in proc sql?

1149

---

why a stop statement is needed for the point= option on a set statement?

1132

---

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

1136

---

What is the basic syntax of a sas program?

1264

---

what is the basic structure sas administrator? : Sas-administrator

1056

---

how can you create zero observation dataset? : Sas programming

1202

---

i have a dataset with 100 obs i want to generate title from 20th obs onwards with total observations. that should contain 100 obs.dont use firstobs and dnt split the data. use dataset block or proc report? how can we genarate;

2557

---

Are you involved in writing the inferential analysis plan? Tables specfications?

2264

---

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

1544

---