topic converting sql query into sas proc sql in Developers

sql query conversion to proc sql

lakshya — Fri, 21 Jul 2017 13:22:03 GMT

need help to convert below sql query into proc sql or data set query of sas

Select x.*
from yyy x
inner join
(
select abc, ad, min(date) as Minad
from dbo.xx
where xx in ('xx' ,'xx' ,'xx' ) AND Activity_Date >= 'mm/dd/yyyy'
group by case_ID, Activity
)
as b on a.abc = b.abc and a.ad=b.Minad
where (a.ad)>= 'mm/dd/yyyy' and a.abc in ('xx' ,'xx' ,'xx' ) AND B.xx IS NOT NULL
group by a.abc,a.xx,b.xx

converting sql query into sas proc sql

lakshya — Fri, 21 Jul 2017 13:26:24 GMT

need help to convert below sql query into proc sql or data set query of sas

Re: sql query conversion to proc sql

kiranv_ — Fri, 21 Jul 2017 13:35:43 GMT

I do not completly understand the query. But most of it should work in Proc SQL too. Except few changes where you mention date columns and at is not null.

Activity_Date >= 'mm/dd/yyyy'

Activity_Date >= 'ddmmmyyyy'd example '21jul2017'd

is not null

is not missing

Re: converting sql query into sas proc sql

PeterClemmensen — Fri, 21 Jul 2017 13:41:38 GMT

As I read it, there is nothing in your code not supported by PROC SQL in SAS, so simply wrap it inside a PROC SQL call.

Re: converting sql query into sas proc sql

art297 — Fri, 21 Jul 2017 13:48:12 GMT

If activity_date and ad are SAS dates, and 'mm/dd/yy' are actually numbers, you should use the form:

AND Activity_Date >= 'ddmonyyyy'd

Art, CEO, AnalystFinder.com

Re: converting sql query into sas proc sql

PeterClemmensen — Fri, 21 Jul 2017 13:51:17 GMT

@art297 good catch 🙂

Re: converting sql query into sas proc sql

lakshya — Fri, 21 Jul 2017 13:51:39 GMT

But it's not working so syntax error
It gives syntax error

Re: converting sql query into sas proc sql

PeterClemmensen — Fri, 21 Jul 2017 13:56:32 GMT

What error appears in the log?

Re: converting sql query into sas proc sql

Reeza — Fri, 21 Jul 2017 15:33:06 GMT

Post your FULL LOG.