Hello
I am running a sas program that create many data sets and one of them is called P9.
After creating P9 I am running a query that work on P9.
This is simple query that is 100% correct .
The issue is that when I run it I get error 49.
I have tried to create the data set P9 in a permanent library and still get the error 49.
When I opened a new sas program and run the query on P9 then I didn't recieve any error.
Here is the Log,
What does it say?
The simple query that I run is :
proc sql;
create table ttt as
select *
from r_r.L9
;
quit;
1 The SAS System 11:09 Wednesday, July 27, 2022
1 ;*';*";*/;quit;run;
2 OPTIONS PAGENO=MIN;
3 %LET _CLIENTTASKLABEL='Program';
4 %LET _CLIENTPROCESSFLOWNAME='Process Flow';
5 %LET _CLIENTPROJECTPATH='';
6 %LET _CLIENTPROJECTPATHHOST='';
7 %LET _CLIENTPROJECTNAME='';
8 %LET _SASPROGRAMFILE='';
9 %LET _SASPROGRAMFILEHOST='';
10
11 ODS _ALL_ CLOSE;
12 OPTIONS DEV=PNG;
13 GOPTIONS XPIXELS=0 YPIXELS=0;
_________________________________
49
NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space
between a quoted string and the succeeding identifier is recommended.
14 FILENAME EGHTML TEMP;
15 ODS HTML(ID=EGHTML) FILE=EGHTML
16 ENCODING='utf-8'
17 STYLE=HTMLBlue
18 STYLESHEET=(URL="file:///C:/Program%20Files/SASHome/SASEnterpriseGuide/7.1/Styles/HTMLBlue.css")
19 NOGTITLE
20 NOGFOOTNOTE
21 GPATH=&sasworklocation
22 ;
NOTE: Line generated by the macro variable "SASWORKLOCATION".
22 ") NOGTITLE NOGFOOTNOTE
22 ! GPATH="/usr/local/saswork/SAS_work9F3700001F00_LINX107717A14/SAS_work24CD00001F00_LINX107717A14/"
_
49
NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space
between a quoted string and the succeeding identifier is recommended.
23 FILENAME EGSR TEMP;
24 ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR
25 STYLE=HTMLBlue
26 STYLESHEET=(URL="file:///C:/Program%20Files/SASHome/SASEnterpriseGuide/7.1/Styles/HTMLBlue.css")
27 NOGTITLE
28 NOGFOOTNOTE
29 GPATH=&sasworklocation
30 ENCODING=UTF8
NOTE: Line generated by the macro variable "SASWORKLOCATION".
30 ") NOGTITLE NOGFOOTNOTE
30 ! GPATH="/usr/local/saswork/SAS_work9F3700001F00_LINX107717A14/SAS_work24CD00001F00_LINX107717A14/"
_____________________________________
49
NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space
between a quoted string and the succeeding identifier is recommended.
31 options(rolap="on")
32 ;
33
34 GOPTIONS ACCESSIBLE;
35 proc sql;
36 create table ttt as
37 select *
2 The SAS System 11:09 Wednesday, July 27, 2022
38 from r_r.L9
39 ;
40 quit;
41
42 GOPTIONS NOACCESSIBLE;
43 %LET _CLIENTTASKLABEL=;
44 %LET _CLIENTPROCESSFLOWNAME=;
45 %LET _CLIENTPROJECTPATH=;
46 %LET _CLIENTPROJECTPATHHOST=;
47 %LET _CLIENTPROJECTNAME=;
48 %LET _SASPROGRAMFILE=;
49 %LET _SASPROGRAMFILEHOST=;
50
51 ;*';*";*/;quit;run;
52 ODS _ALL_ CLOSE;
53
54
55 QUIT; RUN;
56
