topic Re: in data i have product code of different type i need in separate line in SAS Programming

in data i have product code of different type i need in separate line

aanan1417 — Fri, 01 Apr 2022 05:46:55 GMT

data have;

input product_code product_1 product_id;

datalines;

1011/1234 abc 99

1011 def 88

1023/4098/7778/8989 gcj 76

;

run;

data want;

input product_code product_1 product_id;

datalines;

1011 abc 99

1234 abc 99

1011 def 88

1023 gcj 76

4098 gcj 76

7778 gcj 76

8989 gcj 76

;

run;

Re: in data i have product code of different type i need in separate line

Kurt_Bremser — Fri, 01 Apr 2022 06:43:39 GMT

 69         data have;
 70         input product_code product_1 product_id;
 71         datalines;
 
 NOTE: Invalid data for product_code in line 72 1-9.
 NOTE: Invalid data for product_1 in line 72 34-36.
 REGEL:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0                     
 72         1011/1234                        abc  99
 product_code=. product_1=. product_id=99 _ERROR_=1 _N_=1
 NOTE: Invalid data for product_1 in line 73 39-41.
 73         1011                                  def    88
 product_code=1011 product_1=. product_id=88 _ERROR_=1 _N_=2
 NOTE: Invalid data for product_code in line 74 1-19.
 NOTE: Invalid data for product_1 in line 74 26-28.
 74         1023/4098/7778/8989      gcj      76
 product_code=. product_1=. product_id=76 _ERROR_=1 _N_=3

As a very important learning experience, fix this first.

Re: in data i have product code of different type i need in separate line

andreas_lds — Fri, 01 Apr 2022 08:47:20 GMT

You need

function countw to get the number of "words" / product_codes
a loop
function scan to extract the codes from the list
output-statement

Re: in data i have product code of different type i need in separate line

aanan1417 — Fri, 01 Apr 2022 08:48:53 GMT

Thanks a ton