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
April 27 – 30 | Gaylord Texan | Grapevine, Texas
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 save with the early bird rate—just $795!
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.
Ready to level-up your skills? Choose your own adventure.