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;
Try
proc sort data=have(keep=month_received) nodupkey out=have1;
by month_received;
run
Try
proc sort data=have(keep=month_received) nodupkey out=have1;
by month_received;
run
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.