You may want to play with the options listed here, How to View DICTIONARY Tables also ask SAS Tech support for help. http://support.sas.com/documentation/cdl/en/lrcon/65287/HTML/default/viewer.htm#p00cato8pe46ein1bjcimkkx6hzd.htm ... View more

In EG and Base SAS you can only have either the column name or the label displayed, you cannot have both. To see both, right-click on the table in the library, Properties, Columns. There you scroll right, and the labels would be shown on each column. To change the settings to show labels instead of column names do this: Find Tools on the menu bar, then Options, look at the drop down screen. Locate on the left Data,  Data General. Toward the middle,  Naming Options: check the box for  "Use labels for column names" This is in SAS EG 6.1. Look for similar settings in 5.1, it should not be very different. ... View more

I would use PROC CONTENTS with _ALL_ in a macro to scan each library, and output the results in a table each The results need to be deduplicated to a single row for each table (memname) in a library, thus eliminating the details, keeping only the names. %macro mycnts(mylib,myoutfl); PROC CONTENTS data =&mylib._ALL_ out=&mycontents NOPRINT /* optional: */ (KEEP = LIBNAME MEMNAME) ; RUN; proc sort data = &mycontents nodupkey; by libname memname; run; %mend; /*Eample for executing the macro*/ %mycnts(work,lib1); Repeat this for the rest of your libraries Evaluate the resulting tables Lib1 lib2 libn, you can concatenate all into one. I hope this helps. For Question # 1 I would use a text editor, like UltraEdit, Find in Files function on the program library (hopefully there is one) to locate the table name in a program. Pattern to use: "data lib1". There may be admin tools that could be used, but I am not familiar. ... View more

You can count the maximum occurance of the CMS codes per ID before the transpose, and create a macro variable to use it later, see http://support.sas.com/resources/papers/proceedings13/198-2013.pdf Use PUT to create a text version of that number or any number in between, and concatenate it to the end of your "CMS_Code_ " as n in CMS_Code_n or better CMS_Code_nn if you need to enlist your unknown variables later. Once your macro variable with the max value is created, you can dynamically use it without the need to stop the program. I hope this helps. Anna ... View more

Step 1. */ Options NOXWAIT;  /*Close command window without interacting / waiting for type in "EXIT" and press Enter*/ X "DIR /A:-D  /T:C c:\test\myFile.CSV > c:\test\myDirC.txt";  /* List file creation date  /T:C  */ X "DIR /A:-D  /T:W c:\test\myFile.CSV > c:\test\myDirW.txt";  /* List date Last Written   /T:W  */ Options XWAIT;  /*Reset the environment to default setting */ /*   To get the full folder contents,  use C:\test\*.*    To get all CSV files,  use C:\test\*.CSV */ /*Step 2 - read the list created in step one */ Data DIRlist (drop = firstchr); infile "c:\test\myDirW.txt" truncover;   input firstchr $1. @ ;   if firstchr ne "" then do;   /*Reed in only related information */    input     @01 fildat mmddyy10.  /*File date  */     @40 filname $100.;   /*File name  */    end;   format fildat mmddyy10.;   if firstchr ne "";            /*Keep only the useful line(s) */   run; /* I hope this helps  */ ... View more

Could it be the missing semicolon at endcomp right before the DEFINITION. ... View more