topic Re: Passing macros in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/Passing-macros/m-p/27722#M6349 Do you want to know the SAS "defined" LENGTH attribute or the "data value" internal length for your variables - big difference.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc. Wed, 06 May 2009 12:32:10 GMT sbb 2009-05-06T12:32:10Z Passing macros https://communities.sas.com/t5/SAS-Procedures/Passing-macros/m-p/27721#M6348 Hi<BR /> <BR /> I am having 90 character variable in a dataset now i want to find the length of all the variables.<BR /> <BR /> How can i do it by using macros and how can i pass them Wed, 06 May 2009 12:25:30 GMT https://communities.sas.com/t5/SAS-Procedures/Passing-macros/m-p/27721#M6348 R_Win 2009-05-06T12:25:30Z Re: Passing macros https://communities.sas.com/t5/SAS-Procedures/Passing-macros/m-p/27722#M6349 Do you want to know the SAS "defined" LENGTH attribute or the "data value" internal length for your variables - big difference.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc. Wed, 06 May 2009 12:32:10 GMT https://communities.sas.com/t5/SAS-Procedures/Passing-macros/m-p/27722#M6349 sbb 2009-05-06T12:32:10Z Re: Passing macros https://communities.sas.com/t5/SAS-Procedures/Passing-macros/m-p/27723#M6350 Explore using the SAS-maintained DICTIONARY table information called COLUMNS (or SAS view SASHELP.VCOLUMN) to get the SAS variable names and associated LENGTH information. You can use this information to generate and execute SAS code on-the-fly.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc.<BR /> <BR /> Programming with the SQL Procedure <BR /> <BR /> Accessing SAS System Information by Using DICTIONARY Tables<BR /> <A href="http://support.sas.com/documentation/cdl/en/sqlproc/62086/HTML/default/a001385596.htm" target="_blank">http://support.sas.com/documentation/cdl/en/sqlproc/62086/HTML/default/a001385596.htm</A><BR /> <BR /> Using Metadata and Project Data for Data-Driven Programming<BR /> Brian Varney, COMSYS IT Partners, Inc., Kalamazoo, Michigan<BR /> <A href="http://www2.sas.com/proceedings/sugi31/045-31.pdf" target="_blank">http://www2.sas.com/proceedings/sugi31/045-31.pdf</A> Wed, 06 May 2009 13:15:19 GMT https://communities.sas.com/t5/SAS-Procedures/Passing-macros/m-p/27723#M6350 sbb 2009-05-06T13:15:19Z