topic Re: numeric/char conflict in SAS Programming

numeric/char conflict

Marilyn — Wed, 15 Apr 2009 15:30:53 GMT

How can I get this where statement in proc sql to work when one ssn is a char and the other is numberic?

where B.pat_ssn = A.SSN;

Re: numeric/char conflict

DanielSantos — Wed, 15 Apr 2009 15:43:23 GMT

You'll have to convert one of them.

to convert from num to char, use the put function.
see: http://support.sas.com/documentation/cdl/en/lrdict/61724/HTML/default/a000199354.htm

to convert from char to num, use the input function.
see: http://support.sas.com/documentation/cdl/en/lrdict/61724/HTML/default/a000180357.htm

Greetings from Portugal.

Daniel Santos at www.cgd.pt

Re: numeric/char conflict

Marilyn — Wed, 15 Apr 2009 15:51:54 GMT

ok...at what point in the procedure do I do this?
proc sql;
CREATE TABLE x.out04 AS SELECT B.kssn FORMAT=$9. AS kSSN,
A.ISSN FORMAT=$9.,
A.DIAG1 FORMAT=$7.
FROM N.YR2004 AS A ,
x.ketssn AS B
where B.kssn = A.ISSN;
QUIT;

Re: numeric/char conflict

Doc_Duke — Wed, 15 Apr 2009 18:09:02 GMT

In the WHERE clause, e.g.

WHERE b.pat_ssn = put(a.ssn,9.)

If b.pat_ssn has embedded hyphens, you'll need to use the SSN format for a.ssn (say ssn11.).