topic Re: how to assign variable value as label of another variable in SAS Programming

how to assign variable value as label of another variable

thanikondharish — Thu, 13 Sep 2018 07:22:02 GMT

data s ;
name='joseph' ;
new='peter ';
run;

how to assign value of name variable as a label of new variable like see below

	joseph
he is a stat programmer
harish	harish

Re: how to assign variable value as label of another variable

gamotte — Thu, 13 Sep 2018 07:47:23 GMT

I don't understand your example.

Is this what you want ?

data _NULL_;
set s;

call execute(cats('data S; set S; label new="',name,'"; run;'));
run;

Re: how to assign variable value as label of another variable

andreas_lds — Thu, 13 Sep 2018 08:00:06 GMT

Sorry, but i don't understand what you try to do.

What happened to Peter?

@thanikondharish wrote:

data s ;
name='joseph' ;
new='peter ';
run;

how to assign value of name variable as a label of new variable like see below

joseph

he is a stat programmer

harish

harish

Re: how to assign variable value as label of another variable

ballardw — Thu, 13 Sep 2018 15:21:56 GMT

@thanikondharish wrote:

data s ;
name='joseph' ;
new='peter ';
run;

how to assign value of name variable as a label of new variable like see below

joseph

he is a stat programmer

harish

harish

LABEL is a variable property. You can only have one label for a given variable. And does it need to be a label of a variable or the column heading for a report?

Give a more complex example of what you are attempting such as with three records with different values of name and "new" and what the resulting data set should look like.

Proc Transpose can use the value of variable to NAME a variable using the ID statement.