f



Re: Need help with SAS Data step

Mehdi,

There is no way for SAS to know when the variables begin and end if the
data is both free-form and lacks a delimiter. Prior to reading the file
into SAS, is it possible to save the file in some type of delimited
format, e.g. comma or tab, or fixed form? What is the original source /
file type of your data?

If you have no way of changing your data prior to reading it into SAS,
it seems you would have to read the entire observation into a single
variable and then use logic to parse the data.

Regards,
Scott


-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
Mehdi Satter
Sent: Saturday, June 21, 2008 5:23 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Need help with SAS Data step

Hello,

I'm a new SAS learner. I become interested in SAS when I took a
Biostatistics class. Then I took a SAS/Stat class and learned how to SAS
for statistical data analyses. Basically I'm a spinal cord injured
graduate student in computer science. After taking that SAS class I
started learning SAS and planning to develop my career in SAS
programming. Because other computer programming languages involve
writing many many lines of codes. For my physical limitation I find SAS
needs only few lines of codes and makes my life little easier.

Anyway, I'm always having trouble reading data at SAS data step using
'INPUT' statement. I fail to read character variables with embedded
spaces.
Here is a part of a data set I was using to practice SAS;

*data* country;

          input Name : $19. Capital $ Population Area Continent $
UNDate;

          datalines;

          Afghanistan Kabul 17070323 251825 Asia 1946

          Albania Tirane 3407400 11100 Europe 1955

          Algeria Algiers 28171132 919595 Africa 1962

          Andorra Andorra la Vell 64634 200 Europe 1993

          Angola Luanda 9901050 481300 Africa 1976

          Antigua and Barbuda St. John's 65644 171 Central America 1981

          Argentina Buenos Aires 34248705 1073518 South America 1945

          Armenia Yerevan 3556864 11500 Asia 1992

          Australia Canberra 18255944 2966200 Australia 1945

          Austria Vienna 8033746 32400 Europe 1955

          Azerbaijan Baku 7760064 33400 Asia 1992

          Bahamas Nassau 275703 5400 Central America 1973

          Bahrain Manama 591800 300 Asia 1971

          Bangladesh Dhaka 1.2639E8 57300 Asia 1974

          Barbados Bridgetown 258534 200 Central America 1966

          ;;;;

Would anyone be kind enough to teach me how to write input statement for
this kind of data set with embedded spaces and quotes. I would
appreciate that.

Thanks.

Mehdi
0
SBucher1 (160)
6/21/2008 9:51:17 PM
comp.soft-sys.sas 142828 articles. 3 followers. Post Follow

0 Replies
456 Views

Similar Articles

[PageSpeed] 57

Reply:

Similar Artilces:

Re: Need help with SAS Data step #4
Thank you all for being so nice and helpful. Have a good one. -Mehdi On Mon, Jun 23, 2008 at 9:29 AM, Gerhard Hellriegel < gerhard.hellriegel@t-online.de> wrote: > in SAS you can get all which has a structure, following certain rules. A > simple rule is: all data-fields are seperated by a delimiter. > That seems to be not the case at your data. Ok, also that data must have a > certain structure, if you are able to read it and understand it. So the > easiest way might be to ask, "how do I understand that data?" "Which rules > do I follow?". > Ok, one of that rules might be: I know that the country is the first word. > That after the country up to the first number is the capital. That are > rules you could implement in SAS. > If it is more complicated, e.g. there are also countries like 'Sri Lanca' > you might have a list with all that countries (like that in your head - > something in your brain must tell you, that the country is not Sri and the > capital is not Lanca) to get them. > Gerhard > > > > > On Mon, 23 Jun 2008 06:05:20 -0700, Lou <lpogoda@HOTMAIL.COM> wrote: > > >On Jun 21, 5:23 pm, mehdisat...@GMAIL.COM (Mehdi Satter) wrote: > >> Hello, > >> > >> I'm a new SAS learner. I become interested in SAS when I took a > >> Biostatistics class. Then I took a SAS/Stat class and learned how to > SAS for > >> statistical...

Re: Need help with SAS Data step #2
On Sat, 21 Jun 2008 16:23:07 -0500, Mehdi Satter <mehdisatter@GMAIL.COM> wrote: >Hello, > >I'm a new SAS learner. I become interested in SAS when I took a >Biostatistics class. Then I took a SAS/Stat class and learned how to SAS for >statistical data analyses. Basically I'm a spinal cord injured graduate >student in computer science. After taking that SAS class I started learning >SAS and planning to develop my career in SAS programming. Because other >computer programming languages involve writing many many lines of codes. For >my physical limitation I find SAS needs only few lines of codes and makes my >life little easier. > >Anyway, I'm always having trouble reading data at SAS data step using >'INPUT' statement. I fail to read character variables with embedded spaces. >Here is a part of a data set I was using to practice SAS; > >*data* country; > > input Name : $19. Capital $ Population Area Continent $ UNDate; > > datalines; > > Afghanistan Kabul 17070323 251825 Asia 1946 > > Albania Tirane 3407400 11100 Europe 1955 > > Algeria Algiers 28171132 919595 Africa 1962 > > Andorra Andorra la Vell 64634 200 Europe 1993 > > Angola Luanda 9901050 481300 Africa 1976 > > Antigua and Barbuda St. John's 65644 171 Central America 1981 > > Argentina Buenos Aires 34248705 1073...

Re: Need help with SAS Data step #3
in SAS you can get all which has a structure, following certain rules. A simple rule is: all data-fields are seperated by a delimiter. That seems to be not the case at your data. Ok, also that data must have a certain structure, if you are able to read it and understand it. So the easiest way might be to ask, "how do I understand that data?" "Which rules do I follow?". Ok, one of that rules might be: I know that the country is the first word. That after the country up to the first number is the capital. That are rules you could implement in SAS. If it is more complicated, e.g. there are also countries like 'Sri Lanca' you might have a list with all that countries (like that in your head - something in your brain must tell you, that the country is not Sri and the capital is not Lanca) to get them. Gerhard On Mon, 23 Jun 2008 06:05:20 -0700, Lou <lpogoda@HOTMAIL.COM> wrote: >On Jun 21, 5:23 pm, mehdisat...@GMAIL.COM (Mehdi Satter) wrote: >> Hello, >> >> I'm a new SAS learner. I become interested in SAS when I took a >> Biostatistics class. Then I took a SAS/Stat class and learned how to SAS for >> statistical data analyses. Basically I'm a spinal cord injured graduate >> student in computer science. After taking that SAS class I started learning >> SAS and planning to develop my career in SAS programming. Because other >> computer programming languages involve writing many many lin...

Re: Need help with SAS Data step #5
Summary: Make guesses and add information to check work. #iw-value=1 Mehdi, As a computer science student you must be aware that any field has to be defined in some way if one is to have an automated way to read the fields. Let's look at your worst case. > Antigua and Barbuda St. John's 65644 171 Central America 1981 Where does country end and capital begin? An English speaking human might say, "Well, the word 'and' cannot begin a capital name." You could of course build this feature into your program, but then there are probably some other examples with other words. As a computer science student you are probably aware of regular expressions, so you might take a look at the PRX functions and try to parse each line into separate fields. This probably would have the biggest payoff in your career, but since you are a beginning SAS student I have chosen to show you some of the more traditional SAS tricks. First we observe that it is easy to recognize the three number fields. The rest follows by assuming that a country name is usually one word. You will have to look up features in on line documentation or the help facility. Hopefully the comments are enough to follow the code below. You might copy it and then try executing it. data country ( drop = rest x ) check ; /* assumptions name - first word captal - everthing up to numbers population - first number area - second number ...

Need help with SAS Data step
Hello, I'm a new SAS learner. I become interested in SAS when I took a Biostatistics class. Then I took a SAS/Stat class and learned how to SAS for statistical data analyses. Basically I'm a spinal cord injured graduate student in computer science. After taking that SAS class I started learning SAS and planning to develop my career in SAS programming. Because other computer programming languages involve writing many many lines of codes. For my physical limitation I find SAS needs only few lines of codes and makes my life little easier. Anyway, I'm always having trouble reading data at SAS data step using 'INPUT' statement. I fail to read character variables with embedded spaces. Here is a part of a data set I was using to practice SAS; *data* country; input Name : $19. Capital $ Population Area Continent $ UNDate; datalines; Afghanistan Kabul 17070323 251825 Asia 1946 Albania Tirane 3407400 11100 Europe 1955 Algeria Algiers 28171132 919595 Africa 1962 Andorra Andorra la Vell 64634 200 Europe 1993 Angola Luanda 9901050 481300 Africa 1976 Antigua and Barbuda St. John's 65644 171 Central America 1981 Argentina Buenos Aires 34248705 1073518 South America 1945 Armenia Yerevan 3556864 11500 Asia 1992 Australia Canberra 18255944 2966200 Australia 1945 Austria Vienna 8033746 32400 Europe 1955 Azerbaijan Baku 7760064 ...

Re: Old SAS Guy needs help with some of these new fangled SAS
Hi John, I believe PROC IMPORT writes dedicated data step code to the log that you can reuse. Regards - Jim. -- Jim Groeneveld, Netherlands Statistician, SAS consultant home.hccnet.nl/jim.groeneveld On Tue, 2 Dec 2008 00:26:53 -0600, John F. Regus <jfregus@IX.NETCOM.COM> wrote: >Greetings all who have helped me in the past. > >Here is something that has been bothering me unending and is causing me sleepless afternoons. > >I know that I can import just about any file imaginable into SAS using the import function using SAS Windows 9.1.3. >However, when trying to get comma seperated values moved all at once into the new SAS file, >I can (or only know how to get) the data for one variable moved at a time. I would like to do a mass >move of all the data from the input file into the new SAS file. Is there a way to do this? Because once > I have imported the file into a new SAS file, established variable names, established formats, informats, >variable lengths, etc. I would like to be able to save the settings for the next like file that I want to import into what I have >already slaved over doing, defining, etc., without repeating the process. > >Is there a way to do this? > >Waiting with bad breath on the sidelines. > >The Old SYS/390 guy >"SAS was originally invented for computer performance and capacity planning for the SYS/3x0 IBM machines... >they sure have taken it into new features that are amazing&...

Need SAS Data Integration Consultant with SAS Data Integration Studio, Base SAS, SAS macros and SQL experience for a 9 months project at Charlotte NC, please send resumes to kamesh@kmmtechnologies.com
Need SAS Data Integration Consultant with SAS Data Integration Studio, Base SAS, SAS macros and SQL experience for a 9 months project at Charlotte NC, please send resumes to kamesh@kmmtechnologies.com ...

Re: Old SAS Guy needs help with some of these new fangled SAS #2
It's been a while since I used the Import Wizard but as I recall, there is a window which asks for a file name where SAS can store the input statments for your future use. Nat Wooding Environmental Specialist III Dominion, Environmental Biology 4111 Castlewood Rd Richmond, VA 23234 Phone:804-271-5313, Fax: 804-271-2977 Jim Groeneveld <jim.1stat@YAHOO. COM> To Sent by: "SAS(r) SAS-L@LISTSERV.UGA.EDU Discussion" cc <SAS-L@LISTSERV.U GA.EDU> Subject Re: Old SAS Guy needs help with some of these new fangled SAS 12/02/2008 04:49 9.1.3 gizmos for Windows AM Please respond to Jim Groeneveld <jim.1stat@YAHOO. COM> Hi John, I believe PROC IMPORT writes dedicated data step code to the log that you can reuse. Regards - Jim. -- Jim Groeneveld, Netherlands Statistician, SAS consultant home.hccnet.nl/jim.groeneveld On Tue, 2 Dec 2008 00:26:53 -0600, John F. Regus <jfregus@IX.NETCOM.COM> wrote: >Greetings all who have helped me in the past. > >Here is something that has been bothering me unending and is causing me sl...

Re: What r the data types in SAS? in Base SAS , and SAS SQL
> From: Amar Mundankar > Sent: Tuesday, July 21, 2009 8:10 AM > To: sas-l@uga.edu > Subject: What r the data types in SAS? in Base SAS , and SAS SQL > > Hi all, > What are the different data types in Base SAS and SAS SQL?? character, lengths from 1 to 32,000+ numeric: lengths from 2 to 8 dates are a subtype of numeric and are identified by their date, datetime, or time formats the new proc TSPL (Table Server Processing Language) supports ANSI data types: bigint, tinyint, etc. http://support.sas.com/documentation/cdl/en/tsag/30878/HTML/default/a003 065339.htm http://s...

Re: Ranges in sas? (was RE: Re: data step vs Proc sql) #2
Ooooh--interesting--thanks! I'll play with that... ________________________________ From: SAS(r) Discussion on behalf of Rickards, Clinton (GE Consumer Finance) Sent: Thu 4/20/2006 2:41 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: Ranges in sas? (was RE: Re: data step vs Proc sql) Exactly. the only trick is that the range values must be integers. clint -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU]On Behalf Of Pardee, Roy Sent: Thursday, April 20, 2006 3:57 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Ranges in sas? (was RE: Re: data step vs Proc sql) ...

Re: How to filter sas data sets into separate sas data sets #4
Something like this is the old way. You could use a proc sql if you have a new enough version. Increase your buffersize and if you have enough memory you may get it into a hash routine. DATA WORK.NEW; MERGE small (IN=A OBS=500) big ; BY ID_FIELD; IF A=1; RUN; QUIT; RICH -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@listserv.vt.edu] On Behalf Of Lizette Koehler Sent: Monday, April 02, 2007 10:53 AM To: SAS-L@LISTSERV.VT.EDU Subject: How to filter sas data sets into separate sas data sets Listers, This is my failing point in coding SAS. T...

Re: How to filter sas data sets into separate sas data s ets
I think that both Ron's (as he mentioned) and Richard solutions require that VAR1 is in both datasets. But from the original post, it seemed to me that VAR1 is only in data set 1, and it must be matched to 1 of 3 variables in data set 2 (NODE1, NODE2 or NODE3) to be output to the NEWLIST data set. For this reason, I think a format is one possible approach. Maybe the original poster can clarify this point. Thanks. Jack Clark Research Analyst Center for Health Program Development and Management University of Maryland, Baltimore County -----Original Message----- From: SAS(r) Discussio...

Re: How to filter sas data sets into separate sas data sets #3
Lizette, Instead of trying to merge the two data sets, I would probably try to create a SAS format from the values of VAR1 in data set 1. Then, NODE1, NODE2 and NODE3 could be compared against the format for a match. The example below is a simplified version of what you could do and shows a printout of how it works. It has 5 observations in data set 1 and only 3 variables in data set 2, but I think the logic should hold for the example you gave. After the example is code that could be used to actually split the data as you had requested. Hope this helps. * create sas data set 1 ; data ...

Re: Deleting SAS Data from a SAS DATASET
One thing you might do is to add an index on the snap_dt to the dataset; = if that's there then you should be able to delete the records in place: proc sql; delete from prod.master_date; where snap_dt =3D "&end_dt"d; quit; run; In both the ways you are trying now you are creating new data sets = rather than deleting records from the current data set; it would seem to = me that a SQL delete statement would be faster than creating new = datasets even if there isn't an index on the date.=20 -Mary ----- Original Message -----=20 From: SUBSCRIBE SAS-L Chandra Gadde=20 To: SAS-L@LISTSERV.UGA.EDU=20 Sent: Friday, August 15, 2008 12:14 PM Subject: Deleting SAS Data from a SAS DATASET Hi All I have several SAS datasets that are very very big. (50GB of size). = Every month, the data is being appended to these datasets. I need to deleted = the data which is greater than 24 months. What is the best method to do = this? Please help me. I tried PROC SQS and DATA STEP. But these two are taking very long = time. Data prod.Master_data; set prod.master_date; if snap_dt =3D "&end_dt"d then delete; run; proc sql; crete table prod.master_date from prod.master_date where snap_dt ne "&end_dt"d; quit; Hi You've got good ideas how to delete the old observations. My modify proposal was wrong. Sorry about that! I still think that changing the data model would be a good idea. Regards Patrick ...

Re: Help- How to change transaction data to individual level data in SAS
Here's more info on this very interest request... ________________________________ Bruce A. Johnson bjohnson@solucient.com -----Original Message----- From: Tulikaa Khunnah [mailto:tulikaa@yahoo.com] Sent: Tuesday, May 11, 2004 3:39 PM To: Bruce Johnson Subject: Help- How to change transaction data to individual level data in SAS Dear Bruce, I have web visit data for individuals with the duration, date, pages viewed, etc. I wanted to create one record per individual to run a logit first and then a dynamic program. I need to create a lot of lagged variables (last web portal visited -...

Re: SAS help needed
Data Have ; Infile Cards ; Input sno dt Date9. ; Cards ; 1011 01jan2000 1012 02jan2000 1012 03jan2000 1012 04jan2000 1012 05jan2000 1012 06jan2000 1012 07jan2000 1013 03jan2000 1013 04jan2000 1013 05jan2000 1013 06jan2000 1013 07jan2000 ; Run ; Data Need ( Drop = Cnt ) ; Length NewVar $ 2 ; Set Have ; By Sno ; Retian Newvar ; If First.SNO Then Do ; Cnt + 1 ; NewVar = CatS( 'A' , Cnt ) ; End ; Run ; Proc Print Data = Need ; Format DT Date9. ; Run ; Toby Dunn If anything simply cannot go wrong, it will anyway. Murphys Law #2. The buddy system is essential to your survival;...

Re: Deleting SAS Data from a SAS DATASET #12
--On 8/15/08 6:03 PM -0400 Chang Chung wrote: > good point! but as shown below, you can make a view of multiple datasets > having the separate indexes, and where seems to be fine with this. > interesting. ran on sas 9.1.3 sp4 on windows. > /* make a view of two datasets appended */ > proc sql feedback; > drop view work.oneTwo; > create view oneTwo as > select * from one union select * from two > order by age; > quit; One thought on this--at least in my general approach to using views--is you probably want to avoid the ORDER BY statement--especially if it's the variable you're indexing on and you want to use a subset. For any amount of data above a trivial one, there's no sense in forcing the view to re-order th e data if it doesn't have to. Dave ...

Re: Deleting SAS Data from a SAS DATASET #4
Summary: PROC DATASETS; AGE statement. + VIEWs This won't help you delete data from your very big data set, but you may find this example interesting. You say you append data monthly to a big data set then when big gets too big you need to clean out the old. And that takes a very long time. However if you don't physically append but use a view to append/combine you may find it easier to get rid of the unwanted old data. Consider this code. it pushes MonthlyUpdate onto the stack of 24 data sets and the 24th data set is deleted. Then all the data sets get renamed to produce a new group of 24. You can see from the notes how the operation works. The data sets don't have to use a numbered range M01-M24 I did that for my convenience. proc datasets library=work; age MonthlyUpdate m01-m24; run; quit; NOTE: Deleting WORK.M24 (memtype=DATA). NOTE: Aging the name WORK.M23 to WORK.M24 (memtype=DATA). NOTE: Aging the name WORK.M22 to WORK.M23 (memtype=DATA). NOTE: Aging the name WORK.M21 to WORK.M22 (memtype=DATA). NOTE: Aging the name WORK.M20 to WORK.M21 (memtype=DATA). NOTE: Aging the name WORK.M19 to WORK.M20 (memtype=DATA). NOTE: Aging the name WORK.M18 to WORK.M19 (memtype=DATA). NOTE: Aging the name WORK.M17 to WORK.M18 (memtype=DATA). NOTE: Aging the name WORK.M16 to WORK.M17 (memtype=DATA). NOTE: Aging the name WORK.M15 to WORK.M16 (memtype=DATA). NOTE: Aging the name WORK.M14 to WORK.M15 (memtype=DATA). NOTE: Aging the name WORK.M13 to WORK.M14 (me...

Re: Deleting SAS Data from a SAS DATASET #18
Chandra, This is an excellent suggestion from Ian! Perhaps just recreate the = data set (you would in that case want to recreate, and thus NOT use the = SQL delete statement) once every 2-3 months and delete 2-3 months worth = of data at that time; it would seem that that wouldn't take too much = longer than deleting 1 month at a time, and thus the total time would be = reduced by as much as 50%. And this would meet my favorite efficiency marker, since I've met a lot = of people who don't want to work weekends and have yet to meet a = computer who cares, "less people time!" -Mary ----- Original Message -----=20 From: Ian Whitlock=20 To: SAS-L@LISTSERV.UGA.EDU=20 Sent: Friday, August 15, 2008 6:07 PM Subject: Re: Deleting SAS Data from a SAS DATASET Summary: Suggestions for maintaining large data set #iw-value=3D1 Chandra, You are adding about 2 gig per month. That is 4% increase. Perhaps accepting the increase one month and then modifying the second month would make more sense, if the data is accessed infrequently. To do this you need to control all programs that read the data set. ...

Re: Deleting SAS Data from a SAS DATASET #10
On Fri, 15 Aug 2008 17:20:13 -0500, Mary <mlhoward@AVALON.NET> wrote: >And what about the time of the database administrator who now needs to keep track of 24 indexes to each index in the previous table? I just can't see our DB2 administrators would have ever thought to organize the data this way, though we had many very large tables, like the user had, that were purged by month; it does seem like it would be a lot of "people work" to manage 24 tables plus one index instead of just one table, even if querying didn't suffer(and I do think that it could). .... hi, There are only 24, not like thousands or millions! :-) and with any DB system, if you have a huge table, then it is more likely that it will map to multiple physical files behind the scene anyway. In terms of querying speed, i rather think it can be faster. One way is to spawn many sas sessions to do multiple separate queries at the same time, then put together... sort of like do-it-yourself parallel processing. implementation is left as homework. happy friday! cheers, chang ...

Re: search SAS data set from SAS code
> From: Rose > Hi All, > Suppose I have a sas permanent data set which was created > early, I know > the library path but I couldn't remember in which sas program code I > created it. how can I search from so many sas program files in > different folders and find it. a problem familiar to all of us delayed-housekeeping folks. Libname Libref '<directory-specification>'; DATA LibRef.DataSetName; use your system utilities to search for the dir-spec of your libref. search: *.sas containing text: <dir-spec> once you have found the libname...

Re: Deleting SAS Data from a SAS DATASET #5
I also read that this could be a problem on machines that have multiple = processors, such as running DB2; if the data is clustered and each = processor takes care of one cluster, then you could have queries all = hitting the same processor instead of distributing the load across all = processors, thus potentially slowing down queries in peak periods where = you have multiple queries at the same time, if queries tend to be based = on the month (such as bank statements). Thus I'd proceed with caution = on the idea of splitting one table into 24 tables with one view without = making sure the other consequences of doing so are fully understood. -Mary ----- Original Message -----=20 From: Mary=20 To: SAS-L@LISTSERV.UGA.EDU=20 Sent: Friday, August 15, 2008 4:09 PM Subject: Re: Re: Deleting SAS Data from a SAS DATASET A view helps on deletes, but I wonder how it affects performance of = querying the data- wouldn't storing the data in 24 different locations = cause a significant slowdown in perfomance upon querying the data versus = having it all in one table that is indexed? If this data is queryied a = lot but only deleted once a month, the time in querying (which probably = is in peak time) could be much more important than the time in deleting = (which could be run when the computer is not busy, such as nights or = weekends). =20 -Mary ...

Re: Deleting SAS Data from a SAS DATASET #9
On Fri, 15 Aug 2008 16:09:46 -0500, Mary <mlhoward@AVALON.NET> wrote: >A view helps on deletes, but I wonder how it affects performance of querying the data- wouldn't storing the data in 24 different locations cause a significant slowdown in perfomance upon querying the data versus having it all in one table that is indexed? If this data is queryied a lot but only deleted once a month, the time in querying (which probably is in peak time) could be much more important than the time in deleting (which could be run when the computer is not busy, such as nights or weekends). hi, good point! but as shown below, you can make a view of multiple datasets having the separate indexes, and where seems to be fine with this. interesting. ran on sas 9.1.3 sp4 on windows. cheers, chang /* test datasets */ data one two; set sashelp.class; ds = "one"; output one; ds = "two"; output two; run; /* separately index on age */ proc datasets lib=work; modify one; index delete age; index create age; modify two; index delete age; index create age; quit; /* make a view of two datasets appended */ proc sql feedback; drop view work.oneTwo; create view oneTwo as select * from one union select * from two order by age; quit; /* where is utilizing the indexes */ options msglevel=i; data sixteenAndOlder; set oneTwo; /* we are using the view */ where age >= 16; run; /* on log INFO: Index Age selected for WHERE clause optimiz...

Re: Deleting SAS Data from a SAS DATASET #11
And what about the time of the database administrator who now needs to = keep track of 24 indexes to each index in the previous table? I just = can't see our DB2 administrators would have ever thought to organize the = data this way, though we had many very large tables, like the user had, = that were purged by month; it does seem like it would be a lot of = "people work" to manage 24 tables plus one index instead of just one = table, even if querying didn't suffer(and I do think that it could).=20 -Mary ----- Original Message -----=20 From: Chang Chung=20 To: SAS-L@LISTSERV.UGA.EDU=20 Sent: Friday, August 15, 2008 5:03 PM Subject: Re: Deleting SAS Data from a SAS DATASET hi, good point! but as shown below, you can make a view of multiple = datasets having the separate indexes, and where seems to be fine with this. interesting. ran on sas 9.1.3 sp4 on windows. cheers, chang /* test datasets */ data one two; set sashelp.class; ds =3D "one"; output one; ds =3D "two"; output two; run; /* separately index on age */ proc datasets lib=3Dwork; modify one; index delete age; index create age; modify two; index delete age; index create age; quit; /* make a view of two datasets appended */ proc sql feedback; drop view work.oneTwo; create view oneTwo as select * from one union select * from two order by age; quit; /* where is utili...

Web resources about - Re: Need help with SAS Data step - comp.soft-sys.sas

North Carolina Deputies Suspended for ‘Failures to Act’ During Trump Rally Violence
A group of sheriff’s deputies in North Carolina have been suspended after a Donald Trump rally where a protester was punched after being escorted ...

Twitch users decided my fate in a VR game built on Amazon Lumberyard
Hidden away on the exhibition floor at the Game Developers Conference in San Francisco today, I found a short line next to the big booth for ...

Apple looks to Google’s Cloud Platform as it diversifies its infrastructure
Rumors are flying today that Apple is moving part of its cloud business from AWS to Google’s Cloud Platform. We did some asking around and yes, ...

Obama slaps new sanctions on North Korea after tests
By Joel Schectman and Yeganeh Torbati WASHINGTON (Reuters) - President Barack Obama imposed sweeping new sanctions on North Korea on Wednesday ...

Black Maryland Cop Killed By Fellow Officer Who Thought He Was Shootout Suspect
Jacai Colson, a Prince George’s County (Mary.) cop, was killed over the weekend by friendly fire during a shootout outside PGC police headquarters. ...

Universal Windows Apps coming to Xbox One this summer
One Windows Platform for every form factor. (credit: Microsoft ) Windows developers will be able to build Universal Windows Platform apps for ...

Hacker who stole celebrities' nude photos will plead guilty
CNET Hacker who stole celebrities' nude photos will plead guilty CNET A hacker who accessed accounts of actress Jennifer Lawrence, pictured ...

5 things we learned from Janet Yellen about Fed rate hikes and the U.S. economy
Federal Reserve policymakers said the U.S. economy is strong enough to handle increases in a key interest rate this year, but they have scaled ...

Driver Accused in Kalamazoo Shooting Spree Files $10 Million Civil Rights Lawsuit Against Uber
On Tuesday, Jason Brian Dalton, the 45-year-old man charged with murdering six people in a shooting spree last month, filed a $10 million federal ...

Amazon patents a technology that lets customers pay by taking a selfie
More so than most, Amazon has every reason to try and make the check out process as seamless as possible. After all, sometimes all a consumer ...

Resources last updated: 3/17/2016 12:51:41 AM