DATA Step, Macro, Functions and more

proc sql error message

Accepted Solution Solved
Reply
Super Contributor
Posts: 345
Accepted Solution

proc sql error message

proc sql; create table dadkid4 as select *, (dads.famid=faminc.famid) as indic, (dads.famid ~=.) as dadind, (faminc.famid ~=.) as famind, coalesce(dads.famid, faminc.famid) as fid from dads full join faminc on dads.famid=faminc.famid; quit;

 

ERROR: Expression using not equals (^=) has components that are of different data types.

ERROR: Expression using not equals (^=) has components that are of different data types.

 

 

two IDs are char variables, there should be not a problem?

I then  convert both to numberical variables, still same error message.

any idea how to fix it?

Thanks.

 


Accepted Solutions
Solution
‎06-15-2016 01:16 PM
Trusted Advisor
Posts: 2,115

Re: proc sql error message

The missing value indicator for a character variable is a single space, e.g. ' ' (two quotes with one space in between).

 

http://support.sas.com/documentation/cdl/en/lrcon/62955/HTML/default/viewer.htm#a002316433.htm

View solution in original post


All Replies
Solution
‎06-15-2016 01:16 PM
Trusted Advisor
Posts: 2,115

Re: proc sql error message

The missing value indicator for a character variable is a single space, e.g. ' ' (two quotes with one space in between).

 

http://support.sas.com/documentation/cdl/en/lrcon/62955/HTML/default/viewer.htm#a002316433.htm

☑ This topic is solved.

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

Discussion stats
  • 1 reply
  • 244 views
  • 1 like
  • 2 in conversation