the data is like this..... Line1 Line2 Product_name Segment 1 Segment 2 EUCREAS ORAAL EUCREAS DPP-4 DPP-4 -EUCREAS GALVUS ORAAL GALVUS DPP-4 DPP-4 -GALVUS GLICLAZIDE ORAAL DIAMICRON SU SU -GLICLAZIDE GLICLAZIDE ORAAL GLICLAZIDE SU SU -GLICLAZIDE GLP-1 ORAAL BYDUREON GLP-1 GLP-1 GLP-1 ORAAL BYETTA GLP-1 GLP-1 GLP-1 ORAAL LYXUMIA GLP-1 GLP-1 GLP-1 ORAAL VICTOZA GLP-1 GLP-1 INSULINES INSULINES ACTRAPHANE INSULINES INSULINES INSULINES INSULINES ACTRAPID INSULINES INSULINES
here i have to use line1,line2 and product_name to create segment1 & segment2.
i can use if statement but are there any other way to do this in data step or proc sql.
Aucun commentaire:
Enregistrer un commentaire