Thanks to ballardw, here is the properly pasted code:
data have;
input Customer_ID $1 Customer_Cat $3;
datalines;
1 A
1 A
1 A
2
2 B
2 B
3
3
3 A
3 C
3
;
run;
data want;
input Customer_ID $1 Customer_Cat $3 Derived_Customer_Cat $5;
datalines;
1 A A
1 A A
1 A A
2 B
2 B B
2 B B
3 A
3 A
3 A A
3 C A
3 A
;
run;
... View more
Hi,
(I posted a similar request a few minutes ago, but the datalines in that one got shifted when pasted here. And here it is again.)
I need to assign a customer category in a new variable (Derived_Customer_Cat) to each customer record based on the first non-missing value of a variable (Customer_Cat) for all records of the same customer (Customer_ID). And the following code is a demonstration of what I have and want.
Can you help me find an efficient approach? Thank you!
Jason
data have; input Customer_ID $1 Customer_Cat $3; datalines; 1 A 1 A 1 A 2 2 B 2 B 3 3 3 A 3 C 3 ; run;
data want; input Customer_ID $1 Customer_Cat $3 Derived_Customer_Cat $5; datalines; 1 A A 1 A A 1 A A 2 B 2 B B 2 B B 3 A 3 A 3 A A 3 C A 3 A ; run;
... View more
Sorry the datalines for "want" got shifted. And here is what the data steps should be:
data have; input Customer_ID $1 Customer_Cat $3; datalines; 1 A 1 A 1 A 2 2 B 2 B 3 3 3 A 3 C 4 4 4 C 4 D 4 D 4 ; run;
data want; input Customer_ID $1 Customer_Cat $3 Derived_Customer_Cat $5; datalines; 1 A A 1 A A 1 A A 2 B 2 B B 2 B B 3 A 3 A 3 A A 3 C A 4 C 4 C 4 C C 4 D C 4 D C 4 C C ; run;
... View more
Hi,
I need to assign a customer category in a new variable (Derived_Customer_Cat) to each customer record based on the first valid value of a variable (Customer_Cat) for all records of the same customer (Customer_ID). And the following code is a demonstration of what I have and want.
Can you help me find an efficient approach? Thank you!
Jason
data have; input Customer_ID $1 Customer_Cat $3; datalines; 1 A 1 A 1 A 2 2 B 2 B 3 3 3 A 3 C 4 4 4 C 4 D 4 D 4 ; run;
data want; input Customer_ID $1 Customer_Cat $3 Derived_Customer_Cat $5; datalines; 1 A A 1 A A 1 A A 2 B 2 B B 2 B B 3 A 3 A 3 A A 3 C A 4 C 4 C 4 C C 4 D C 4 D C 4 C ; run;
... View more
In fact, "Region01", etc. are just examples. I have 14 columns with regional values and they all have random region names, like HNHB, ESC, TC, etc. How should that be handled? Thanks.
... View more
Hi there,
I have a dataset like this:
Product Region01 Region02 Region03 ...... Region14
Cat1 10 20 30 45
Cat2 100 200 300 20
......
And need to transform it into something like this:
Product Region Quantity
Cat1 Region01 10
Cat1 Region02 20
Cat1 Region03 30
...........................................
Cat1 Region14 45
Cat2 Region01 100
Cat2 Region02 200
Cat2 Region03 300
..............................................
Cat2 Region 14 20
.............................................
Is there a way to do this efficiently? Thanks.
... View more
Hi There,
I have a character variable with values of different lengths:
CharVar
Region One
Region Two
Region Three
......
I need to dynamically determine the lengths of these values, i.e.:
length for the first obs is 10
length for the second obs is 10
length for the third obs is 12
etc.
Is there a way to do it?
Thank you!
... View more
