Learning SAS? Welcome to the exclusive online community for all SAS learners.

missing data after merging two datasets

Reply
Contributor rj
Contributor
Posts: 36

missing data after merging two datasets

Hi, 

 

I am using SAS university edition, I merged two dataset using data step function and after merging it, I saw that the final dataset has all the columns from both the dataset but it is missing all the values from second dataset.

How do I know what might be causing this problem.

Any suggestions/leads will be very helpful.

 

Thanks, 

RJ

Super Contributor
Posts: 252

Re: missing data after merging two datasets

Can you please show the code, and some sample data? It's guess-work otherwise.

Super User
Posts: 11,343

Re: missing data after merging two datasets

A guess: You did some sort of filter either a where statement, where dataset option or IF statement and result is that none of the records from dataset 2 were kept in the result.

 

SHOW your code. It is very simple to copy from the editor and paste, preferrably in a code box using the {i} icon, into the forum.

Ask a Question
Discussion stats
  • 2 replies
  • 198 views
  • 0 likes
  • 3 in conversation