topic Re: Possible do while or do until in SAS Procedures

Possible do while or do until

Q1983 — Fri, 05 Dec 2014 16:47:17 GMT

Newbie to sas with a question

data borrower (keep=ln_no id_no);

set table1;

run;

sample data

ln_no id_no

1111 00000

1112 00000

1113 00002

1114 00006

1115 99999

1116 99999

I want to be able to show the data like this

id_no first_ln_no second_ln_no

00000 11111 11112

00002 11113

00006 11114

99999 11115 11116

There can be up to 5 scenarios where one id_no could have several ln_no. Would I need some type of do until statement

Re: Possible do while or do until

Cynthia_sas — Fri, 05 Dec 2014 17:35:41 GMT

I'd probably try PROC TRANSPOSE first.

cynthia

Re: Possible do while or do until

ballardw — Fri, 05 Dec 2014 17:43:55 GMT

Just for clarification: You sample data shows ln_no with 4 characters but the desired output the variable has 5. Is that by chance an error in pasting the sample data?

Re: Possible do while or do until

Q1983 — Fri, 05 Dec 2014 17:51:53 GMT

Your solution worked lik a charm. Here is a sample code and output

proc transpose data=borrower out=borrower2

(drop = _NAME_ _LABEL_) ;

id ln_no

by id_no;

var ln_no;

run;

sample output

id_no 11111 11112

00000 11111 11112

Is there a way to assign label to the value as a header. What happens is I get the actual data as both a header and in the detail

Re: Possible do while or do until

Q1983 — Fri, 05 Dec 2014 17:57:00 GMT

I think I figured it out, just use idlabel