Take all cells values from another tables

🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.

Tourmaline | Level 20

Re: Take all cells values from another tables

Posted 09-30-2015 06:12 AM (390 views) | In reply to ChrisNZ

Note that when doing the merge

  merge TABLE2
        TABLE(in=Y);

you are matching one to one, so the shortest table (in terms of number of observations) stops the processing even if the other one is longer.

High-Performance SAS Coding - Third Edition

April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Call for Content EXTENDED

Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.

Submit your proposal!

Re: Take all cells values from another tables

Registration is open

Call for Content EXTENDED

SAS Training: Just a Click Away