Combining multiple rows of data into a single row for each unique ID

I am a rank beginner using SPSS and need some step-by-step help.  I
have a very large (over one million records) file which contains
detailed data some of which is in multiple rows for the same ID.  I
have a unique ID variable and I have a Line Number variable.  What I
need to be able to do is to bring all of the lines into a single line
for each ID and then match it to a header file which also contains the
unique ID number.  I have been trying for two days using the
casestovars and varstocases commands as well as trying to split the
file by layering the id numbers, etc. and can not get anything to
work.  I have taken only one class in SPSS and we did not really
address how to use syntax - everything is point and click.  I am a
previous SAS user and find this extremely frustrating and would
appreciate any help anyone can give me.

0
Jan
7/20/2007 5:26:26 PM
comp.soft-sys.stat.spss 5576 articles. 0 followers. Post Follow

5 Replies
173 Views

Similar Articles

[PageSpeed] 46
Jan wrote:
> I am a rank beginner using SPSS and need some step-by-step help.  I
> have a very large (over one million records) file which contains
> detailed data some of which is in multiple rows for the same ID.  I
> have a unique ID variable and I have a Line Number variable.  What I
> need to be able to do is to bring all of the lines into a single line
> for each ID and then match it to a header file which also contains the
> unique ID number.  I have been trying for two days using the
> casestovars and varstocases commands as well as trying to split the
> file by layering the id numbers, etc. and can not get anything to
> work.  I have taken only one class in SPSS and we did not really
> address how to use syntax - everything is point and click.  I am a
> previous SAS user and find this extremely frustrating and would
> appreciate any help anyone can give me.
> 


It would be helpful if you posted a small sample of the current data 
(e.g., 3 or 4 IDs with 4 or 5 variables) along with how you want it to 
look after restructuring.

-- 
Bruce Weaver
bweaver@lakeheadu.ca
www.angelfire.com/wv/bwhomedir
"When all else fails, RTFM."
0
Bruce
7/20/2007 6:45:33 PM
On Jul 20, 1:45 pm, Bruce Weaver <bwea...@lakeheadu.ca> wrote:
> Jan wrote:
> > I am a rank beginner using SPSS and need some step-by-step help.  I
> > have a very large (over one million records) file which contains
> > detailed data some of which is in multiple rows for the same ID.  I
> > have a unique ID variable and I have a Line Number variable.  What I
> > need to be able to do is to bring all of the lines into a single line
> > for each ID and then match it to a header file which also contains the
> > unique ID number.  I have been trying for two days using the
> > casestovars and varstocases commands as well as trying to split the
> > file by layering the id numbers, etc. and can not get anything to
> > work.  I have taken only one class in SPSS and we did not really
> > address how to use syntax - everything is point and click.  I am a
> > previous SAS user and find this extremely frustrating and would
> > appreciate any help anyone can give me.
>
> It would be helpful if you posted a small sample of the current data
> (e.g., 3 or 4 IDs with 4 or 5 variables) along with how you want it to
> look after restructuring.
>
> --
> Bruce Weaver
> bwea...@lakeheadu.cawww.angelfire.com/wv/bwhomedir
> "When all else fails, RTFM."



Thanks, Bruce.  Here is an example of what the data looks like except
there are multiple variables that I have not included to the right of
HPC_3.

Prov__ID            Line_No         HPC_1          HPC_2
HPC_3
5142                             1          6391
1785            1452
9865                             1          7784
5241             6999
9865                             2          6302
8574             1111

This is what I'd like it to end up looking like:

Prov_ID              N_Count        HPC_1          HPC_2
HPC_3        HPC_xxx        HPC_xxx        HPC_xxx
9865                             2            7784
5241            6999           6302           8574             1111

This would tell me how many lines make up the group and move the 3
values from the 2nd line to the same row as the values from the first
row.  Another factor is that some of the cases (by Prov_ID) have
various numbers of lines - some
have 2 lines and some have 9 lines so I'm not sure how to tell SPSS to
look for all that may be there and name a new
variable accordingly. I don't quite know where to start and I'm the
only SPSS person here.  Thanks so much for any guidance you can give
me.




0
Jan
7/20/2007 7:08:52 PM
There are 2 steps.

1. You can use AGGREGATE and N_Break command (Data...Aggregate). Use
Prov_ID as a Break Variable and click N_Break.  It will generate a new
variable counting the number of rows within Prov_ID.

***************************************************************************
This is what you got before.

> Prov__ID   Line_No   HPC_1   HPC_2   HPC_3
> 5142            1          6391      1785      1452
> 9865            1          7784      5241      6999
> 9865            2          6302      8574      1111

This is what you will get after.

> Prov__ID   Line_No   HPC_1   HPC_2   HPC_3   N_Break
> 5142            1          6391      1785      1452        1
> 9865            1          7784      5241      6999        2
> 9865            2          6302      8574      1111        2
**************************************************************************

2. Use Restructure command (from Data...Restructure).  Select
"Restructure Cases into Variables", use Prov_ID as an identifier.

The new data file will look like this, which is not exactly the same
as the one you want because of the order of the variable.  However,
you can tell SPSS arrange the variables in any order that you want.

> Prov_ID  N_Count   HPC_1.1   HPC_1.2   HPC2.1   HPC2.2   HPC_3.1   HPC3.2
> 9865      2              7784         6302         5241       8574        6999        1111
> 5142      1              6391                         1785                      1452


> Prov_ID  N_Count   HPC_1   HPC_2    HPC_3   HPC_xxx   HPC_xxx   HPC_xxx
> 9865      2              7784      5241       6999      6302          8574         1111
> 5142      1              6391      1785      1452

0
TASTAT
7/20/2007 8:11:23 PM
Jan wrote:
> On Jul 20, 1:45 pm, Bruce Weaver <bwea...@lakeheadu.ca> wrote:
>> Jan wrote:
>>> I am a rank beginner using SPSS and need some step-by-step help.  I
>>> have a very large (over one million records) file which contains
>>> detailed data some of which is in multiple rows for the same ID.  I
>>> have a unique ID variable and I have a Line Number variable.  What I
>>> need to be able to do is to bring all of the lines into a single line
>>> for each ID and then match it to a header file which also contains the
>>> unique ID number.  I have been trying for two days using the
>>> casestovars and varstocases commands as well as trying to split the
>>> file by layering the id numbers, etc. and can not get anything to
>>> work.  I have taken only one class in SPSS and we did not really
>>> address how to use syntax - everything is point and click.  I am a
>>> previous SAS user and find this extremely frustrating and would
>>> appreciate any help anyone can give me.
>> It would be helpful if you posted a small sample of the current data
>> (e.g., 3 or 4 IDs with 4 or 5 variables) along with how you want it to
>> look after restructuring.
>>
>> --
>> Bruce Weaver
>> bwea...@lakeheadu.cawww.angelfire.com/wv/bwhomedir
>> "When all else fails, RTFM."
> 
> 
> 
> Thanks, Bruce.  Here is an example of what the data looks like except
> there are multiple variables that I have not included to the right of
> HPC_3.
> 
> Prov__ID            Line_No         HPC_1          HPC_2
> HPC_3
> 5142                             1          6391
> 1785            1452
> 9865                             1          7784
> 5241             6999
> 9865                             2          6302
> 8574             1111
> 
> This is what I'd like it to end up looking like:
> 
> Prov_ID              N_Count        HPC_1          HPC_2
> HPC_3        HPC_xxx        HPC_xxx        HPC_xxx
> 9865                             2            7784
> 5241            6999           6302           8574             1111
> 
> This would tell me how many lines make up the group and move the 3
> values from the 2nd line to the same row as the values from the first
> row.  Another factor is that some of the cases (by Prov_ID) have
> various numbers of lines - some
> have 2 lines and some have 9 lines so I'm not sure how to tell SPSS to
> look for all that may be there and name a new
> variable accordingly. I don't quite know where to start and I'm the
> only SPSS person here.  Thanks so much for any guidance you can give
> me.
> 

I think the syntax shown below gives the result you ask for.  Copy it 
into a new syntax window (Open-->Syntax--New), then highlight it and run.

* ------------------------- .
data list list / Prov__ID  Line_No  HPC_1   HPC_2  HPC_3 (5f5.0).
begin data
5142      1        6391    1785   1452
9865      1        7784    5241   6999
9865      2        6302    8574   1111
end data.
list.

* Restructure the data from Cases to Vars .

SORT CASES BY Prov__ID Line_No .
CASESTOVARS
  /ID = Prov__ID
  /INDEX = Line_No
  /GROUPBY = INDEX
  /COUNT = N_count .

list.
* ------------------------- .

Here's the output:

Prov__ID N_count HPC_1.1 HPC_2.1 HPC_3.1 HPC_1.2 HPC_2.2 HPC_3.2

    5142       1    6391    1785    1452       .       .       .
    9865       2    7784    5241    6999    6302    8574    1111

Number of cases read:  2    Number of cases listed:  2


HTH.

-- 
Bruce Weaver
bweaver@lakeheadu.ca
www.angelfire.com/wv/bwhomedir
"When all else fails, RTFM."
0
Bruce
7/20/2007 8:26:49 PM
On Jul 20, 3:26 pm, Bruce Weaver <bwea...@lakeheadu.ca> wrote:
> Jan wrote:
> > On Jul 20, 1:45 pm, Bruce Weaver <bwea...@lakeheadu.ca> wrote:
> >> Jan wrote:
> >>> I am a rank beginner using SPSS and need some step-by-step help.  I
> >>> have a very large (over one million records) file which contains
> >>> detailed data some of which is in multiple rows for the same ID.  I
> >>> have a unique ID variable and I have a Line Number variable.  What I
> >>> need to be able to do is to bring all of the lines into a single line
> >>> for each ID and then match it to a header file which also contains the
> >>> unique ID number.  I have been trying for two days using the
> >>> casestovars and varstocases commands as well as trying to split the
> >>> file by layering the id numbers, etc. and can not get anything to
> >>> work.  I have taken only one class in SPSS and we did not really
> >>> address how to use syntax - everything is point and click.  I am a
> >>> previous SAS user and find this extremely frustrating and would
> >>> appreciate any help anyone can give me.
> >> It would be helpful if you posted a small sample of the current data
> >> (e.g., 3 or 4 IDs with 4 or 5 variables) along with how you want it to
> >> look after restructuring.
>
> >> --
> >> Bruce Weaver
> >> bwea...@lakeheadu.cawww.angelfire.com/wv/bwhomedir
> >> "When all else fails, RTFM."
>
> > Thanks, Bruce.  Here is an example of what the data looks like except
> > there are multiple variables that I have not included to the right of
> > HPC_3.
>
> > Prov__ID            Line_No         HPC_1          HPC_2
> > HPC_3
> > 5142                             1          6391
> > 1785            1452
> > 9865                             1          7784
> > 5241             6999
> > 9865                             2          6302
> > 8574             1111
>
> > This is what I'd like it to end up looking like:
>
> > Prov_ID              N_Count        HPC_1          HPC_2
> > HPC_3        HPC_xxx        HPC_xxx        HPC_xxx
> > 9865                             2            7784
> > 5241            6999           6302           8574             1111
>
> > This would tell me how many lines make up the group and move the 3
> > values from the 2nd line to the same row as the values from the first
> > row.  Another factor is that some of the cases (by Prov_ID) have
> > various numbers of lines - some
> > have 2 lines and some have 9 lines so I'm not sure how to tell SPSS to
> > look for all that may be there and name a new
> > variable accordingly. I don't quite know where to start and I'm the
> > only SPSS person here.  Thanks so much for any guidance you can give
> > me.
>
> I think the syntax shown below gives the result you ask for.  Copy it
> into a new syntax window (Open-->Syntax--New), then highlight it and run.
>
> * ------------------------- .
> data list list / Prov__ID  Line_No  HPC_1   HPC_2  HPC_3 (5f5.0).
> begin data
> 5142      1        6391    1785   1452
> 9865      1        7784    5241   6999
> 9865      2        6302    8574   1111
> end data.
> list.
>
> * Restructure the data from Cases to Vars .
>
> SORT CASES BY Prov__ID Line_No .
> CASESTOVARS
>   /ID = Prov__ID
>   /INDEX = Line_No
>   /GROUPBY = INDEX
>   /COUNT = N_count .
>
> list.
> * ------------------------- .
>
> Here's the output:
>
> Prov__ID N_count HPC_1.1 HPC_2.1 HPC_3.1 HPC_1.2 HPC_2.2 HPC_3.2
>
>     5142       1    6391    1785    1452       .       .       .
>     9865       2    7784    5241    6999    6302    8574    1111
>
> Number of cases read:  2    Number of cases listed:  2
>
> HTH.
>
> --
> Bruce Weaver
> bwea...@lakeheadu.cawww.angelfire.com/wv/bwhomedir
> "When all else fails, RTFM."- Hide quoted text -
>
> - Show quoted text -

THANK YOU SO MUCH!!!!!

0
Jan
7/20/2007 8:35:43 PM
Reply:
Similar Artilces:

Drop-Down/Text Box Combination?
I am a javascript newbie and did not see anything quite like this in sections 1-5 of the FAQ or on a Google search. Is there a generic javascript example of a compound drop-down/text box, i.e., if the user selects an item from the drop-down, the selected item populates the text box, but the user can also type their own ad-hoc value into the text box if desired? I would like to include such a control in a php/mysql web form I am developing. bonehead a ecrit : > I am a javascript newbie and did not see anything quite like this in > sections 1-5 of the FAQ or on a Google search. &...

Combo Box Row Source
I am using the following SQL as a RowSource for a combo box on a form. "SELECT LAN, TenantName as [Tenant Name], ShopNum as [Shop] FROM qTenantSelect " The field 'ShopNum' is a text field and has a caption property set to 'Shop Number' in the table design. In the combo box though, I want to use 'Shop' as the heading (to save width) as shown in the SQL above. But the combo shows 'Shop Number' as a heading in form view. I thought that the 'As Shop' would have done what I wanted, but looks like I'm wrong .... yet again. Can anyone help? ...

Statement Event Monitor Data
I have run an statement event monitor and am digging through the data it produced. Some of the rows in the stmt table have me perplexed. These records have a stmt_text that is blank with a stmt_type of 1. I understand that this means it is a static SQL statement and I can use the creator, package_name, package_version_id and section_number to look up the text in the syscat.statements table. In this case though, these records have no creator or package information and the section_number is 0. What is this telling me and how do I find out what the statement actually is. Since I ha...

Re: Reading datetime raw data (YYYYMMDDhhmmss) #2
Raoul Try the ND8601DT informat. Data dt; input date ND8601DT. ; format date datetime20. ; cards; 20080401133612 proc print; run; Nat Wooding Environmental Specialist III Dominion, Environmental Biology 4111 Castlewood Rd Richmond, VA 23234 Phone:804-271-5313, Fax: 804-271-2977 Raoul <raoul.van.balen@ GMAIL.COM> To Sent by: "SAS(r) SAS-L@LISTSERV.UGA.EDU Discussion" cc <SAS-L@LIST...

long number multiplication
hi i have been wondering, how does python store its very long integers and perform aritmetic on it. i needed to implement this myself and was thinking of storing the digits of an integer in a list. however this would be very slow for operations like division etc. so if anyone can point me to some links or some method on how to do this i would appreciate it aprameya rao I.V. Aprameya Rao wrote: > hi > > i have been wondering, how does python store its very long integers and > perform aritmetic on it. > > i needed to implement this myself and was thinking of storin...

NonlinearModelFit and Complex Data
Hi, I am trying to fit complex data to a complex function. Here's a snippet: data = Import["http://apps.getcloudigniter.com/data/data.csv"]; fitData = Table[{data[[i, 1]], data[[i, 2]] + I*data[[i, 3]]}, {i, 1, Dimensions[data][[1]]}]; fitEqn[x_] := (aR + I aI) + ( bR + I bI)*(Abs[x - 79800.3]/ 1585.02) - ( par1 (x - par1))/((cR + I cI)*((x - par1)^2 - I par2/2 (x - par1) - 435093.75^2)); fit = NonlinearModelFit[fitData, fitEqn[x] , {aR, aI, bR, bI, cR, cI, par1, par2}, x, WorkingPrecision -> 100, MaxIterations -> 10000...

Haskell (Multiple Constructors)
Again the section on Multiple constructors in, "Haskell Yet another tutorial" and I forward the exercise given at the end of the section to have somewhat a needlessly awkward solution. The exersize said: Exercise 4.6 Write a datatype Tuple which can hold one, two, three or four elements, depending on the constructor (that is, there should be four constructors, one for each number of arguments). Also provide functions tuple1 through tuple4 which take a tuple and return Just the value in that position, or Nothing if the number is invalid (i.e., you ask for the tuple4 on a tuple hold...

DHCPd with multiple ifs
On an OBSD box with multiple ifs, I would like to have dhcpd listen on only one (the ste2) if (one with only a wifi accesspoint connected to it). On the lan (ste3), there is another box which are running DHCP for the local LAN. Upun start of dhcpd, I get the following: Oct 28 09:22:21 optical dhcpd: No subnet declaration for ste3 (172.18.1.1). Oct 28 09:22:21 optical dhcpd: Please write a subnet declaration in your dhcpd.conf file for the Oct 28 09:22:21 optical dhcpd: network segment to which interface ste3 is attached. Oct 28 09:22:21 optical dhcpd: exiting. my dhc...

Initilizing Multiple Cells in Array
I want to initialize all the values in a cell array with the same string. I want to be able to do this without a loop. The following code is close to what I want but does not work: [ temp{ 1 : nCols } ] = 'double'; Any ideas? -- James Van Spengen www.satlantic.com On Wed, 12 May 2004 17:02:30 +0000, JVSFugitive wrote: > I want to initialize all the values in a cell array with the same > string. I want to be able to do this without a loop. The following code > is close to what I want but does not work: > > [ temp{ 1 : nCols } ] = 'double'; > > Any...

combined ranges...
Anybody know if there's an easy way to accomplish the equivalent of this: [1..20, 30..46].each{|n| # n = 1,2,3,4,5..30, 31, 32 } ? Thanks! -rp -- Posted via http://www.ruby-forum.com/. Will this work: [1..20,30..46].each{|r| r.each {|n| p n}} David -- Posted via http://www.ruby-forum.com/. > [1..20, 30..46].each{|n| > =C2=A0# n =3D 1,2,3,4,5..30, 31, 32 > } Only thing that comes to mind for me is r1 =3D 1..20 r2 =3D 30..46 (r1.to_a + r2.to_a).each{|n| puts n} Probably not the best solution, but works... -Jonathan Nielsen Adding p...

How to sort a vector and then append data
Hi, I'm not very experienced using fortran 90, and probably this will looks a stupid question for you. I need to sort a vector and then append the missing data that is: Suppose that we have the following vector: 3 1 2 5 15 I need to sort it, that is i need to get: 1 2 3 5 15 and then append the missing numbers in order to get the following vector: 1 2 3 -4- 5 -6- -7- -8- -9- -10- -11- -12- -13- -14- 15 Hoper you can help me, Joel In article <bc7de858.0407291749.a785b3c@posting.google.com>, joel GUERRERO <joegi.geo@yahoo.com> writes >Hi, >I'm not very exper...

combining dataset
I have five datasets,each dataset has common variable has employeeID.I want to select employeeID which are present in minimum three datasets. Does Anyone has any idea? Nia Nia, From the top of my head (untested). Of course you'll neeed to sort / index. data something; merge a1(in=in1) a2(in=in2) a3(in=in3) a4(in=in4) a5(in=in5); by employee_id; if sum(of in1-in5); . . . run; Good luck, Jan. "nia" <sanvi_shinde@yahoo.com> schreef in bericht news:1130104943.322929.136030@z14g2000cwz.googlegroups.com... >I have five datasets,each dataset ha...

deleting selected rows from mat file
suppose i have a 200x50 mat file. i want to delete every tenth row or e some selected rows from that. if i am doing using simple matlab operations it is very time consuming. in fact i have to prepare fresh about 10 files like that by selectively deleting rows . is there any short cut method. if anybody can help . please it is urgent "shahnaz fatima" <shahnaz1981fat@gmail.com> wrote in message <i4egr6$14t$1@fred.mathworks.com>... > suppose i have a 200x50 mat file. > > i want to delete every tenth row or e some selected rows from that. > ...

Multiple keyboards, different mappings
How do I set up X to let me have a Qwerty layout for the built-in keyboard on my laptop computer, but a Dvorak layout for the PS/2 external keyboard, both usable at the same time? -- Mark ...

Combining hex values in a string
Hey, This isn't exactly a Scheme question, but I am using Scheme so it seemed like the logical place to ask for help. So I have a string containing 4 hex numbers 98, ff, 00, and 01. What I need to do is to combine them to produce the value 16842648, but I can't seem to figure it out. I know how to read and construct hex numbers in general that's not a problem, but not when the numbers have been grouped like this. Have to say I'm a little lost. The string I have looks like this: "\x98\xff\x00\x01"; I can easily get the numbers from this into a list so then I have th...

Create unique value
Hi to all, I have a somewhat interesting problem that needs solving. I have built a system to keep track items that are booked in for repairs. These items do not have serial number. Each item is tagged and the TAGNO is made up of the following. YEAR + JOBNO. This is all fine. The problem is that the client can bring in two identicle articles on the same job and when this happens I need to append a "A" or "B" to the TAGNO. eg 2004/1029A. The A or B will only be added if item is duplicated. Any ideas of how to add this if the scenario occurs. Tnaks Elmo ...

extra rows in USER_DEPENDENCIES
Anybody ever run across apparently extra rows in USER_DEPENDENCIES? Specifically, I'm seeing a table in the REFERENCED_NAME column for a stand-alone procedure that does not directly reference the table (or use it in a %TYPE or %ROWTYPE reference) Is oracle recording indirect references? There don't seem to be any views dependent on the table that are referenced in the proc, but it does reference package variables that are defined with a %ROWTYPE -- could that be the dependency oracle is recording? Version: Oracle9i Enterprise Edition Release 9.0.1.4.0 - 64bit Production; HP-UX...

problem in using _inpw to read data
I'm writing a PCI driver for a real time windows target. And I success finding the PCI card's configulation infomation by using _inpw,_inpd, _outpw, _outpd. But when I wang to read the content of the base address, it returns a different value with the value I read by WinDriver. Is there something wrong with _inpd in reading memory address? thanks ...

Bootstrap with clustered data
I want to do some bootstrapping with data which is clustered (multiple observations per person). I plan to modify the %boot macro. Has anyone already done this? Any tips? -----Original Message----- >From: BruceBrad <BruceBrad@INAME.COM> >Sent: Jan 15, 2008 2:05 AM >To: SAS-L@LISTSERV.UGA.EDU >Subject: Bootstrap with clustered data > >I want to do some bootstrapping with data which is clustered (multiple >observations per person). I plan to modify the %boot macro. Has anyone >already done this? Any tips? Instead of this, see David Cassell's paper "Don...

Combining/Collapsing 3 Values into 1 And Make New Variable
I believe you use the Transform-Compute function to accomplish this, but can't figure the formula to make it happen. Here are the original attributes of the variable: It involves when visited a particular website: 1= Yesterday 2= In past 7 days but not yesterday 3= 8 to 30 days ago 4= More than 30 days ago 5= Have never accessed 6= Don't know/no answer I want to collapse values 1,2& 3 so I can cross tab & isolate those who've accessed in the past 30 days. Would really appreciate any help. Thanks very much! to generate this syntax recode myoldvar ...

Multiple wine processes
This is a multi-part message in MIME format. --------------030909060006040205060906 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Ive been running a game server quite happily under wine for some time now. Im currently running RedHat 8 Kernel 2.4.18 Im currently using the standard wine dated 20030709. Yes I know its a little on the old side. I have 1.5Gb of memory. I soon will be getting access to a T1, so I would like to run multiple game servers with the extra bandwidth. Unfortunately, I have found that the most I can get runn...

Turbo C calling/data conventions?
I want to create a library for Turbo C and need to know how to interface C to assembler. I have TC++ 1.01 and NASM. I need instructions on how to access asm routines and data from C/C++. I may want to do the same with Open Watcom C/C++ for DOS. Hi, Harry Potter wrote: > I want to create a library for Turbo C and need to know how to > interface C to assembler. I have TC++ 1.01 and NASM. I need > instructions on how to access asm routines and data from C/C++. I may > want to do the same with Open Watcom C/C++ for DOS. Hope this helps, it's all I could think o...

Re: Fill Up the data.........?
Kirton, =20 You could do a two step process, =20 First, retain or as I would recommend to a full scale data lag, and fill your numbers the way you want and then turn around and do a full scale rolling lead. =20 =20 Full scale lag : data two; set one; by x; =20 if first.x ne 1 then do; pnt =3D _N_ - 1; =20 set one (rename =3D (x =3D _x=20 y =3D _y))=20 point =3D pnt; end; else do; _x =3D " "; _y =3D .; end; =20 run; =20 =20 Rolling lead: Something in the neighborhood ...

Rounding decimals off in multiple columns
Hello: I'm trying to round-off data in columns to three decimals and was hoping for some useful assistance! In the array, I need to round 5 columns (columns #4-8) to three decimals places. There are 1,099 rows in these columns if that's helpful/useful whatsoever. Thanks in advace! "Ryan Neilson" <rneilson3@cogeco.ca> wrote in message <gjarn1$87n$1@fred.mathworks.com>... > Hello: > > I'm trying to round-off data in columns to three decimals and was hoping for some useful assistance! > > In the array, I need to round 5 columns (columns #4-8)...

BIOS settings when using single SATA drive
Hi I've just built a machine using a single SATA drive and a CD/DVD ROM drive, on a GIgabyte GA-K8NS Pro mobo with an Athlon 64 3000 chip. Now, I have got it all working, but about one time out of three it freezes around the 'Detecting IDE drives' shortly after booting up. Could anyone suggest particular BIOS settings I need to change regarding IDE, SATA etc - presumably I can ignore RAID (I've disabled it). Should the CD drive be in IDE channel 1 or 2 or doesn't it matter? For those who know the mobo, I've connected the hard drive to the SATAO_SB connec...