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

Hi,

I have dataset with 10 variables. One of the variables represents the dataset LABEL.  I would like to know if there is way to LABEL the dataset based on the variable value.

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Haikuo
Onyx | Level 15

Not sure what your data looks like and what you exactly want, the following code may or may not hit the nail:

data test;

     set sashelp.orsales(obs=1);

run;

DATA _NULL_;

     set test;

     call symputx('dlabel', product_group);

     stop;

run;

proc datasets lib=work;

     modify test (label="&DLABEL");

quit;

proc sql;

     select MEMlabel from dictionary.tables where LIBNAME='WORK' AND MEMNAME='TEST';

QUIT;

Haikuo

View solution in original post

2 REPLIES 2
Haikuo
Onyx | Level 15

Not sure what your data looks like and what you exactly want, the following code may or may not hit the nail:

data test;

     set sashelp.orsales(obs=1);

run;

DATA _NULL_;

     set test;

     call symputx('dlabel', product_group);

     stop;

run;

proc datasets lib=work;

     modify test (label="&DLABEL");

quit;

proc sql;

     select MEMlabel from dictionary.tables where LIBNAME='WORK' AND MEMNAME='TEST';

QUIT;

Haikuo

rakeshvvv
Quartz | Level 8

Perfect Sir...This is what i want... Thanks

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

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
  • 3985 views
  • 1 like
  • 2 in conversation