topic Re: proc transpose wide to long in SAS Programming

proc transpose wide to long

Ronein — Tue, 11 Jan 2022 12:35:45 GMT

Hello

I ask prefix "value" but in result I see prefix "value1"- what is the reason?

I want to get new column name "value" and not "value1"


data wide; 
  input famid faminc96 faminc97 faminc98 ; 
cards; 
1 40000 40500 41000 
2 45000 45400 45800 
3 75000 76000 77000 
; 
run; 
proc transpose data=wide out=long prefix=value;
   by famid;
run;

Re: proc transpose wide to long

PaigeMiller — Tue, 11 Jan 2022 12:47:53 GMT

proc transpose data=wide out=long(rename=(value1=value)) prefix=value;

Re: proc transpose wide to long

ballardw — Tue, 11 Jan 2022 15:52:46 GMT

The reason is that is the way Proc Transpose works. It does not know that you will only have one value as each duplicate of the BY variable(s) increments the count.

Essential Meaning of prefix

: to add a letter, number, or symbol at the beginning of a word or number

So the Prefix option just says what the output variable names start with.

Re: proc transpose wide to long

data_null__ — Tue, 11 Jan 2022 16:09:04 GMT

You could use the ID statement which would build-in a check for unique BY groups.

data wide; 
  input famid faminc96 faminc97 faminc98 ; 
  retain id 'Value';
cards; 
1 40000 40500 41000 
2 45000 45400 45800 
3 75000 76000 77000 
; 
run; 
proc transpose data=wide out=long;
   by famid;
   id id;
   run;
proc print;
   run;