topic Passing Calculated column into proc sql correlated query in SAS Programming

Passing Calculated column into proc sql correlated query

Leo9 — Fri, 02 Oct 2020 15:55:42 GMT

Hi All,

Is it possible to pass a calculated column into proc sql co-related query ? Something like this

where calculated daten in( select trtsdt from adam.adsl where (trtsdt ne .) and (trtsdt<= calculated daten <=trtsdt+10) )
group by usubjid

Re: Passing Calculated column into proc sql correlated query

Reeza — Fri, 02 Oct 2020 16:04:19 GMT

What happens when you try it?

Re: Passing Calculated column into proc sql correlated query

mkeintz — Fri, 02 Oct 2020 20:34:04 GMT

@Reeza wrote:
What happens when you try it?

... which is exactly what I would do if I had this question.

Re: Passing Calculated column into proc sql correlated query

PGStats — Fri, 02 Oct 2020 21:44:18 GMT

To quote the documentation:

"CALCULATED enables you to use the results of an expression in the same SELECT clause or in the WHERE clause. It is valid only when used to refer to columns that are calculated in the immediate query expression."

[my underlining]