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-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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