topic Re: Removing labels using from proc datasets for many files in SAS Programming

Removing labels using from proc datasets for many files

nketata — Wed, 01 Nov 2017 14:34:33 GMT

Hello,

I have many files (file1, file2, ...) in my work directory and I executed this command to remove the labels from all the files:

proc datasets library=work memtype=data; modify file: ; attrib _all_ label=""; quit;

but I got an error:

ERROR 22-322: Syntax error, expecting one of the following: ;, (, /.

ERROR 200-322: The symbol is not recognized and will be ignored.

So is there a way to remove the labels from all the files of the library with 1 line of code ?

(the command works for one file though)

Re: Removing labels using from proc datasets for many files

RW9 — Wed, 01 Nov 2017 14:52:42 GMT

You need slightly more:

data have1;
  set sashelp.class;
run;
data have2;
  set sashelp.cars;
run;

data _null_;
  set sashelp.vtable (where=(libname="WORK"));
  call execute('proc datasets library=work nolist; modify '||strip(memname)||"; attrib _all_ label=''; run;");
run;

Re: Removing labels using from proc datasets for many files

ballardw — Wed, 01 Nov 2017 15:02:51 GMT

Post code and the error message from the log into a code box opened with the forum {I} menu icon.

The error message you show would have an underscore _ character under the position with the error such as:

97   proc datasets library=work memtype=data;
NOTE: Writing HTML Body file: sashtml1.htm
98      modify file: ;
                   -
                   22
                   200
NOTE: Enter RUN; to continue or QUIT; to end the procedure.
ERROR 22-322: Syntax error, expecting one of the following: ;, (, /.
ERROR 200-322: The symbol is not recognized and will be ignored.
99      attrib _all_ label="";
100  quit;

The main message windows will reformat text and you would not be able to tell that the : character is not allowed in that position.