BookmarkSubscribeRSS Feed
vishyy
Obsidian | Level 7

Hi All.

 

I have a huge dataset which has various coulmns(variables).

I want to find different values that exist in the dataset for a particular variable.

 

Thanks in advance 

Vishyy

 

2 REPLIES 2
JoshB
Quartz | Level 8

Two approaches I use often.

 

PROC SQL

proc sql;
  create table WANT as
    select DISTINCT VARIABLE
    from HAVE;
quit;

SORT PROCEDURE

proc sort data=HAVE(keep=VARIABLE) nodupkey out=WANT;
  by VARIABLE;
run;
Astounding
PROC Star

To get just a little more information, you could try:

 

proc freq data=have;

tables variable / missing;

run;

 

Now you'll see how often each value appears in your data set.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

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
  • 2 replies
  • 1222 views
  • 0 likes
  • 3 in conversation