Date:         Wed, 17 Nov 2010 08:13:47 -0500
Reply-To:     Fatos US <fatosus@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Fatos US <fatosus@GMAIL.COM>
Subject:      Re: proc sql
In-Reply-To:  <61679E0E-5026-402D-98B5-2B8839FAF7A5@gmail.com>
Content-Type: text/plain; charset=windows-1252

thank you so much for all your help.
fay

On Wed, Nov 17, 2010 at 3:50 AM, Mehul Shah <mehul.sas@gmail.com> wrote:

> Regards,
> Mehul Shah
>
> Note: The message has been sent using iphone. Please excuse the typos.
>
> Begin forwarded message:
>
> > From: Mehul Shah <mehul.sas@gmail.com>
> > Date: November 16, 2010 11:28:31 AM EST
> > To: Fatos US <fatosus@gmail.com>
> > Cc: SAS-listserv <SAS-L@LISTSERV.UGA.EDU>
> > Subject: Re: proc sql
>  >
>
> > It should be in from statement where u r joining 2 datasets.
> >
> > Instead of,
> >> from
> >>
> >> WORK.dad INNER JOIN WORK.SAMPLE ON SAMPLE.dssn = dad.id where
> sample.dssn ne ' ';
> >
> > Use following.
> >
> >> from
> >>
> >> WORK.dad INNER JOIN WORK.SAMPLE ON put(SAMPLE.dssn,comma8.0) = dad.idwhere sample.dssn ne ' ';
> >
> > Regards,
> > Mehul Shah
> >
> > Note: The message has been sent using iphone. Please excuse the typos.
> >
> > On Nov 16, 2010, at 9:58 AM, Fatos US <fatosus@gmail.com> wrote:
> >
> >> thank you so much for your help.
> >> i still have problems with the char/num variable conversion.
> >> exactly where the put stmt should be located in the program?
> >> within proc sql?
> >> thanks again.
> >> fs
> >>
> >>
> >> proc sql;
> >> put(SAMPLE.dssn,
> >>
> >> 9.
> >> ) = dad.id;
> >> create table WORK.DMATCH as
> >> Select DAD.ADDRESS AS DADRES LABEL="DADRES",
> >>
> >> dad.fullpmad as dmadpm label="HSIS-Dad's Address",
> >>
> >> dad.phone1 as dmphpm label="HSIS-Dad's Phone Number",
> >>
> >> SAMPLE.PBCERT label='Birth Cert. Number'
> >>
> >> from
> >>
> >> WORK.dad INNER JOIN WORK.SAMPLE ON SAMPLE.dssn = dad.id where
> sample.dssn ne ' ';
> >>
> >> On Tue, Nov 16, 2010 at 9:22 AM, Mehul Shah <mehul.sas@gmail.com>
> wrote:
> >> Fay,
> >>
> >> This error states that u have 2 different type of variable i.e. Dssn
> seems to be char however id may be numeric. U may want to convert char to
> numeric or vice versa for one of these variables. Try
> put(SAMPLE.dssn,comma8.0) = dad.id
> >>
> >> I hope it helps.
> >>
> >> Regards,
> >> Mehul Shah
> >>
> >> Note: The message has been sent using iphone. Please excuse the typos.
> >>
> >> On Nov 16, 2010, at 9:06 AM, Fatos US <fatosus@GMAIL.COM> wrote:
> >>
> >> > Hi,
> >> > Can anyone tell me what to look for to solve the sql problem below. I
> am
> >> > trying to run someone else's program that has sql that I don't know
> much.
> >> > Any help will be appreciated.
> >> > Fay
> >> >
> >> >
> >> > 466  create table WORK.DMATCH as
> >> >
> >> > 467  Select DAD.ADDRESS AS DADRES LABEL="DADRES",
> >> >
> >> > 468  dad.fullpmad as dmadpm label="HSIS-Dad's Address",
> >> >
> >> > 469  dad.phone1 as dmphpm label="HSIS-Dad's Phone Number",
> >> >
> >> > 470  SAMPLE.PBCERT label='Birth Cert. Number'
> >> >
> >> > 471  from WORK.dad INNER JOIN WORK.SAMPLE ON SAMPLE.dssn = dad.idwhere
> >> > sample.dssn ne ' ';
> >> >
> >> > ERROR: Expression using equals (=) has components that are of
> different data
> >> > types.
> >> >
> >> > ERROR: Expression using not equals (^=) has components that are of
> different
> >> > data types.
> >> >
> >> > NOTE: The SAS System stopped processing this step because of errors.
> >>
> >>
> >>
> >> --
> >>                 \\  - -  //
> >>               (  @ @  )
> >> +------oOOo-(_)-oOOo----------+---------------------------------+
> >>
> >> Amor Fati : “Love Your Fate”, which is in fact your life. ~ Friedrich
> Nietzsche
>



-- 
                \\  - -  //
              (  @ @  )
+------oOOo-(_)-oOOo----------+---------------------------------+

Amor Fati : “Love Your Fate”, which is in fact your life. ~ Friedrich
Nietzsche