Passing Calculated column into proc sql correlated query

[Leo9]

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

[Reeza]

What happens when you try it?

[mkeintz]

---

@Reeza wrote:
What happens when you try it?

---

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

[PGStats · Accepted solution]

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]