topic Re: how to tranpose data if the first words are the same in SAS Enterprise Guide

how to tranpose data if the first words are the same

Pato485 — Thu, 08 Jun 2023 08:37:19 GMT

Hello,

how can i transpose data if i have transposed data which first few words are the same, and this method take just few words at the start but now thole field, i got error:

ERROR: The ID value "'Dávka pre prípad hospitalizácie'n" occurs twice in the same BY group.
NOTE: The above message was for the following BY group:
K_PART=17 C_PZ=0304626732

But there are not the same words:

There are more words like that, not the same, just the beggining of field is the same, and it just appear to be transposing it be few first letters in the field.

Is there a way how to take whole name and transpose it with whole name in the field (in my case it is field description).

Thank you.

Re: how to tranpose data if the first words are the same

Kurt_Bremser — Thu, 08 Jun 2023 08:49:33 GMT

SAS variable names are limited to 32 characters, so your values cause a collision.

What are you trying to achieve? If this is for reporting, PROC REPORT is the right tool.

Re: how to tranpose data if the first words are the same

Pato485 — Thu, 08 Jun 2023 08:53:54 GMT

i have to get all rows in description field to distinct columns... and if it is on the contract so there will be in field 1, so exampe

Contract Mortgage Credit Card

1 1 1

3 1

something like that.

Re: how to tranpose data if the first words are the same

Kurt_Bremser — Thu, 08 Jun 2023 08:59:07 GMT

Is this for reporting purposes?

Re: how to tranpose data if the first words are the same

Pato485 — Thu, 08 Jun 2023 09:02:37 GMT

never heard of proc report. Can i use the data after in enterprise guide? To work with them after proc report? what is the base syntax pls?

Re: how to tranpose data if the first words are the same

Kurt_Bremser — Thu, 08 Jun 2023 09:43:39 GMT

"Working" with such variable names will be a catastrophic pain in the ass, and you should avoid it like hell.

All processing is much better done from a "long" dataset layout. "Wide" is only good for reporting purposes, and needed for a very limited number of tasks (regression analysis among them). For the latter, simpler variable names should be introduced, and your complex strings used as labels.

PROC REPORT will look like this:

proc report data=your_dataset;
column k_part c_pz description,hooo;
define k_part / group;
define c_pz / group;
define description / "" across;
define hooo / "" analysis;
run;

Re: how to tranpose data if the first words are the same

PaigeMiller — Thu, 08 Jun 2023 11:56:15 GMT

@Pato485 wrote:

i have to get all rows in description field to distinct columns... and if it is on the contract so there will be in field 1, so exampe

Contract Mortgage Credit Card

1 1 1

2

3 1

something like that.

How does this apply to the text fields that you showed originally? Why would you want those text strings as a variable name? Please EXPLAIN further.

SAS works best with long data sets, not wide data sets. Almost all SAS procedures expect long data sets, and wide data sets are much more difficult to work with.

Re: how to tranpose data if the first words are the same

Tom — Thu, 08 Jun 2023 12:36:00 GMT

You need to find (or create) another variable that you can use in the ID statement to set the new variable's NAME.

You can use the IDLABEL statement to tell PROC TRANSPOSE to use that DESCRIPTION variable as the new variable's LABEL instead.