topic Re: getting row values into column labels in SAS Programming

getting row values into column labels

shuvaya — Mon, 10 Oct 2022 05:57:37 GMT

Hi,

For the attached screenshot I want to have the values under __NAME__ appended to existing column names:

So output dataset will have only one row for a customer which will have column names snack_net_amount , breakfast_net_amount , snack_num_txns , breakfast_num_txns.

Can someone please help me with this?

I think I am missing something very basic, but since I am new to SAS, can't seem to figure it out.

Re: getting row values into column labels

ballardw — Mon, 10 Oct 2022 06:56:25 GMT

Provide example data in the form of a data step. We can't write code to use a screen shot.

Then provide what you expect as a result.

If your "customerid" values are so sensitive replace them in the example with some different values like XXXX and YYYY or similar.

Since a number of SAS procedures will create a variable like _NAME_ in the process it might be that you should share the data from before whatever you have done to create that example and show us the code used to create it. It may be that is the step to do this instead of afterwards.

Are you sure that you need a data set?

Re: getting row values into column labels

Ksharp — Mon, 10 Oct 2022 11:34:03 GMT

/*
As ballarwd pointed out.
Make a data step to represent your data,Nodoby would like to type it for you !
*/
data have;
input id name $ snack breakfast;
cards;
1 net_amou 27.97 1
1 num_txns 1  2
2 net_amou 27.97 1
2 num_txns 1  2
;

data temp;
 set have;
 n+1;
run;

proc transpose data=temp out=temp2;
by  n id name;
var  snack breakfast;
run;
proc transpose data=temp2 out=want delimiter=_;
by id;
id _name_ name;
var col1;
run;