BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
eagles_dare13
Obsidian | Level 7

If I have 2 data sets:

data investment;  

   begin='01JAN1990'd;

   end='31DEC2009'd;

  run;    

data investment_2;  

   begin='01JAN1990'd;

     run; 

I wish to write a program that will give me list of all columns that are in investment but not in investment_2. So in this case, the variable 'end'.

How to do this? I dont want to list out the column names using proc contents on eaqch dataset and then manually eyeball it and check for differences.

1 ACCEPTED SOLUTION

Accepted Solutions
data_null__
Jade | Level 19
proc compare base=investment(obs=0) compare=investment_2(obs=0) listbase;
  
run;

View solution in original post

1 REPLY 1
data_null__
Jade | Level 19
proc compare base=investment(obs=0) compare=investment_2(obs=0) listbase;
  
run;

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
How to choose a machine learning algorithm

Use this tutorial as a handy guide to weigh the pros and cons of these commonly used machine learning algorithms.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 3309 views
  • 0 likes
  • 2 in conversation