topic Re: I need help on this in SAS Data Management https://communities.sas.com/t5/SAS-Data-Management/I-need-help-on-this/m-p/209873#M4882 <HTML><HEAD></HEAD><BODY><P>Don't understand what you try to achieve, try to give a clearer example were you don't focus on output design.</P><P>Not knowing the underlying requirement, transposing data the way you describe is seldom a road to success for calculating or reporting.</P></BODY></HTML> Thu, 07 May 2015 13:37:47 GMT LinusH 2015-05-07T13:37:47Z I need help on this https://communities.sas.com/t5/SAS-Data-Management/I-need-help-on-this/m-p/209872#M4881 <HTML><HEAD></HEAD><BODY><P>data have;</P><P>infile datalines;</P><P>input id_acc&nbsp; acc_no&nbsp; status_code $5. info_date;</P><P>format info_date date9.;</P><P>datalines;</P><P>1111&nbsp; 999585548&nbsp; AAA 30Jun2007</P><P>1111&nbsp; 999585548&nbsp; AAA 31Jul2007</P><P>1111&nbsp; 999585544&nbsp; D1A 31Aug2007</P><P>1111&nbsp; 999585547&nbsp; D2A 30Sep2007</P><P>1111&nbsp; 999585540&nbsp; D1D 31Oct2007</P><P>1111&nbsp; 999585544&nbsp; AAA 30Nov2007</P><P>1111&nbsp; 999585547&nbsp; AAA 31Dec2007</P><P>1111&nbsp; 999585540&nbsp; D1D 31Jan2008</P><P>1111&nbsp; 999585544&nbsp; D2D 28Feb2008</P><P>1111&nbsp; 999585547&nbsp; D3D 31Mar2008</P><P>1111&nbsp; 999585540&nbsp; D4D 30Apr2008</P><P>1111&nbsp; 999585540&nbsp; D5D 31May2008</P><P>1111&nbsp; 999585540&nbsp; AAA 30Jun2008</P><P>1111&nbsp; 999585540&nbsp; AAA 31Jul2008</P><P>1111&nbsp; 999595540&nbsp; D1D 31Aug2008</P><P>1111&nbsp; 999587540&nbsp; LEP 30Sep2008</P><P>1111&nbsp; 999587540&nbsp; LEP 31Oct2008</P><P>1111&nbsp; 999585540&nbsp; LEP 30Nov2008</P><P>1112&nbsp; 999505548&nbsp; AAA 30Jun2007</P><P>1112&nbsp; 999505548&nbsp; AAA 31Jul2007</P><P>1112&nbsp; 999505544&nbsp; D1A 31Aug2007</P><P>1112&nbsp; 999505547&nbsp; D2A 30Sep2007</P><P>1112&nbsp; 999505540&nbsp; D1D 31Oct2007</P><P>1112&nbsp; 999505544&nbsp; D2D 30Nov2007</P><P>1112&nbsp; 999505547&nbsp; D3D 31Dec2007</P><P>1112&nbsp; 999505540&nbsp; D4D 31Jan2008</P><P>1112&nbsp; 999505544&nbsp; D5D 28Feb2008</P><P>1112&nbsp; 999505547&nbsp; D6D 31Mar2008</P><P>1112&nbsp; 999505540&nbsp; LEP 30Apr2008</P><P>1112&nbsp; 999505540&nbsp; LEP 31May2008</P><P>1112&nbsp; 999505540&nbsp; LEP 30Jun2008</P><P>1112&nbsp; 999505540&nbsp; LEP 31Jul2008</P><P>1112&nbsp; 999505540&nbsp; LEP 31Aug2008</P><P>1112&nbsp; 999505540&nbsp; LEP 31Oct2008</P><P>1112&nbsp; 999505540&nbsp; LEP 30Nov2008</P><P>1113&nbsp; 990005548&nbsp; D1D 30Jun2007</P><P>1113&nbsp; 995005548&nbsp; D2D 31Jul2007</P><P>1113&nbsp; 995050544&nbsp; D3D 31Aug2007</P><P>1113&nbsp; 999500547&nbsp; D4D 30Sep2007</P><P>1113&nbsp; 999500540&nbsp; AAA 31Oct2007</P><P>1113&nbsp; 999500544&nbsp; D1A 30Nov2007</P><P>1113&nbsp; 999580547&nbsp; D2A 31Dec2007</P><P>1113&nbsp; 999580540&nbsp; AAA 31Jan2008</P><P>1113&nbsp; 999580544&nbsp; D1A 28Feb2008</P><P>1113&nbsp; 999580547&nbsp; D2A 31Mar2008</P><P>1113&nbsp; 999580540&nbsp; AAA 30Apr2008</P><P>1113&nbsp; 999580540&nbsp; D1D 31May2008</P><P>1113&nbsp; 999585540&nbsp; D2D 30Jun2008</P><P>1113&nbsp; 999585540&nbsp; D3D 31Jul2008</P><P>1113&nbsp; 999585540&nbsp; LEP 31Aug2008</P><P>1113&nbsp; 999585540&nbsp; LEP 30Sep2008</P><P>1113&nbsp; 999585540&nbsp; LEP 31Oct2008</P><P>1113&nbsp; 999585540&nbsp; LEP 30Nov2008</P><P></P><P></P><P>;</P><P>run;</P><P>proc print;</P><P>run;</P><P></P><P>/*I have transosed this data set in the following format:*/</P><P>id_acc&nbsp; 30Jun2007 ---&nbsp; 30Nov2008</P><P></P><P></P><P>1111&nbsp;&nbsp;&nbsp; AAA--------------LEP</P><P>2222&nbsp;&nbsp;&nbsp; AAA--------------LEP</P><P>3333&nbsp;&nbsp;&nbsp; D1D--------------LEP</P><P></P><P></P><P>NOW WHAT I WANT THE OUTPUT IN THE FOLLOWING FORMAT:</P><P></P><P></P><P>how many instances the one id_acc remains in&nbsp; D1A to D1D,D2D TO D5D,D1D TO D1D (and so on) AND FINAL in LEP.</P><P></P><P></P><P>OUTPUT BELOW:</P><P></P><P></P><P>id_acc&nbsp; 30Jun2007 ---&nbsp; 30Nov2008&nbsp; D1_START&nbsp; D1_END&nbsp;&nbsp;&nbsp; D2_START&nbsp; D2_END&nbsp;&nbsp;&nbsp; D3_START&nbsp;&nbsp;&nbsp; D3_END ......dnstart ...dnend&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; lEP_START_END</P><P></P><P></P><P>1111&nbsp;&nbsp;&nbsp; AAA--------------LEP&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 31Aug2007 31Oct2007&nbsp; 31jan2008&nbsp; 31may2008&nbsp; 31Aug2008&nbsp; 31Aug2008&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30Sep2008</P><P>2222&nbsp;&nbsp;&nbsp; AAA--------------LEP&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 31Aug2007 31Mar2008&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30Apr2008</P><P>3333&nbsp;&nbsp;&nbsp; D1D--------------LEP&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30Jun2007 30Sep2007&nbsp; 30Nov2007&nbsp; 31Dec2007&nbsp; 28Feb2008&nbsp; 31Mar2008&nbsp;&nbsp;&nbsp; 31May2008&nbsp; 31Jul2008&nbsp;&nbsp;&nbsp; 31Aug2008</P></BODY></HTML> Wed, 06 May 2015 04:00:17 GMT https://communities.sas.com/t5/SAS-Data-Management/I-need-help-on-this/m-p/209872#M4881 pankak 2015-05-06T04:00:17Z Re: I need help on this https://communities.sas.com/t5/SAS-Data-Management/I-need-help-on-this/m-p/209873#M4882 <HTML><HEAD></HEAD><BODY><P>Don't understand what you try to achieve, try to give a clearer example were you don't focus on output design.</P><P>Not knowing the underlying requirement, transposing data the way you describe is seldom a road to success for calculating or reporting.</P></BODY></HTML> Thu, 07 May 2015 13:37:47 GMT https://communities.sas.com/t5/SAS-Data-Management/I-need-help-on-this/m-p/209873#M4882 LinusH 2015-05-07T13:37:47Z