Hi everyone, I am new in this forum

[dearsamuna]

I just joined a company.They have assigned me a simple job.Here is what it looks like.Please respond
Thanks in advance.Only the difference between input and output is that 10 is replaced by 20,30 and 40 and
all the data sets are concatenated. Plzz help otherwise my job is in danger.

Input data is

SampleId sal dob phone

10-1xxx-001 37645 04/23/1978 728364539
10-2xxx-002 38746 05/23/1967 938746355
10-4yyy-511 49875 01/11/1987 938874653
10-2zzz-411 48765 02/22/1954 763542317
10-3xxx-003 48746 05/21/1987 883736335

Output should be like below

SampleId sal dob phone

10-1xxx-001 37645 04/23/1978 728364539
10-2xxx-002 38746 05/23/1967 938746355
10-4yyy-511 49875 01/11/1987 938874653
10-2zzz-411 48765 02/22/1954 763542317
10-3xxx-003 48746 05/21/1987 883736335
20-1xxx-001 37645 04/23/1978 728364539
20-2xxx-002 38746 05/23/1967 938746355
20-4yyy-511 49875 01/11/1987 938874653
20-2zzz-411 48765 02/22/1954 763542317
20-3xxx-003 48746 05/21/1987 883736335
30-1xxx-001 37645 04/23/1978 728364539
30-2xxx-002 38746 05/23/1967 938746355
30-4yyy-511 49875 01/11/1987 938874653
30-2zzz-411 48765 02/22/1954 763542317
30-3xxx-003 48746 05/21/1987 883736335
40-1xxx-001 37645 04/23/1978 728364539
40-2xxx-002 38746 05/23/1967 938746355
40-4yyy-511 49875 01/11/1987 938874653
40-2zzz-411 48765 02/22/1954 763542317
40-3xxx-003 48746 05/21/1987 883736335

 

[sasbuddy]

Dear dearsamuna,

Please look at the code I have provided at your other query regarding the same question.
I am sure it will work; and all the best.




sasbuddy

http://sites.google.com/site/sasbuddy/