Hi, Tom! That fixed it.  I had thought about adding the %Let Dir = ; statement prior to the %Macro statement, but hadn't tried it yet.  I was trying to remember if that was how I'd done it before but you already answered before giving that a shot. Thanks! Bryan ... View more

That was very helpful, Tom!  Thanks so very much for all of your help! ... View more

Since I'm somewhat new to using macros in SAS, can you make a suggestion for how that would look? I can take a few stabs at it myself, but have already spent many hours trying to make the previous program work without success and would like to wrap this up. ... View more

Tom, one more question:  If I know that my data library will always have the same format--e.g., XXXXXXX.SAS._______--can I modify the ds=catx('.','SASDATA',sas_mb); line to reflect that, or should it be modified somewhere else?  It would definitely help shorten the amount of keystrokes. ... View more

I just changed the LRECL=64000 to LRECL=6400 and that did the trick, along with producing the variable names at the top of the delimited file.  Thanks so much! ... View more

Tom, your code worked except for getting the following error:  ERROR: Invalid value for the LRECL option. ... View more

Hi, Tom, In response to #1 of your post, there is (or should be) a SAS member name entered (APPOLSP--see below).  156  %put ---------SAS MEMBER ENTERED WAS  &SAS_MB;       ---------SAS MEMBER ENTERED WAS  appolsp                  But in the libname statement, SASDATA was assigned a null value.  Could this be an issue where the code needs to be rearranged or needs to have %GLOBAL added to keep the macro variables from disappearing? 160  LIBNAME SASDATA "&SAS_LB";                                            NOTE: Libref SASDATA was successfully assigned as follows:                       Engine:        V9                                                          Physical Name: /                                             In response to #2, DAT3.APPOLSP.DATA is a Version 6 data set.  If I hardcode the SAS data library into the program instead of using the &SAS_LB macro variable, the whole thing works fine. I'm going to look at your most recent post now. ... View more

Ron, I tried running your code, but there were errors with the DO loop. 145  %let libname = XXXXXXX.SAS.P5587D3;                             146  %let memname = APPOLSP;                                         147  DATA _null_;                                                    148  dsid   = open ("&libname..&memname"      );                     149  lrecl  = attrn(dsid,'lrecl');                                   150  n_obs  = attrn(dsid,'nobs ');                                   151  n_vars = attrn(dsid,'nvars');                                   152                                                                  153  do i = 1 to n_vars;                                             154     name   = varname(dsid,i);                                    155     type   = vartype(dsid,i);                                    156     putlog name= type=;                                          157     end;                                                         158  rc = close (dsid);                                              159  stop;                                                           160  run;                                                                                                                                 NOTE: Argument 1 to function ATTRN(0,'lrecl') at line 149 column 10 is invalid.                                                       NOTE: Argument 1 to function ATTRN(0,'nobs ') at line 150 column 10 is invalid.                                                       NOTE: Argument 1 to function ATTRN(0,'nvars') at line 151 column 10 is invalid.                                                       ERROR: Invalid DO loop control information, either the INITIAL or TO expression is missing or the BY expression is missing, zero, or invalid.                                                      dsid=0 lrecl=. n_obs=. n_vars=. i=1 name=  type=  rc=. _ERROR_=1 _N_=1 NOTE: Mathematical operations could not be performed at the following places. The results of the operations have been set to missing values. Each place is given by: (Number of times) at (Line):(Column).        1 at 149:10   1 at 150:10   1 at 151:10                             ... View more

Yes, the %PUT statement shows a correct library reference.  The XXXXXXX was used by me to replace the actual library name before posting the SAS log. ... View more

The original code did have WINDOW instead of %WINDOW.  I modified that line hoping it would fix the problem.  The program used to run okay until we upgraded SAS from something like v6 to v9.4. ... View more

Here is the SAS log for the critical part of the program: 137  DATA DATA1;                                          138     %WINDOW INFO                                      139  #1 @5 'THIS PROGRAM PIPE DELIMITS A SAS DATASET.'    140  #3 @5 ' TYPE THE INPUT & OUTPUT DATASETS BELOW.  '   141  #4 @5 '       DO NOT PLACE NAMES IN QUOTES!      '   142  #6 @5 'INPUT SAS LIBRARY AS FOLLOWS:'                143  #9 @5 'MAINFRAME (MVS/TSO):  USERID.LIBNAME'         144  #11 @5 '      INPUT SAS LIBRARY: '                   145  #11 @30 SAS_LB 19 ATTR=UNDERLINE                     146  #12 @5 '       INPUT SAS MEMBER: '                   147  #12 @30 SAS_MB 8  ATTR=UNDERLINE                     148  #14 @5 'OUTPUT NAMES SHOULD BE ENTERED AS FOLLOWS:'  149  #16 @5 'OUTPUT DELIMITTED DATA TO: XXXXXXX.OUT.OUT'; 150                                                       151  /*DISPLAY THE WINDOW & PERFORM ANY INPUT VALIDATION*/ 152      %DISPLAY INFO;                                   153  CALL SYMPUT('SAS_LB',SAS_LB);                        154  CALL SYMPUT('SAS_MB',SAS_MB);                        155  %put ---------SAS LIBRARY ENTERED WAS &SAS_LB;       ---------SAS LIBRARY ENTERED WAS XXXXXXX.sas.p5587d3      156  %put ---------SAS MEMBER ENTERED WAS  &SAS_MB;       ---------SAS MEMBER ENTERED WAS  appolsp                  157  STOP;                                                158  RUN;                                                                                                           NOTE: Numeric values have been converted to character           values at the places given by: (Line):(Column).           153:22   154:22                                     NOTE: The data set WORK.DATA1 has 0 observations and 2 variables.          NOTE: The DATA statement used 0.02 CPU seconds and 25571K.                                                                                            NOTE: The address space has used a maximum of 1156K below the line and           29136K above the line.                                                                                                                                                                                                     159                                                                        160  LIBNAME SASDATA "&SAS_LB";                                            NOTE: Libref SASDATA was successfully assigned as follows:                       Engine:        V9                                                          Physical Name: /                                                     161  FILENAME SASOUT 'XXXXXXX.OUT.OUT';                                    162  /*GET THE TYPE & VARIABLE NAMES OF THE INPUT SAS DATASET*/            163  PROC CONTENTS DATA=SASDATA.&SAS_MB NOPRINT OUT=DATA1;                 ERROR: Invalid data set name SASDATA..                                     NOTE: Line generated by the macro variable "SAS_MB".                       163  SASDATA.           .                                                                          -                                                                          22                                                                         200                                                WARNING: Ignoring second data set reference.                               ERROR 22-322: Syntax error, expecting one of the following: ;, (, CENTILES,               DATA, DETAILS, DIR, DIRECTORY, FMTLEN, LIB, MEMTYPE, MT,                   MTYPE, NODETAILS, NODS, NOPRINT, ORDER, OUT, OUT2, SHORT,                  VARNUM.                                                      ERROR 200-322: The symbol is not recognized and will be ignored.           164                                                                       ... View more

Hi, Tom!  That suggestion looks promising!  I'll consider rewriting the macro to use it! Bryan ... View more