topic Re: Need help in Do loop incremented by delimiter in SAS Procedures

Need help in Do loop incremented by delimiter

RaviKommuri — Tue, 14 Oct 2014 11:16:17 GMT

Hello,

I have a delimited raw data file .

Now I want to create a SAS dataset using the raw data file using Do loop as there are variable number of records and variable length fileds.

How to increment it in Do loop.

Input :

A 1*2*3*4*5

B 5*6*7

C 1*45*78*54

Desired Output:

A 1

A 2

A 3

A 4

A 5

B 5

B 6

B 7

C 1

C 45

C 78

C 54

I am not getting how to increment the DO loop with delimiter value.....

Thanks....

Re: Need help in Do loop incremented by delimiter

LinusH — Tue, 14 Oct 2014 11:46:26 GMT

Use scan(var,n,'*') together with a do until loop.

Re: Need help in Do loop incremented by delimiter

RaviKommuri — Tue, 14 Oct 2014 11:52:55 GMT

Can you please let me know how to write that if my delimiter is Hex Value ('41'x) instead of '*' ?

Re: Need help in Do loop incremented by delimiter

gergely_batho — Tue, 14 Oct 2014 11:59:55 GMT

scan(var,n,'41'x)

Re: Need help in Do loop incremented by delimiter

Ksharp — Tue, 14 Oct 2014 12:16:44 GMT

data have;
infile cards dlm=' *' truncover;
input id $ v $ @;
do until(missing(v));
 output;
 input v $ @;
end;
cards;
A   1*2*3*4*5
B   5*6*7
C   1*45*78*54
;
run;

Xia Keshan

Re: Need help in Do loop incremented by delimiter

RaviKommuri — Tue, 14 Oct 2014 13:27:03 GMT

Thank you all.... 🙂