BookmarkSubscribeRSS Feed
nayab_shaik
Calcite | Level 5

Hi Team,

 

i have 100 data sets how to find out only data set name

 

Advance Thanks

 

5 REPLIES 5
PeterClemmensen
Tourmaline | Level 20

What do you want to do with those names? Put them in a macro variable?

 

If so

 

proc sql;
    select memname into :DataSets separated by ' '
    from dictionary.tables
    where libname='SASHELP';
quit;

%put &DataSets;
nayab_shaik
Calcite | Level 5

ds1 ds2 ds3 ds4 ..................................................................................ds100 like that

PeterClemmensen
Tourmaline | Level 20

Have you tried my posted code?

Jagadishkatam
Amethyst | Level 16

alternatively please try

 

data want;
set sashelp.vtable;
run;
Thanks,
Jag
PaigeMiller
Diamond | Level 26

Hello @nayab_shaik 


Would you please be kind enough to go back to your original post and provide a meaningful title instead of "sas"? Thank you.

--
Paige Miller

sas-innovate-white.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9.

 

Early bird rate extended! Save $200 when you sign up by March 31.

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
  • 5 replies
  • 1055 views
  • 1 like
  • 4 in conversation