topic Re: label variables during proc transpose long to wide in SAS Programming

label variables during proc transpose long to wide

Ronein — Sat, 26 Jun 2021 17:33:55 GMT

Hello

What is the way to label the following variables during proc transpose .

Label of variable Wealth1 will be Stocks wealth1

Label of variable Wealth2 will be Stocks wealth2

Label of variable Wealth3 will be Stocks wealth3

Label of variable Wealth4 will be Stocks wealth4

Label of variable Wealth5 will be Stocks wealth15

Data have;
label wealth='Stocks wealth';
input CustID month wealth;
cards;
1 2101 10
1 2102 20
1 2103 30
1 2104 40
1 2105 50
2 2101 5
2 2102 10
2 2103 15
2 2104 20
2 2105 25
;
Run;
proc transpose data=have  out=Want (drop=_name_ ) prefix=wealth;
VAR wealth ;
BY CustID ;
Run;

Re: label variables during proc transpose long to wide

Kurt_Bremser — Sat, 26 Jun 2021 17:42:06 GMT

Prepare the wanted names and labels in a preceding step, and use the ID and IDLABEL statements of PROC TRANSPOSE

Re: label variables during proc transpose long to wide

PaigeMiller — Sat, 26 Jun 2021 18:13:08 GMT

After all this time, with @Kurt_Bremser and myself and others constantly advising you to avoid wide data sets, I am surprised that you keep using wide data sets. The best thing to do would be to leave the data as long, and then programming is sooooo much easier.

Re: label variables during proc transpose long to wide

Kurt_Bremser — Sat, 26 Jun 2021 18:23:30 GMT

I (of course) concur with @PaigeMiller about the uselessness of wide datasets, see Maxim 19.

Wide reports can easily be done with PROC REPORT.

Re: label variables during proc transpose long to wide

Ronein — Sun, 27 Jun 2021 03:48:05 GMT

I need to prepare a data panel with one row per customer and from this panel will create reports in Tableu.

This is the reason for wide structure.

Do you still think that it is wrong (for using panel)?

Re: label variables during proc transpose long to wide

Ronein — Sun, 27 Jun 2021 03:49:22 GMT

Thanks, however during transpose from long to wide there is no need to use ID statement.

What is the way to add the labels?

Re: label variables during proc transpose long to wide

Kurt_Bremser — Sun, 27 Jun 2021 05:29:14 GMT

@Ronein wrote:

Thanks, however during transpose from long to wide there is no need to use ID statement.

What is the way to add the labels?

The IDLABEL statement.

So you need to create the labels first.

Re: label variables during proc transpose long to wide

ChrisNZ — Sun, 27 Jun 2021 05:29:36 GMT

Can't Tableau create reports from long data? I'd be surprised.

Just supply Tableau with the long data -prepared as needed- and let Tableau present it.

Re: label variables during proc transpose long to wide

Sajid01 — Sun, 27 Jun 2021 17:04:49 GMT

Modify your prefix in proc transpose as follows

proc transpose data=have  out=Want (drop=_name_  _LABEL_) prefix='Stocks Wealth'n;
VAR wealth ;
BY CustID ;
Run;

Your output will be like this