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

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 6811 views
  • 0 likes
  • 2 in conversation