BookmarkSubscribeRSS Feed
Ronein
Meteorite | Level 14

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         

 

1 REPLY 1
Sajid01
Meteorite | Level 14

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

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 399 views
  • 0 likes
  • 2 in conversation