Posted By

sarathannapareddy on 06/07/09


Tagged

sql variables character call proc symput SAShelpvcolumn SAShelpVtable nvars


Versions (?)

maxvarlen_macro: Check the Length of all character variables length is LT 200


 / Published in: SAS
 

URL: http://studysas.blogspot.com/2009/04/maxvarlenmacro-check-length-of-all.html

  1. MAXVARLEN Macro:
  2.  
  3. According to FDA released the Guidance for Industry: Providing Regulatory
  4. Submission in Electronic Format � NDAs which was released in Jan 1999, one of the important point to comply with the agency�s regulations is :
  5.  
  6.  
  7. The length of any character values cannot be more than 200 characters.
  8.  
  9. Following is the macro which will give us the list of character variables whose actual length (not the assigned) is greater than 200.
  10.  
  11. We can use this program to check the maximum length of all variables of any dataset at once. This macro will create a table with list of variables and their length.
  12.  
  13. contd........

Report this snippet  

You need to login to post a comment.