Help using Base SAS procedures

White Space?

Accepted Solution Solved
Reply
Regular Contributor
Posts: 220
Accepted Solution

White Space?

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


Accepted Solutions
Solution
‎04-16-2012 11:28 AM
Regular Contributor
Posts: 233

Re: White Space?

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


All Replies
Solution
‎04-16-2012 11:28 AM
Regular Contributor
Posts: 233

Re: White Space?

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;

Regular Contributor
Posts: 220

Re: White Space?

Thanks Hima

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

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