COMPGROUPS.NET | Search | Post Question | Groups | Stream | About | Register

Do Loop Shift Column

  • Follow


Hello all!  Have a quick programming question that I am hopeful someone
could help.  I have a messy data file in the following format:

Col1         Col2         Col3         Col4         Col5
James Spann 50 JumpSt oa,Calif 29856
DEF Company CO:Loiuse May PO Box 1450 la,nv 85696
Daniel Harris Susan Harris 14 Elm Street oak, GA 30010
Mary Hill  CEO         ABC Company 14Wood Road ri,VA 29863

What I need is to have Col1 - Col3 to contain all names wheter it's a
comapany name, person name, or title.  Col4 - Col5 contains only
addresses.  I was thinking of using the 'anydigit' function to identify
addresses but i can't figure out how to program it in a loop.

Thanks in advance,
Samuel
0
Reply arlando20002000 (35) 11/20/2009 2:48:59 PM 

On Nov 20, 2:48=A0pm, arlando20002...@YAHOO.COM (Samuel Jackson) wrote:
> Hello all! =A0Have a quick programming question that I am hopeful someone
> could help. =A0I have a messy data file in the following format:
>
> Col1 =A0 =A0 =A0 =A0 Col2 =A0 =A0 =A0 =A0 Col3 =A0 =A0 =A0 =A0 Col4 =A0 =
=A0 =A0 =A0 Col5
> James Spann 50 JumpSt oa,Calif 29856
> DEF Company CO:Loiuse May PO Box 1450 la,nv 85696
> Daniel Harris Susan Harris 14 Elm Street oak, GA 30010
> Mary Hill =A0CEO =A0 =A0 =A0 =A0 ABC Company 14Wood Road ri,VA 29863
>
> What I need is to have Col1 - Col3 to contain all names wheter it's a
> comapany name, person name, or title. =A0Col4 - Col5 contains only
> addresses. =A0I was thinking of using the 'anydigit' function to identify
> addresses but i can't figure out how to program it in a loop.
>
> Thanks in advance,
> Samuel

I am not sure if you want to use SAS for this. In SAS you order
variables by using 'retain'.

Dirk
0
Reply Dirk 11/20/2009 4:40:54 PM

comp.soft-sys.sas 131509 articles. 17 followers.

1 Replies
296 Views

(page loaded in 0.101 seconds)

Similiar Articles:

Do Loop Shift Column - comp.soft-sys.sas
Hello all! Have a quick programming question that I am hopeful someone could help. I have a messy data file in the following format: Col1 ...

simple do loop question - comp.soft-sys.sas
Do Loop Shift Column - comp.soft-sys.sas simple do loop question - comp.soft-sys.sas Do Loop Shift Column - comp.soft-sys.sas Have a quick programming question that I am ...

creating a button on a figure to stop the program. - comp.soft-sys ...
SPSS MACRO Syntax - comp.soft-sys.stat.spss creating a counting variable - comp.soft-sys.sas Do Loop Shift Column - comp.soft-sys.sas creating a button on a figure to stop ...

Select important data from an array - comp.soft-sys.matlab ...
Do Loop Shift Column - comp.soft-sys.sas select specified columns in ch. array - comp.lang.fortran ... Do Loop Shift Column - comp.soft-sys.sas extracting elements from a ...

Concat array / loop - comp.soft-sys.sas
... have a large cell array of times ... If C is large, the concatenation is faster with the ... select specified columns in ch. array - comp.lang.fortran ... Do Loop Shift ...

A sort order column? - comp.databases.mysql
> > > Ideally, I'd like to have a column type where I could do ... So if someone wants to shift row A ... to use sortrows function in a loop startin with first column till ...

Use of MATLAB fftshift - comp.dsp
... matlab's > >interval with n( 1 ) =3D=3D 0 is a circular shift by n0. > >Thus we need to do ... 1) Let's say that a user had a function that needs to loop over the columns of ...

Statistical calculations on generated variables in simulation ...
Generally you need to loop your program using macro code ... start f(x); f =3D sumf; sumf=3D0; do i =3D 1 to 3 ... How to get envelope from AM signal without phase shift ...

change value and concatenate - comp.lang.awk
... gsub(/^"|"$/,"");$1=$1}1' but you'd need to do ... NF=NF-3;print }' file The purpose of the for loop is to shift ... But when I use concatenate (date,time) date column ...

print the tick ' - comp.lang.awk
How to shift the values of x axis from position of x axis to other ... print the tick ' - comp.lang.awk How to shift the values of x axis from position of x axis to other ...

Do Loop Shift Column - comp.soft-sys.sas | Computer Group
Hello all! Have a quick programming question that I am hopeful someone could help. I have a messy data file in the following format: Col1 ...

Do Loop Shift Column - sas - Mofeel Groups
sas, Do Loop Shift Column . comp.soft-sys.sas - The SAS statistics package.

7/29/2012 11:39:41 AM


Reply:
Privacy Policy | All Times Are GMT(UTC) | powered by