Error-data set exists and still get an error

Ronein — Wed, 27 Jul 2022 08:38:41 GMT

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

Re: Error-data set exists and still get an error

Sajid01 — Wed, 27 Jul 2022 11:01:30 GMT

This is not an error but an helpful note. Indicates the need to add a white space after the quoted string.

topic Re: Error-data set exists and still get an error in SAS Programming

Error-data set exists and still get an error

Re: Error-data set exists and still get an error