http://snipplr.com/users/sarathannapareddy/tags/SASHELP Recent snippets posted on Snipplr.com en-us Thu, 20 Jun 2013 11:27:14 GMT http://snipplr.com/view/17697/dictionary-tables-and-sashelp-views-sas-metadata/ Most of the SAS programmers think that the Metadata concepts (Dictionary tables and SASHELP views) are advanced SAS topics, in fact it is not. I tried here to explain the concept precise and clear…… Here, I will cover the following topics…… Introduction to SAS metadata How to see what’s in the tables How to use the tables, using several real-world examples Advantages What are Dictionary Tables4?

]]> Thu, 30 Jul 2009 13:06:03 GMT http://snipplr.com/view/17697/dictionary-tables-and-sashelp-views-sas-metadata/ http://snipplr.com/view/17378/renaming-all-variables-in-a-sas-data-set-using-the-sashelp-views/ *Create a temporary dataset... DSN; data dsn; a=1; b=2; c=3; d=4; e=5; f=6; run; %macro test(lib,dsn); */1)*/ data _null_; set sashelp.vtable(where=(libname="&LIB" and memname="&DSN")); call symput('nvars',nvar); run; */2)*/ data dsn; set sashelp.vcolumn(where=(libname="&LIB" and memname="&DSN")); call symput(cats("var",_n_),name); run; */3)*/ proc datasets library=&LIB; modify &DSN; rename %do i = 1 %to &nvars; &&var&i=Rename_&&var&i. %end; ; quit; run; %mend; %test(WORK,DSN); After submitting the above program... the output looks like this.... Output: Rename_a Rename_b Rename_c Rename_d Rename_e Rename_f 1 2 3 4 5 6

]]> Thu, 23 Jul 2009 09:29:51 GMT http://snipplr.com/view/17378/renaming-all-variables-in-a-sas-data-set-using-the-sashelp-views/