topic Re: Covert proc sql to a data step with a embedded query in SAS Programming

Covert proc sql to a data step with a embedded query

deleted_user — Tue, 03 Mar 2009 18:32:34 GMT

I'm trying to take the following query and make it into a data step.

select *
from tblAddress
where state not in (select value from tblStates )
and state ne '';

Is this possible with a data step?

I'm new to sas and appreciate everyone for helping me learn it better.

Jerry

Re: Covert proc sql to a data step with a embedded query

sbb — Tue, 03 Mar 2009 19:46:05 GMT

Yes. One approach is to create a SAS file (and sort it) from your tblStates and then using the DATA step technique, merge the sorted file with your other tblAddress file, using a BY statement.

Scott Barry
SBBWorks, Inc.

Re: Covert proc sql to a data step with a embedded query

deleted_user — Tue, 03 Mar 2009 20:35:06 GMT

Scott,
Thank you for your reply.

That helped a lot.

Jerry