topic Re: White Space? in SAS Procedures

White Space?

sas_9 — Mon, 16 Apr 2012 15:06:09 GMT

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') ;

______

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

Re: White Space?

Hima — Mon, 16 Apr 2012 15:28:46 GMT

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;

Re: White Space?

sas_9 — Mon, 16 Apr 2012 15:47:49 GMT

Thanks Hima