topic how to delete blank lines in SAS code? in SAS Programming

how to delete blank lines in SAS code?

Fisher — Mon, 12 Sep 2011 16:41:50 GMT

I have a long SAS macro, and there are lots of blank lines within codes which I like to delete.

Anybody know how to do that trick? thanks

how to delete blank lines in SAS code?

art297 — Mon, 12 Sep 2011 16:45:54 GMT

Blank lines within a program or within a macro variable?

how to delete blank lines in SAS code?

Fisher — Mon, 12 Sep 2011 17:47:27 GMT

within a program. thanks.

how to delete blank lines in SAS code?

Tom — Mon, 12 Sep 2011 18:20:30 GMT

Depends on the tools you have. You could use sed or other unix tools from the command line.

Not that hard to do with a data step.

data _null_;

infile 'old.sas' lrecl=1000;

file 'new.sas' lrecl=1000;

input;

if _infile_=' ' then delete;

* Why not remove those pesky trailing blanks some editors insert while we are at it. ;

len= length(_infile_);

put _infile_ $varying1000. len ;

run;

how to delete blank lines in SAS code?

art297 — Mon, 12 Sep 2011 18:55:17 GMT

Actually there is a way to do it in SAS, but a little difficult to explain.

SAS has what are call keyboard macros and abbreviations (they are the same thing). You can record your own by clicking on tools->record macro.

Once one is recorded, it can be edited.

Thru a combination of starting a macro to record, clicking on select all and find and entering what I wanted SAS to find, and then stopping and naming the macro, I was able to edit the macro to contain the following:

Select all

Regenerate leading whitespace

Remove trailing whitespace

Reset search

Set search direction to forward

Set search string to "^\n"

Set search to include comments

Set search to search code

Delete line

Replace all

Reset search

That took all of about 30 seconds to create and I was able to assign the macro the a key (e.g., alt-c)

What the code is doing is removing white space in case you have blank looking lines, using a regular expression to find carriage returns at the start of lines, delete those lines once found.

In short, after creating the macro and assigning the key, pressing alt-c removed all blank lines.

Let me know if you can't figure out how to do it as keyboard macros have another benefit .. they can be exported! In short, I could easily send you the abbreviation and you could import it.

Re: how to delete blank lines in SAS code?

twocanbazza — Mon, 12 Sep 2011 19:51:00 GMT

You could also us the 'Delete' or 'Backspace' key on your keyboard

Barry

how to delete blank lines in SAS code?

FriedEgg — Mon, 12 Sep 2011 19:51:14 GMT

if you are using unix you can do the following via the shell:

tr -s \n old.sas > new.sas

how to delete blank lines in SAS code?

Fisher — Mon, 12 Sep 2011 21:39:13 GMT

Thanks art297.

I followed some of your explaination, but I really glad to find this features in SAS. I will try later again.

how to delete blank lines in SAS code?

Fisher — Mon, 12 Sep 2011 21:40:19 GMT

Thansk Tom.

This code works perfectly in Windows.

how to delete blank lines in SAS code?

Fisher — Mon, 12 Sep 2011 21:51:57 GMT

I tried this command in Linux, but it only generated a blank new.sas.

how to delete blank lines in SAS code?

FriedEgg — Mon, 12 Sep 2011 22:18:10 GMT

First the program would need to utilize unix style EOL characters or \n would need to properly identify the correct EOL. You can preprocess by converting from dos2unix

dos2unix mymacro.sas

tr -s "\n" mymacro.sas > mymacro_new.sas

tr will squeeze (-s) duplicate apperances of the EOL char ("\n") and leave single apperances intact.