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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.