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

Hi I am trying to group on a table and I am trying to bring back just 1 column, I can do using SQL but I was wandering if someone knows how to do it in data step. The table has many columns but I only want to bring back 1.

 

Proc sql;  
select distinct t1.month_received
from have t1;
run;

I tried using Proc Sort but I was not sure how to bring back just the one column, is there anyway I can bring back just the 1 column or do I have to create another data step

proc sort data=have nodupkey out=have1;
by month_received;
run;
1 ACCEPTED SOLUTION

Accepted Solutions
kiranv_
Rhodochrosite | Level 12

Try 

proc sort data=have(keep=month_received) nodupkey out=have1;
by month_received;
run

View solution in original post

2 REPLIES 2
kiranv_
Rhodochrosite | Level 12

Try 

proc sort data=have(keep=month_received) nodupkey out=have1;
by month_received;
run
zdassu
Quartz | Level 8
Thanks for your help kiranv_
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
  • 1126 views
  • 0 likes
  • 2 in conversation