BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
sas_9
Obsidian | Level 7

anyone can hele me on this please?

what is the meaning of white space in following code log. Not getting error but kind of SAS version warning. is that i need put one space after '0000'and code line?

 

data discount_sysprinserv(drop = agent nature_of_service);

282 length discount_code $2 ;

283 set sasds.csg_discount_&date1;

284 where principal ne '0000' and agent = '0000'and restrict_discount in ('S','X') ;

                                                            ______

                                                               49

NOTE 49-169: The meaning of an identifier after a quoted string may change in a future SAS release. Inserting white space between

a quoted string and the succeeding identifier is recommended.

285 run;

NOTE: There were 0 observations read from the data set SASDS.CSG_DISCOUNT_120414.

WHERE (principal not = '0000') and (agent='0000') and restrict_discount in ('S', 'X');

NOTE: The data set WORK.DISCOUNT_SYSPRINSERV has 0 observations and 8 variables.

NOTE: DATA statement used (Total process time):

real time 6.52 seconds

cpu time 6.47 seconds

1 ACCEPTED SOLUTION

Accepted Solutions
Hima
Obsidian | Level 7

White space characters  are blank, horizontal and vertical tab, carriage return, line feed, and form feed. Since blank is missing here agent = '0000'and SAS inserted a white space between them and compiled the code.

Character Variable:

Data Have;

input START END A1 $1. A2 A3 A4 A5;

cards;

1 5 1 2 3 4 5

1 3 1 2 3 4 5

2 4 1 2 3 4 5

;

run;

data have1;

set have;

where A1='1'and A2=2;

run;

Log:

data have1;
120  set have;
121  where A1='1'and A2=2;
              ---
              49
NOTE 49-169: The meaning of an identifier after a quoted string may change in a future SAS
             release.  Inserting white space between a quoted string and the succeeding
             identifier is recommended.

122  run;

View solution in original post

2 REPLIES 2
Hima
Obsidian | Level 7

White space characters  are blank, horizontal and vertical tab, carriage return, line feed, and form feed. Since blank is missing here agent = '0000'and SAS inserted a white space between them and compiled the code.

Character Variable:

Data Have;

input START END A1 $1. A2 A3 A4 A5;

cards;

1 5 1 2 3 4 5

1 3 1 2 3 4 5

2 4 1 2 3 4 5

;

run;

data have1;

set have;

where A1='1'and A2=2;

run;

Log:

data have1;
120  set have;
121  where A1='1'and A2=2;
              ---
              49
NOTE 49-169: The meaning of an identifier after a quoted string may change in a future SAS
             release.  Inserting white space between a quoted string and the succeeding
             identifier is recommended.

122  run;

sas_9
Obsidian | Level 7

Thanks Hima

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

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
  • 2 replies
  • 5657 views
  • 0 likes
  • 2 in conversation