Hi Cynthia,   I can't use the tagsets option as we have an organization-wide RTF-setup macro. Is there a way around that, so that I can use SPANROWS option to repeat group/order variables?    With my existing code, (without tagset RTF), Order variables are not being repeated at new page beginnings even with the SPANROWS option.   Below is a sample code:   ** ----------------------------------------------------------------------** ** Generating Listing                                                    ** ** --------------------------------------------------------------------- **; %rtfsetup(dshdft=hdft,progid=L-PD); proc report data=final nowindows headline headskip split="|" spacing=1 missing style(report)={outputwidth=&outwidth}  style(header)={protectspecialchars=off} spanrows;  columns  col1 col2 col3 col4 col5;  define col1 /order order=data style={cellwidth = 4% just=l protectspecialchars=off} "Subject";  define col2 /order order=data style={cellwidth = 4% just=l protectspecialchars=off} "Major/Minor";  define col3 /order order=data style(header)={cellwidth = 22% just=c protectspecialchars=off} style(column)={just=l} "Description";  define col4 /order order=data style={cellwidth = 6% just=c protectspecialchars=off} "Date";   define col5 /order order=data style={cellwidth = 10% just=l protectspecialchars=off} "Type";    compute after col5;    line "";  endcomp; run;   In the above code:   col1 and col2 are supposed to be repeating variables. But in this situation, they don't repeat when there a page break after first page. Other columns - col3 to col5 - do appear in the new page.   Any help is much appreciated. Without this we manually calculate lines in page based on the width of each column, and the number of line each column takes.   Thanks, Abby ... View more

Thx Tom. This helped me a lot!! ... View more

I was using a variable length, only numeric data file. Below is how I tried - initially, before reading this thread - to read the file into SAS.   Code I used: data test; infile "/folders/myfolders/Oct26/Runners.txt" ; input amt 8.2; run; proc print; run;   The flat text file I wanted to read with the above code:   12345678.90 12500.02 5.11   Output:     123456.78 12500.02   Part of SAS Log:   NOTE: 3 records were read from the infile "/folders/myfolders/Oct26/Runners.txt". The minimum record length was 4. The maximum record length was 11. NOTE: SAS went to a new line when INPUT statement reached past the end of a line. NOTE: The data set WORK.TEST has 2 observations and 1 variables. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.02 seconds     77 proc print; 78 run;   NOTE: There were 2 observations read from the data set WORK.TEST. NOTE: PROCEDURE PRINT used (Total process time): real time 0.17 seconds cpu time 0.09 seconds   The log says it read 3 records but still returned only 2 records to the SAS data set. I tried varying combinations of the input data like 5 records, different numeric values but SAS would return alternate records based on the data I sent. And I didn't know where I was going wrong until I read this thread of messages.    After I used truncover, the issue was resolved:   Code:   data test; infile "/folders/myfolders/Oct26/Runners.txt" truncover; input amt 8.2; run; proc print; run;   output:   123456.78 12500.02 5.11   So, I was wondering if there was an equivalent of $varying informat for reading numeric data :). Just curiousity 🙂 But, thanks for the very informative explanation as always 🙂   Thanks, Abi ... View more

Hi Cynthia, What if my text file contains numeric values. I don't find the corresponding numeric informat for $varying. So, in this case i can use only truncover option? ... View more