I think the poster is relying on the %put to tell him/her if the macro
create in SQL worked but since he/she has no quit after the SQL statement
the %put was done before the macro variable was set by SQL.
This will work (under Jacks assumption that the hospital really exists.
select hospname into :hosp from ia.hospitals where hospid=&hospid;
On Thu, 1 Apr 2004 16:49:35 -0700, Jack Hamilton
>Macro variables are stored as strings, but so are programs. The code
>below would translate to
> select hospname into :hosp from ia.hospitals where hospid=7673;
>which is valid code if hospid is numeric.
>Please post the relevant part of your job log so we can possibly see
>what error is actually happening.
>Are you sure that there's a hospital with HOSPID=7673 in your data
>Manager, Technical Development
>Metrics Department, First Health
>West Sacramento, California USA
>>>> vdesilva <vldesilva@CS.COM> 04/01/2004 3:33 PM >>>
>%let hospid = 7673;
>select hospname into :hosp from ia.hospitals where hospid=&hospid;
>I have the above code, hospid is a numeric coulmn in the data set.
>Since macro variables are stored as string the Where clause doesn't
>work. How can I convert the macro variable to numric and make the PROC
>SQL work for me. Thanks.