BookmarkSubscribeRSS Feed
jdk123
Calcite | Level 5
is there a shortcut to keep only the last column in the dataset?

for instance, keep last_column

Thanks,
1 REPLY 1
data_null__
Jade | Level 19
If we assume that means the variable with the largest value of VARNUM then...

[pre]
42 proc sql;
43 select name into :lastName separated by ' '
44 from dictionary.columns
45 where libname='SASHELP' and memname='CLASS'
46 having varnum eq max(varnum)
47 ;
NOTE: The query requires remerging summary statistics back with the original data.
48 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.03 seconds
cpu time 0.03 seconds


49 run;
50 %put NOTE: LastName=&lastname;
NOTE: LastName=Weight
[/pre]

Use LASTNAME in a KEEP data set opion.

sas-innovate-white.png

Special offer for SAS Communities members

Save $250 on SAS Innovate and get a free advance copy of the new SAS For Dummies book! Use the code "SASforDummies" to register. Don't miss out, May 6-9, in Orlando, Florida.

 

View the full agenda.

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
  • 1 reply
  • 4405 views
  • 0 likes
  • 2 in conversation