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)
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;
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;
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.