topic Long to wide in SAS Programming

Long to wide

Ronein — Tue, 18 Jan 2022 08:06:39 GMT

Hello

What is the way to create "want" data set from "Have data set"?

(Long to wide)

Data have;
input Key CustomerID seq;
cards;
111 2345677 1
111 4356674 2
111 3467886 3
444 4456567 1
444 8837737 2
222 5575775 1
;
Run;

Data want;
input key  CustomerID1 CustomerID2 CustomerID3;
cards;
111 2345677 4356674 3467886
444 4456567 8837737 .
222 5575775 . .
;
Run;

Re: Long to wide

andreas_lds — Tue, 18 Jan 2022 08:09:57 GMT

Ok, Ronin this is the nth time you ask for transposing data, so: what have you tried? What is the problem?

Re: Long to wide

Kurt_Bremser — Tue, 18 Jan 2022 09:07:45 GMT

PROC TRANSPOSE with PREFIX option and seq as ID. Unless you sort first, you'll need a NOTSORTED option in the BY.

Re: Long to wide

Oligolas — Tue, 18 Jan 2022 10:16:50 GMT

😁

Fill in the blanks:

PROC ____ data=____;by ___ ___; RUN;
PROC _________ data=____ out=_____(drop=______) prefix=__________;
   by ___;
   var __________;
   id ___;
RUN;

PROC SORT data=have;by key seq; RUN;
PROC TRANSPOSE data=have out=trans(drop=_name_) prefix=CustomerID;
by key;
var customerID;
id seq;
RUN;

Re: Long to wide

Reeza — Tue, 18 Jan 2022 15:56:37 GMT

If you don't want to learn how to code use the Tasks, point and click, which guide you through the process.

https://documentation.sas.com/doc/en/webeditorcdc/v_003/webeditorref/n0an4t2gh0zmb3n13i9afkc7xqao.htm

@Ronein wrote:

Hello

What is the way to create "want" data set from "Have data set"?

(Long to wide)

Data have;
input Key CustomerID seq;
cards;
111 2345677 1
111 4356674 2
111 3467886 3
444 4456567 1
444 8837737 2
222 5575775 1
;
Run;

Data want;
input key  CustomerID1 CustomerID2 CustomerID3;
cards;
111 2345677 4356674 3467886
444 4456567 8837737 .
222 5575775 . .
;
Run;

Re: Long to wide

Reeza — Tue, 18 Jan 2022 15:58:38 GMT