I have multiple CSV input files that I have been importing into a single dataset. Each report has nearly the exact same format: there's a separate header and body section, the header always has seven "variables", the body always has 15 variables, and there's always 2 blank lines separating the two sections - the only difference is that there can be a variable number of rows in the body section. See green-shaded table in the attachment.   When importing these files into a single dataset, I've been lopping off the headers and just keeping the bodies of each report - see blue-shaded table.   But I'd like to keep some of the data in each report header by inserting them as new columns in the output dataset. See pink-shaded table, where I've transposed "HeaderVar5" from a row in each input report's header into a single column in the output.   I'm using SAS 9.4. Here's the code I have so far:   PROC IMPORT OUT=TEST DATAFILE= "C:\filepath\xyz.report.*" DBMS=DLM REPLACE; DELIMITER='2C'x; GETNAMES=NO; DATAROW=7; RUN; data test; set test; if BodyVar3 in ("",'BodyVar3') then delete; RUN;   ... View more