topic creating a vector in SAS Programming https://communities.sas.com/t5/SAS-Programming/creating-a-vector/m-p/88297#M18828 <HTML><HEAD></HEAD><BODY><P>Hello,<BR />Below is a small sample of a large data set. </P><P>Firmid year segmentID segmentsales siccode<BR />1001 1999 1 20 4100<BR />1001 1999 2 10 4200<BR />1001 2000 1 15 4100<BR />1001 2000 2 12 4200<BR />1001 2000 3 13 5100<BR />1002 1999 1 20 4100<BR />1002 1999 2 13 9100<BR />1002 2001 1 20 2867<BR />1002 2001 2 13 3200<BR />1002 2000 3 20 7100</P><P></P><P>1. First, I can compute how many unique siccode my data has, in this small example above, I have 7 unique siccode<BR />2. my vector will have 7 elements, each element correspond to the segmentsales, for each firm-year, there are non-zero segmentsales and zero segmentsales&nbsp; (when the firm does not have such a segment), e.g. firmid=1001, year=1999, my vector =[20,10,0,0,0,0,0], firmid=1001, year=2000, my vector =[15,12,13,0,0,0]</P><P></P><P>How should I program this?</P><P></P><P>Thanks!</P><P>Lan</P></BODY></HTML> Mon, 25 Mar 2013 21:22:10 GMT LanMin 2013-03-25T21:22:10Z creating a vector https://communities.sas.com/t5/SAS-Programming/creating-a-vector/m-p/88297#M18828 <HTML><HEAD></HEAD><BODY><P>Hello,<BR />Below is a small sample of a large data set. </P><P>Firmid year segmentID segmentsales siccode<BR />1001 1999 1 20 4100<BR />1001 1999 2 10 4200<BR />1001 2000 1 15 4100<BR />1001 2000 2 12 4200<BR />1001 2000 3 13 5100<BR />1002 1999 1 20 4100<BR />1002 1999 2 13 9100<BR />1002 2001 1 20 2867<BR />1002 2001 2 13 3200<BR />1002 2000 3 20 7100</P><P></P><P>1. First, I can compute how many unique siccode my data has, in this small example above, I have 7 unique siccode<BR />2. my vector will have 7 elements, each element correspond to the segmentsales, for each firm-year, there are non-zero segmentsales and zero segmentsales&nbsp; (when the firm does not have such a segment), e.g. firmid=1001, year=1999, my vector =[20,10,0,0,0,0,0], firmid=1001, year=2000, my vector =[15,12,13,0,0,0]</P><P></P><P>How should I program this?</P><P></P><P>Thanks!</P><P>Lan</P></BODY></HTML> Mon, 25 Mar 2013 21:22:10 GMT https://communities.sas.com/t5/SAS-Programming/creating-a-vector/m-p/88297#M18828 LanMin 2013-03-25T21:22:10Z Re: creating a vector https://communities.sas.com/t5/SAS-Programming/creating-a-vector/m-p/88298#M18829 <HTML><HEAD></HEAD><BODY><P>Are you programming in IML or BASE? If IML you may want to repost this in the IML forum.</P></BODY></HTML> Mon, 25 Mar 2013 22:39:44 GMT https://communities.sas.com/t5/SAS-Programming/creating-a-vector/m-p/88298#M18829 Reeza 2013-03-25T22:39:44Z Re: creating a vector https://communities.sas.com/t5/SAS-Programming/creating-a-vector/m-p/88299#M18830 <HTML><HEAD></HEAD><BODY><P>I do not know how to program in IML.</P></BODY></HTML> Tue, 26 Mar 2013 03:13:59 GMT https://communities.sas.com/t5/SAS-Programming/creating-a-vector/m-p/88299#M18830 LanMin 2013-03-26T03:13:59Z