topic Re: How to update a table in SAS Programming

How to update a table

Ruolin — Wed, 04 Feb 2015 03:24:03 GMT

Hi all, I am having a problem getting a table in a way I want it to look like.

For example,

my table is the following,

ID_number SUB_number

ID1 SUB1

ID1 SUB2

ID2 SUB3

I am wondering if there is a query that can transform my table into the following

ID_number SUB_number SUB_number2

ID1 SUB1 SUB2

ID2 SUB3

( SUB1 and SUB2 are associated with the same ID1)

Please advise.

Re: How to update a table

mohamed_zaki — Wed, 04 Feb 2015 05:27:35 GMT

data have;

input a $ b $;

cards;

ID1 SUB1

ID1 SUB2

ID2 SUB3

ID3 SUB5

;

run;

proc transpose data=have out=new (drop=_name_);

by a;

var b;

run;

Re: How to update a table

Patrick — Wed, 04 Feb 2015 07:42:28 GMT

Just a little variation to above creating variable names closer to your output data set

data have;

input ID_number $ sub_number $;

cards;

ID1 SUB1

ID1 SUB2

ID2 SUB3

ID3 SUB5

;

run;

proc transpose data=have out=new (drop=_:) prefix=SUB_Number;

by id_number;

var sub_number;

run;

Re: How to update a table

Loko — Wed, 04 Feb 2015 08:26:32 GMT

Hello,

A lot of questions have been asked related to this topic. Just search for "Transpose" within the search facility of the forum and you may find a lot of interesting and useful answers (besides the ones you have already got on your post).

Here is one example:

https://communities.sas.com/message/206611#206611