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
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]
@Reeza wrote:
What happens when you try it?
... which is exactly what I would do if I had this question.
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]
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.