Just to clarify here is the code i am having troubles with libname refFile xlsx "/home/Playground/myFile_Label.xlsx";
data refFile.Example_DataSet_Labels (dblabel = yes);
set sashelp.class;
label name="Very very very very very very long name of a very very very long string";
run;
libname refFile clear; and here is the generated log 1 The SAS System Friday, March 10, 2023 08:46:00 AM
1 ;*';*";*/;quit;run;
2 OPTIONS PAGENO=MIN;
3 %LET _CLIENTTASKLABEL='z_02_CodeInDevelopment_Snippets';
4 %LET _CLIENTPROCESSFLOWNAME='Playground';
5 %LET _CLIENTPROJECTPATH='Z:\Playground\Example.egp';
6 %LET _CLIENTPROJECTPATHHOST='MYSERVER';
7 %LET _CLIENTPROJECTNAME='Example.egp';
8 %LET _SASPROGRAMFILE='';
9 %LET _SASPROGRAMFILEHOST='';
10
11 ODS _ALL_ CLOSE;
12 OPTIONS DEV=PNG;
13 GOPTIONS XPIXELS=0 YPIXELS=0;
14 %macro HTML5AccessibleGraphSupported;
15 %if %_SAS_VERCOMP_FV(9,4,4, 0,0,0) >= 0 %then ACCESSIBLE_GRAPH;
16 %mend;
17 FILENAME EGXLSSX TEMP;
18 ODS EXCEL(ID=EGXLSSX) FILE=EGXLSSX AUTHOR="********" STYLE=Excel
19 OPTIONS (
20 EMBEDDED_TITLES="yes" EMBEDDED_FOOTNOTES="yes"
21 );
22
23 libname refFile xlsx "/home/Playground/myFile_Label.xlsx";
NOTE: Libref REFFILE was successfully assigned as follows:
Engine: XLSX
Physical Name: /home/Playground/myFile_Label.xlsx
24
25 data refFile.Example_DataSet_Labels (dblabel = yes);
_______
22
ERROR 22-7: Invalid option name DBLABEL.
26 set sashelp.class;
27 label name="Very very very very very very long name of a very very very long string";
28 run;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
29
30 libname refFile clear;
NOTE: Libref REFFILE has been deassigned.
31
32 %LET _CLIENTTASKLABEL=;
33 %LET _CLIENTPROCESSFLOWNAME=;
34 %LET _CLIENTPROJECTPATH=;
35 %LET _CLIENTPROJECTPATHHOST=;
36 %LET _CLIENTPROJECTNAME=;
37 %LET _SASPROGRAMFILE=;
38 %LET _SASPROGRAMFILEHOST=;
39
40 ;*';*";*/;quit;run;
41 ODS _ALL_ CLOSE;
NOTE: Writing EXCEL(EGXLSSX) file: /opt/sas/ltv/work/SAS_workBBD800003E04_MYSERVER/#LN11670
42
2 The SAS System Friday, March 10, 2023 08:46:00 AM
43
44 QUIT; RUN;
45
... View more
