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
This is not an error but an helpful note. Indicates the need to add a white space after the quoted string.
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.