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
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;
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;
Thanks Hima
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.
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.