Recent content by btmonroe

We have been using the simple macro for years as a quick way to export to a dbf. It works great except that field names over 8 characters are truncated. Is there an easy solution that would allow longer field names. example: %macro exportdbf(filename,data); PROC EXPORT DATA= &data...

Chris, Thanks for your post and I am trying o adjust and add my audit to it. I am having a problem adding my code to it. I would either like to add my display of those longest values to the end of your program or create another html file off of your that has my information. I would like to...

Thanks, I will try and incorporate some of these concepts in mine as well.

I was able to piece together a couple of macros that we use here and create exactly what I was looking for. It may be a little sloppy, but happy it works. %macro audit_max(title,saspath,sasname,saspath2); %let data=&saspath..&sasname; title;footnote;run; ods listing close; ods html...

I have been trying to develop a macro to help me take in a file and for each charater field, find it's formatted length, max length, and a sample of up to 5 of the longest records. I have a macro to find largest value and formated length. However, my thought is to assign a length variable for...