lundi 21 août 2017

creating multiple variables using multiple variables in sas

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