f



Re: help with reading ASCII data into SAS #6

I'm only reposting my suggestion, with changes (suggested by Andre
offline), that are obviously needed for the code to work correctly.

Specifically, I had moved the formats and informats to the end of the code
(so as not to change the order in the PDF) but, as a result, made then
ineffective.  As such, my suggested code should have read:

data a;
  informat dd dtc dtm anydtdtm19. ;
  format dd dtc dtm datetime21.;
  informat u $10.;
  format u $10.;
  infile "data.txt" dlm=',' dsd firstobs=2 lrecl=200;
  input site id pid it $ dd itd rtd linkid sp fc dtc dtm u $;
run;

Art
--------
On Wed, 5 Nov 2008 20:38:24 -0500, Arthur Tabachneck <art297@NETSCAPE.NET>
wrote:

>Olive,
>
>Try:
>
>data a;
>  infile "data.txt" dlm=',' dsd firstobs=2 lrecl=200;
>  input site id pid it $ dd itd rtd linkid sp fc dtc dtm u $;
>  informat dd dtc dtm anydtdtm19. ;
>  format dd dtc dtm datetime21.;
>  informat u $10.;
>  format u $10.;
>run;
>
>HTH,
>Art
>--------
>On Wed, 5 Nov 2008 11:36:20 -0800, olivesecret@GMAIL.COM wrote:
>
>>I tried Andre's code, that is, do not import data from the hard disc
>>by infile statement, but copy all the data directly to sas using
>>datalines. You know what? Now it works. So it means there is something
>>wrong when I use infile statement to import data from the hard disc.
>>Any suggestions?
>>Thanks a lot!
>>
>>
>>
>>On Nov 5, 1:57 pm, bigD <diaphanos...@gmail.com> wrote:
>>> Andre's code works for the example you gave ....
>>>
>>> On Nov 5, 1:20 pm, olivesec...@gmail.com wrote:
>>>
>>> > Here is my code:
>>>
>>> >    data data;
>>> >     infile 'data.txt' delimiter=',' dsd firstobs=2;
>>> >      input site id pid it $ dd itd rtd linkid sp fc dtc dtm u $5. ;
>>> > run;
>>>
>>> > Here is one more obs:
>>>
>>> > 1,4,1004,"JS",9/27/2008 0:00:00,1,1,57,11,10,10/3/2008
>>> > 11:31:17,10/3/2008= 11:31:17,"AVRC\psuggett"
>>>
>>> > Other obs are similar.
>>>
>>> > Thank you very much!
>>>
>>> > On Nov 5, 12:24 pm, Nord...@DSHS.WA.GOV ("Nordlund, Dan (DSHS/RDA)")
>>> > wrote:
>>>
>>> > > > -----Original Message-----
>>> > > > From: SAS(r) Discussion [mailto:SA...@LISTSERV.UGA.EDU] On
>>> > > > Behalf Of olivesec...@GMAIL.COM
>>> > > > Sent: Wednesday, November 05, 2008 8:50 AM
>>> > > > To: SA...@LISTSERV.UGA.EDU
>>> > > > Subject: Re: help with reading ASCII data into SAS
>>>
>>> > > > Yes, I did it with delimiter=',' dsd firstobs=2, but was told
>invalid
>>> > > > data for each variable.
>>> > > > Any more suggestions? Thanks a lot!
>>>
>>> > > You will need to show us the actual code you are using to read the
>file if you want more than just a guess as to what went wrong.  Seeing the
>log file with actual error message would be helpful as well.
>>>
>>> > > Dan
>>>
>>> > > Daniel J. Nordlund
>>> > > Washington State Department of Social and Health Services
>>> > > Planning, Performance, and Accountability
>>> > > Research and Data Analysis Division
>>> > > Olympia, WA  98504-5204- Hide quoted text -
>>>
>>> > - Show quoted text -
0
art297 (4213)
11/6/2008 6:31:07 PM
comp.soft-sys.sas 142828 articles. 3 followers. Post Follow

0 Replies
385 Views

Similar Articles

[PageSpeed] 11

Reply:

Similar Artilces:

Re: help with reading ASCII data into SAS
Secret... here a start try data a; informat dd dtc dtm anydtdtm17. ; infile cards dlm=',' dsd firstobs=2; input site id pid it $ dd itd rtd linkid sp fc dtc dtm u $5. ; cards; "Site","ID","PID","IT","DD","ITD","RTD","LinkID","SP","FC","DTC","DTM","U" 1,1,100,"DA",1/1/2008 0:00:00,1,1,1,1,10,1/1/2008 13:10:20,1/1/2008 13:10:20,"obd" ; run; proc print data=a; format dd dtc dtm datetime17.; run; but the limits are the length of the variables and those types as i have only one line of data and no other specification HTH Andre olivesecret@GMAIL.COM a �crit : > I will appreciate for any suggestions. The data is a txt file. The > first two observations of the data is: > > "=Site","ID","PID","IT","DD","ITD","RTD","Lin=kID","SP","FC","DTC","DTM","U" > 1,1,100,"DA",1/1/2008 0:00:00,1,1,1,1,10,1/1/2008 13:10:20,1/1/2008 > =13:10:20,"obd" > > Thanks a lot! > > -- Andr� WIELKI INED (Institut National d'Etudes D�mographiques) Service Informatique 133 Boulevard Davout 75980 Paris Cedex 20 m�l : wielki@ined.fr t�l : 33 (0) 1 56 06 21 54 ...

Re: help with reading ASCII data into SAS #3
ok, in that case u was too short: data a; infile "c:\daten\test.dat" dlm="," truncover dsd firstobs=2; input site : 8. id : 8. pid : 8. it : $5. dd : ANYDTDTM20. itd : 8. rtd : 8. linkid : 8. sp : 8. fc : 8. dtc : ANYDTDTM20. dtm : ANYDTDTM20. u : $15. ; u = compress(u,'""'); it = compress(it,'""'); format dtm dtc dd datetime20.; run; Gerhard On Wed, 5 Nov 2008 10:20:47 -0800, olivesecret@GMAIL.COM wrote: >Here is my code: > > data data; > infile 'data.txt' delimiter=',' dsd firstobs=2; > input site id pid it $ dd itd rtd linkid sp fc dtc dtm u $5. ; >run; > >Here is one more obs: > >1,4,1004,"JS",9/27/2008 0:00:00,1,1,57,11,10,10/3/2008 >11:31:17,10/3/2008= 11:31:17,"AVRC\psuggett" > >Other obs are similar. > >Thank you very much! > > > >On Nov 5, 12:24 pm, Nord...@DSHS.WA.GOV ("Nordlund, Dan (DSHS/RDA)") >wrote: >> > -----Original Message----- >> > From: SAS(r) Discussion [mailto:SA...@LISTSERV.UGA.EDU] On >> > Behalf Of olivesec...@GMAIL.COM >> > Sent: Wednesday, November 05, 2008 8:50 AM >> > To: SA...@LISTSERV.UGA.EDU >> > Subject: Re: help with reading ASCII data into SAS >> >> > Yes, I did it with delimiter=',' dsd firstobs=2, but was told invalid >> > data for each vari...

Re: help with reading ASCII data into SAS #2
> -----Original Message----- > From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On > Behalf Of olivesecret@GMAIL.COM > Sent: Wednesday, November 05, 2008 8:50 AM > To: SAS-L@LISTSERV.UGA.EDU > Subject: Re: help with reading ASCII data into SAS > > Yes, I did it with delimiter=',' dsd firstobs=2, but was told invalid > data for each variable. > Any more suggestions? Thanks a lot! > > You will need to show us the actual code you are using to read the file if you want more than just a guess as to what went wrong. Seeing the log file with actual error message would be helpful as well. Dan Daniel J. Nordlund Washington State Department of Social and Health Services Planning, Performance, and Accountability Research and Data Analysis Division Olympia, WA 98504-5204 Here is my code: data data; infile 'data.txt' delimiter=',' dsd firstobs=2; input site id pid it $ dd itd rtd linkid sp fc dtc dtm u $5. ; run; Here is one more obs: 1,4,1004,"JS",9/27/2008 0:00:00,1,1,57,11,10,10/3/2008 11:31:17,10/3/2008= 11:31:17,"AVRC\psuggett" Other obs are similar. Thank you very much! On Nov 5, 12:24 pm, Nord...@DSHS.WA.GOV ("Nordlund, Dan (DSHS/RDA)") wrote: > > -----Original Message----- > > From: SAS(r) Discussion [mailto:SA...@LISTSERV.UGA.EDU] On > > Behalf Of olivesec...@GMAIL.COM > > Sent: Wednesday, November 05, 2008 8:50 AM > > To: SA...@...

Re: help with reading ASCII data into SAS #4
its not much information about your problem. Did you try it with something like: data a; infile "c:\daten\test.dat" dlm="," truncover; if _n_=1 then do input; delete; end; else input site : 8. id : 8. pid : 8. it : $5. dd : ANYDTDTM20. itd : 8. rtd : 8. linkid : 8. sp : 8. fc : 8. dtc : ANYDTDTM20. dtm : ANYDTDTM20. u : $5. ; u = compress(u,'""'); it = compress(it,'""'); format dtm dtc dd datetime20.; run; That seems to work for your example. Gerhard On Wed, 5 Nov 2008 07:45:07 -0800, olivesecret@GMAIL.COM wrote: >I will appreciate for any suggestions. The data is a txt file. The >first two observations of the data is: > >"=Site","ID","PID","IT","DD","ITD","RTD","Lin=kID","SP","FC","DTC","DTM"," U" >1,1,100,"DA",1/1/2008 0:00:00,1,1,1,1,10,1/1/2008 13:10:20,1/1/2008 >=13:10:20,"obd" > >Thanks a lot! ...

Re: help with reading ASCII data into SAS #5
Olive, Try: data a; infile "data.txt" dlm=',' dsd firstobs=2 lrecl=200; input site id pid it $ dd itd rtd linkid sp fc dtc dtm u $; informat dd dtc dtm anydtdtm19. ; format dd dtc dtm datetime21.; informat u $10.; format u $10.; run; HTH, Art -------- On Wed, 5 Nov 2008 11:36:20 -0800, olivesecret@GMAIL.COM wrote: >I tried Andre's code, that is, do not import data from the hard disc >by infile statement, but copy all the data directly to sas using >datalines. You know what? Now it works. So it means there is something >wrong when I use infile statement to import data from the hard disc. >Any suggestions? >Thanks a lot! > > > >On Nov 5, 1:57 pm, bigD <diaphanos...@gmail.com> wrote: >> Andre's code works for the example you gave .... >> >> On Nov 5, 1:20 pm, olivesec...@gmail.com wrote: >> >> > Here is my code: >> >> > data data; >> > infile 'data.txt' delimiter=',' dsd firstobs=2; >> > input site id pid it $ dd itd rtd linkid sp fc dtc dtm u $5. ; >> > run; >> >> > Here is one more obs: >> >> > 1,4,1004,"JS",9/27/2008 0:00:00,1,1,57,11,10,10/3/2008 >> > 11:31:17,10/3/2008= 11:31:17,"AVRC\psuggett" >> >> > Other obs are similar. >> >> > Thank you very much! >> >> > On Nov 5, 12:24 pm, Nord...@DSHS....

Re: Deleting SAS Data from a SAS DATASET #6
I have been watching this thread today and I just now recall an example that Paul Dorfman gave at a RUG several years ago and no, I don't recall exactly where or when other than it was NESUG or SESUG in the past 5 years. Anyway, Paul had a client who was storing something like the past 12 months of transactions as variables andat the start of each month needed to stick the just ended month on the end and drop the oldest month. Paul used Peek to read the last 11 months of each obs as a single chunk of data, append the current's month, and then used Poke to write the whole new obs as a unit. The time reduction was dramatic. It probably would not work here unless you knew a whole lot about the structure of the data set and it has a very fixed structure but I was so impressed with the solution that I like to mention it whenever it seems even remotely useful. Nat Wooding Environmental Specialist III Dominion, Environmental Biology 4111 Castlewood Rd Richmond, VA 23234 Phone:804-271-5313, Fax: 804-271-2977 CONFIDENTIALITY NOTICE: This electronic message contains information which may be legally confidential and/or privileged and does not in any case represent a firm ENERGY COMMODITY bid or offer relating thereto which binds the sender without an additional express written confirmation to that effect. The information is intended solely for the individual or entity named above and access by anyone else is unauthorized. If you are not the intended recipient, any disclos...

help with reading ASCII data into SAS
I will appreciate for any suggestions. The data is a txt file. The first two observations of the data is: "=Site","ID","PID","IT","DD","ITD","RTD","Lin=kID","SP","FC","DTC","DTM","U" 1,1,100,"DA",1/1/2008 0:00:00,1,1,1,1,10,1/1/2008 13:10:20,1/1/2008 =13:10:20,"obd" Thanks a lot! Can anyone help me? On Nov 5, 10:45 am, olivesec...@gmail.com wrote: > I will appreciate for any suggestions. The data is a txt file. The > first two observations of the data is: > > "=Site","ID","PID","IT","DD","ITD","RTD","Lin=kID","SP","FC","DTC","DTM","U" > 1,1,100,"DA",1/1/2008 0:00:00,1,1,1,1,10,1/1/2008 13:10:20,1/1/2008 > =13:10:20,"obd" > > Thanks a lot! imort the data as comma separated values. If it does not read the values properly, copy the log into the program window and edited it accordingly On Nov 5, 11:09=A0am, olivesec...@gmail.com wrote: > Can anyone help me? > > On Nov 5, 10:45 am, olivesec...@gmail.com wrote: > > > > > I will appreciate for any suggestions. The data is a txt file. The > > first two observations of the data is: > > > "=3DSite","ID","PID","IT","DD",&...

Re: Help on data creation for SAS #6
Jack and Ya have pointed out your problem. In addition, I see some redundancy within If first.id then do ..... block. After writing the record out you are resetting the values identical to the conditions within the ELSE DO block. If a second record is required to be written for the first.id then you need another OUTPUT statement before the end. It is hard to guess what is needed without further details. You have made a good effort by giving us a sample. Can you also provide a sample output for the corresponding sample input? In other words provide: 1. What you have (the input) 2. What you ...

Re: Reading & Writing SAS data sets without SAS #3
Chang, You're correct in that a number of companies have done it. I believe SPSS can do it, WPS, Stat Transfer, dbmscopy, and perhaps others have also done it. But what I think is unique about this is that Alan is talking about offering plug-ins so you can roll-your-own so to speak. How cool would it be to have some type of driver/plugin for R? Phil Philip Rack MineQuest, LLC SAS & WPS Consulting and WPS Reseller Tel: (614) 457-3714 Web: www.MineQuest.com Blog: www.MineQuest.com/WordPress -----Original Message----- From: Chang Chung [mailto:chang_y_chung@HOTMAIL.COM] Sent: Monday...

Re: Reading SAS data sets on UNIX by non-SAS apps #2
John: Following on Richard's thoughtful suggestions, the Affinium system would likely capture data from csv files. SAS PROC EXPORT produces them quickly, and loading them into external systems works faster for relatively basic data structures and data formats, in my experience, than xml parsing. Sig -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of John Bentley Sent: Monday, October 18, 2004 10:10 AM To: SAS-L@LISTSERV.UGA.EDU Subject: Reading SAS data sets on UNIX by non-SAS apps I have SAS data sets on AIX that we need to read with Unica's Affinium campaign management software, also on a UNIX box. (Let's not get into why we didn't go with the SAS Solution.) SAS Institute doesn't supply an ODBC driver for the UNIX environment, and the Affinium implementors don't want to use the SAS SQL Library for C and or deal with APIs. Other that dumping the SAS data sets as flat files, can anyone suggest a solution? Thanks in advance for the help. ...

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: SAS help on data analysis #6 649037
Mike, This can be done with an extra data step or in one if you are reading raw data. How should we handle missing values? The LAG() function is indeed what you want, but you need but one call: data one ; do i = 1 to 100 ; output ; end ; run ; data two ( drop = sum lag4 ) ; set one ; sum + i ; lag4 = lag4( i ) ; if _n_ > 4 then do ; ave = sum / 5 ; sum +- lag4 ; end ; run ; Write back to the list with more details if you have not yet found the clue that would help you... Regards, Kevin Kevin Viel Department of Epidemiology Rollins School of P...

Re: SAS help on data analysis #6 1548036
Hi Mike: Are you looking for something like this: data tep; input x y; mean_x=Mean(x,lag1(x),lag2(x),lag3(x),lag4(x)); cards; 1 5 2 5 2 8 3 6 4 5 9 8 2 8 ; run; proc print;run; , If you can give us some sample data, Maybe we can help you better. Baogong On 6/16/05, Mike Smith <del101679@yahoo.com> wrote: > Hi. I wanted to compute the average of every five numbers in my data set in > SAS. How do I do it? Thanks. > -- Baoogng Jiang Department of Agronomy Lousisana State University ...

Re: How to Read PDF/RTF data in to SAS datasets #6
You can try my utility called ConvertRTF if it is an RTF file. It should transform it into a tab delimited file which can then be easily read in by SAS: http://www.savian.net/utilities.aspx #11 Alan Alan Churchill Savian "Bridging SAS and Microsoft Technologies" www.savian.net -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Peter Crawford Sent: Tuesday, November 28, 2006 8:02 AM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: How to Read PDF/RTF data in to SAS datasets On Tue, 28 Nov 2006 14:50:49 GMT, John I <not@HOTMAIL.COM> wrot...

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: 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: Clearing SAS Data Data from Prior Run #6
I'm glad you jumped in. The "collective" makes for better combined solutions. har har Here's one possible OT question: Is the interconnectivity of SAS-L like the "Borg"? Cheers. :o) Mark -----Original Message----- From: Nathaniel_Wooding@Dom.com [mailto:Nathaniel_Wooding@Dom.com] Sent: Friday, June 30, 2006 11:04 AM To: Terjeson, Mark (IM&R) Cc: SAS-L@LISTSERV.UGA.EDU Subject: Re: Clearing SAS Data Data from Prior Run Hi, Mark I knew that you knew but I didn't want some one to read the archives and be mislead. Have a great weekend. Isn't it a...

Re: How to read a SAS log into a SAS dataset.
lazybone2k@GMAIL.COM wrote: > >Dear SAS-L listers, >This may be the millionth time somebody is asking this question " how to >read a SAS log into a SAS dataset?". I looked at previous posts and >gathered info from various SUGI papers and found a way to get the log and >read it. But i dont know for some reason its not working. Please help me. >I used a Proc printto procedure to print the log to a external file >location and try to read in the log and create a SAS dataset which will >contain info about Filename, Owner name, Group name, Elapsed time, CPU >t...

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: Compressing data sets (was Re: [SAS-L]) #2 #6
A new way to read/write Excel files in 9.1 was mentioned at SUGI, but as I recall it required a server running SAS/Access to PC File Formats. It wasn't SAS/Connect doing the reading and writing, just as SAS/Connect isn't doing the remote reading and writing in a regular Connect session. Or are you thinking of something else? -- JackHamilton@FirstHealth.com Manager, Technical Development Metrics Department, First Health West Sacramento, California USA >>> "Bruce Johnson" <bjohnson@SOLUCIENT.COM> 01/06/2004 10:02 AM >>> "using SAS/Connect to...

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 #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 ...

Web resources about - Re: help with reading ASCII data into SAS #6 - comp.soft-sys.sas

Reading, Massachusetts - Wikipedia, the free encyclopedia
Coordinates: 42°31′32″N 71°05′45″W  /  42.52556°N 71.09583°W  / 42.52556; -71.09583 Coordinates : 42°31′32″N 71°05′45″W  /  42.52556°N 71.09583°W ...

Crystal Palace v Reading score, result, video highlights, goals - Fox Sports Fox sports
Cabaye opened the scoring from the penalty spot in the 85th minute after Jake Cooper was sent off for fouling Yannick Bolasie. Substitute Campbell ...

Crystal Palace v Reading score, result, video highlights, goals
... goals by Yohan Cabaye and Fraizer Campbell have given Socceroos skipper Mile Jedinak’s Crystal Palace a 2-0 victory at second-tier club Reading ...

Oh, the pure pleasure of reading a newspaper
The weekend papers offer a window to the world, unlike the narrow and bitter offerings served up by online news.

Here's Mitt Romney Reading Mean Tweets by Trump and Trump Supporters
... the best tweet. Simon Dumenco, aka Media Guy, is an Ad Age editor-at-large. You can follow him on Twitter @simondumenco. Continue reading ...

(Late) Weekend Reading: Jeffrey Edleson on Sexual Harassment Here at Berkeley Edition
**Jeffrey Edleson**: [A Dean’s Reflection on Campus Sexual Misconduct Cases](http://blogs.berkeley.edu/2016/03/13/a-deans-reflection-on-camp ...

A brain-wave-reading device designed to improve sleep did wonderful and terrifying things to my dreams ...
The last week has been extremely unusual, to say the least. My dreams have been more colorful, detailed, vivid, and realistic than at any other ...

Students Not Reading Email? That’s Their Problem
A survey at Bowling Green State University shows that its students tend to read and respond to emails from their professors, but ignore emails ...

Melissa McBride Couldn't Speak After Reading The Walking Dead Season 6 Finale
The Walking Dead season six finale is going to be a mighty big, nasty pill to swallow.Several cast [...]

Man Learns About Ex’s Pregnancy & Friends’ Erotic Reading Habits Via Google Play
Sharing your review of an app — for good or bad — can help others decide if they should spend the money to add the service to their smartphone ...

Resources last updated: 3/16/2016 4:45:18 PM