BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
Amir
PROC Star

Hi,

 

Just to make sure, are you saying using you have a solution now (using proc print)?

 

 

Thanks & kind regards,

Amir.

Tom
Super User Tom
Super User

So the actual question was how to look at the dataset created by the data step with the merge statement?

 

PS Please try to avoid attaching files.  When sharing code and log please share as text and use the Insert SAS Code or Insert Code buttons in the icon bar of the forum editor.  The same for data listings if you can (ODS output does make that almost impossible).  If you must share an image insert the image using the Insert Photos icon (or just paste it in).

PaigeMiller
Diamond | Level 26

Paste the text of the code and text of the log directly into your reply. Do not include it as an attachment.

 

And since we have asked many times, I ask one more time ... please EXPLAIN what is wrong with the results.

--
Paige Miller
Cynthia_sas
Diamond | Level 26

Hi:

  As several members have pointed out, your original code runs without error. Therefore, you either have a data problem or a program logic problem. Without more definition from you about exactly why you think your merge is not working, with examples, and what you would consider to be the correct results, with examples, it is nearly impossible to provide constructive suggestions. Several of us have posted information about how your original code is working without errors. There have also been repeated guesses about whether your using the correct variables in the merge or whether you need to merge by both ID and NAME or whether there is something wrong with your data. However, without some further clarification from you, it is hard to help.

Cynthia

Shailesh_R_T
Calcite | Level 5

here is code and log window for your reference. 

Cynthia_sas
Diamond | Level 26
Hi:
I still don't understand what is wrong with the way your merge is working. Your PDF examples do NOT have any errors and you do not show any wrong results, correct results or explain what results you want.
Cynthia

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

How to Concatenate Values

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.

SAS Training: Just a Click Away

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

Browse our catalog!

Discussion stats
  • 20 replies
  • 2780 views
  • 0 likes
  • 5 in conversation
OSZAR »