proc import, how to avoid blank rows, in middle of the file or at the end of the file?

fengyuwuzu — Tue, 22 Dec 2015 21:16:29 GMT

I have one CSV file, and there are 4 blank rows in the CSV file.

when I used proc import, the blank rows were imported as blank rows, too. Is there a way to not to import the blank rows?

A similar situation is, in my another CSV file, at the end of the data rows, there are several blank rows with one line in middle containing some summry words, like below:

7e30e5e5590d9772d1e743c66eadc09f3e7a3ac0	197612	NULL	19131	PA	55:30.1	23:54.4
bdf42c335be105c0e0b6a968ea150730e1cca316	197804	NULL	19015	PA	25:15.6	23:54.4

(28808 row(s) affected)

Re: proc import, how to avoid blank rows, in middle of the file or at the end of the file?

LinusH — Tue, 22 Dec 2015 21:35:11 GMT

PROC IMPORT is a standard easy to use utility, which in turn gives you not that much detailed control.

So you choices are to use the data step to import your data, or post process your input data in a succeeding data step/SQL.

The same goes with your next example, you need some logic to rule out the summary row as well.

You could use that summary row for validation purposes as well, if like/feel need to.

topic proc import, how to avoid blank rows, in middle of the file or at the end of the file? in SAS Programming

proc import, how to avoid blank rows, in middle of the file or at the end of the file?

Re: proc import, how to avoid blank rows, in middle of the file or at the end of the file?