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;

sas-innovate-2026-white.png



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!

Register now

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
  • 4017 views
  • 0 likes
  • 2 in conversation