cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
BookmarkSubscribeRSS Feed
_LB
Fluorite | Level 6 _LB
Fluorite | Level 6

using calculated function in PROC SQL for join statements

Posted 04-28-2011 06:14 PM (3117 views)
Hi all-
I know you can use the calculated statement in where statements, but what about joins?

Unfortunately someone added a zero in a column that I strip out but when I attempt a join as
A Left join B on CALCULATED ENC=b.ENCTR
where ENC is the new column and b.ENCTR is an original column, it throws back an error...

Any help, mightly appreciated...
Thanks again!

Lawrence
0 Likes
Reply
1 REPLY 1
_LB
Fluorite | Level 6 _LB
Fluorite | Level 6

Re: using calculated function in PROC SQL for join statements

Posted 04-28-2011 06:34 PM (3040 views)  |   In reply to _LB
Ignore..I managed to embed the who case statement in the join..
Thanks!
0 Likes
Reply

Catch up on SAS Innovate 2026

Nearly 200 sessions are now available on demand with the SAS Innovate Digital Pass.

Explore Now →
How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Watch How to Concatenate Values on YouTube

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • ‎04-28-2011 06:14 PM
  • 3118 views
  • 0 likes
  • 1 in conversation