Searching SAS-L

From sasCommunity
Jump to: navigation, search

Task.1: examine the U/GA search page:

http://www.listserv.uga.edu/cgi-bin/wa?S1=sas-l

This page discusses how to send an e-mail to the listserv with search commands in the body. ListServ returns results to you via e-mail.

Syntax

This is the listserv address for U/GA where SAS-L is hosted.

listserv@listserv.uga.edu 

This is the syntax of the search command which goes in the body of the e-mail message.

Dates are in the form yy/mm/dd.

Search search_string IN MYLIST SINCE 96/01/01
Search search_string IN MYLIST WHERE SENDER CONTAINS ERIC

Search for string

The key-word search can be abbreviated to sea.

This is important later because there is a 72-char line limit on commands.

sea search_string in SAS-L since 96/01/01

The search_string can contain some special characters, such as percent-sign.

sea %macro in SAS-L since 96/01/01

Be specific! %Macro will get you much!

Limiting the search to complete code with the terminating statement %mend gets less hits.

Add a terminating date.

sea %mend in SAS-L since 96/01/01 until 96/01/31

Results are limited to 100 hits; to cover a year use a set of commands.

Here are the commands to search all months in a year.

sea %mend in SAS-L since 96/01/01 until 96/01/31
sea %mend in SAS-L since 96/02/01 until 96/02/29
sea %mend in SAS-L since 96/03/01 until 96/03/31
sea %mend in SAS-L since 96/04/01 until 96/04/30
sea %mend in SAS-L since 96/05/01 until 96/05/31
sea %mend in SAS-L since 96/06/01 until 96/06/30
sea %mend in SAS-L since 96/07/01 until 96/07/31
sea %mend in SAS-L since 96/08/01 until 96/08/31
sea %mend in SAS-L since 96/09/01 until 96/09/30
sea %mend in SAS-L since 96/10/01 until 96/10/31
sea %mend in SAS-L since 96/11/01 until 96/11/30
sea %mend in SAS-L since 96/12/01 until 96/12/31

There may be more than 100 hits in a month for the word you are searching for so consider using a week search:

sea %mend in SAS-L since 96/01/01 until 96/01/07
sea %mend in SAS-L since 96/01/08 until 96/01/14
sea %mend in SAS-L since 96/01/15 until 96/01/21
sea %mend in SAS-L since 96/01/22 until 96/01/31

Searching for a person

sea search_string in SAS-L where sender contains <word-in-e-mail-address>
sea %mend in SAS-L where sender contains westat since 96/12/01 until 96/12/31

Note: Ian Whitlock usually had a summary line at the top of his thoughtful responses.

search for: summary

In messages where:
The subject is or contains: 
The author's address is or contains: whit
Since:	Jan 1996
Until:	Dec 1996

Results:

Item #35 (31 Jan 1996 17:33) - Re: Help! There has to be a better way!
Subject: Help! There has to be a better way!
Summary: Use an indexed look up.

Item #182 (3 Feb 1996 17:47) - Re: Variables in Multiple Datasets
Subject: Re: Variables in Multiple Datasets
Summary: SQL and the SAS system's DICTIONARY files are handy.

Item #284 (5 Feb 1996 15:09) - Re: Reading Raw data
Subject: Reading Raw data
Summary: CALL EXECUTE

Item #285 (5 Feb 1996 15:12) - Re[2]: Help with another macro problem
Subject: Re: Help with another macro problem
Summary: Time warps are not allowed in version 6 - cause must precede
effect.

Item #359 (7 Feb 1996 11:48) - Re: Another SQL question
Subject: Another SQL question
Summary: Some OR suggestions.

Item #476 (9 Feb 1996 11:16) - Re[2]: Comma delimited files
Subject: Re: Comma delimited files
Summary: Use a SAS DATA step to prepare the data.

Item #617 (13 Feb 1996 10:11) - Re: Array Problem in a Macro
Subject: Array Problem in a Macro
Summary: The first step to problem solving is knowing the problem.

search monthly for many years

Note: this covers leap years since the range is from first of month.2 to first of month.3.

sea %macro in SAS-L where sender contains rjf2 since 96/01/01 until 96/02/01
sea %macro in SAS-L where sender contains rjf2 since 96/02/01 until 96/03/01
sea %macro in SAS-L where sender contains rjf2 since 96/03/01 until 96/04/01
sea %macro in SAS-L where sender contains rjf2 since 96/04/01 until 96/05/01
sea %macro in SAS-L where sender contains rjf2 since 96/05/01 until 96/06/01
sea %macro in SAS-L where sender contains rjf2 since 96/06/01 until 96/07/01
sea %macro in SAS-L where sender contains rjf2 since 96/07/01 until 96/08/01
sea %macro in SAS-L where sender contains rjf2 since 96/08/01 until 96/09/01
sea %macro in SAS-L where sender contains rjf2 since 96/09/01 until 96/10/01
sea %macro in SAS-L where sender contains rjf2 since 96/10/01 until 96/11/01
sea %macro in SAS-L where sender contains rjf2 since 96/11/01 until 96/12/01
sea %macro in SAS-L where sender contains rjf2 since 96/12/01 until 96/12/31

sea %macro in SAS-L where sender contains rjf2 since 97/01/01 until 97/02/01
sea %macro in SAS-L where sender contains rjf2 since 97/02/01 until 97/03/01
sea %macro in SAS-L where sender contains rjf2 since 97/03/01 until 97/04/01
sea %macro in SAS-L where sender contains rjf2 since 97/04/01 until 97/05/01
sea %macro in SAS-L where sender contains rjf2 since 97/05/01 until 97/06/01
sea %macro in SAS-L where sender contains rjf2 since 97/06/01 until 97/07/01
sea %macro in SAS-L where sender contains rjf2 since 97/07/01 until 97/08/01
sea %macro in SAS-L where sender contains rjf2 since 97/08/01 until 97/09/01
sea %macro in SAS-L where sender contains rjf2 since 97/09/01 until 97/10/01
sea %macro in SAS-L where sender contains rjf2 since 97/10/01 until 97/11/01
sea %macro in SAS-L where sender contains rjf2 since 97/11/01 until 97/12/01
sea %macro in SAS-L where sender contains rjf2 since 97/12/01 until 97/12/31

sea %macro in SAS-L where sender contains rjf2 since 98/01/01 until 98/02/01
sea %macro in SAS-L where sender contains rjf2 since 98/02/01 until 98/03/01
sea %macro in SAS-L where sender contains rjf2 since 98/03/01 until 98/04/01
sea %macro in SAS-L where sender contains rjf2 since 98/04/01 until 98/05/01
sea %macro in SAS-L where sender contains rjf2 since 98/05/01 until 98/06/01
sea %macro in SAS-L where sender contains rjf2 since 98/06/01 until 98/07/01
sea %macro in SAS-L where sender contains rjf2 since 98/07/01 until 98/08/01
sea %macro in SAS-L where sender contains rjf2 since 98/08/01 until 98/09/01
sea %macro in SAS-L where sender contains rjf2 since 98/09/01 until 98/10/01
sea %macro in SAS-L where sender contains rjf2 since 98/10/01 until 98/11/01
sea %macro in SAS-L where sender contains rjf2 since 98/11/01 until 98/12/01
sea %macro in SAS-L where sender contains rjf2 since 98/12/01 until 98/12/31

sea %macro in SAS-L where sender contains rjf2 since 99/01/01 until 99/02/01
sea %macro in SAS-L where sender contains rjf2 since 99/02/01 until 99/03/01
sea %macro in SAS-L where sender contains rjf2 since 99/03/01 until 99/04/01
sea %macro in SAS-L where sender contains rjf2 since 99/04/01 until 99/05/01
sea %macro in SAS-L where sender contains rjf2 since 99/05/01 until 99/06/01
sea %macro in SAS-L where sender contains rjf2 since 99/06/01 until 99/07/01
sea %macro in SAS-L where sender contains rjf2 since 99/07/01 until 99/08/01
sea %macro in SAS-L where sender contains rjf2 since 99/08/01 until 99/09/01
sea %macro in SAS-L where sender contains rjf2 since 99/09/01 until 99/10/01
sea %macro in SAS-L where sender contains rjf2 since 99/10/01 until 99/11/01
sea %macro in SAS-L where sender contains rjf2 since 99/11/01 until 99/12/01
sea %macro in SAS-L where sender contains rjf2 since 99/12/01 until 99/12/31

sea %macro in SAS-L where sender contains rjf2 since 00/01/01 until 00/02/01
sea %macro in SAS-L where sender contains rjf2 since 00/02/01 until 00/03/01
sea %macro in SAS-L where sender contains rjf2 since 00/03/01 until 00/04/01
sea %macro in SAS-L where sender contains rjf2 since 00/04/01 until 00/05/01
sea %macro in SAS-L where sender contains rjf2 since 00/05/01 until 00/06/01
sea %macro in SAS-L where sender contains rjf2 since 00/06/01 until 00/07/01
sea %macro in SAS-L where sender contains rjf2 since 00/07/01 until 00/08/01
sea %macro in SAS-L where sender contains rjf2 since 00/08/01 until 00/09/01
sea %macro in SAS-L where sender contains rjf2 since 00/09/01 until 00/10/01
sea %macro in SAS-L where sender contains rjf2 since 00/10/01 until 00/11/01
sea %macro in SAS-L where sender contains rjf2 since 00/11/01 until 00/12/01
sea %macro in SAS-L where sender contains rjf2 since 00/12/01 until 00/12/31

sea %macro in SAS-L where sender contains rjf2 since 01/01/01 until 01/02/01
sea %macro in SAS-L where sender contains rjf2 since 01/02/01 until 01/03/01
sea %macro in SAS-L where sender contains rjf2 since 01/03/01 until 01/04/01
sea %macro in SAS-L where sender contains rjf2 since 01/04/01 until 01/05/01
sea %macro in SAS-L where sender contains rjf2 since 01/05/01 until 01/06/01
sea %macro in SAS-L where sender contains rjf2 since 01/06/01 until 01/07/01
sea %macro in SAS-L where sender contains rjf2 since 01/07/01 until 01/08/01
sea %macro in SAS-L where sender contains rjf2 since 01/08/01 until 01/09/01
sea %macro in SAS-L where sender contains rjf2 since 01/09/01 until 01/10/01
sea %macro in SAS-L where sender contains rjf2 since 01/10/01 until 01/11/01
sea %macro in SAS-L where sender contains rjf2 since 01/11/01 until 01/12/01
sea %macro in SAS-L where sender contains rjf2 since 01/12/01 until 01/12/31

sea %macro in SAS-L where sender contains rjf2 since 02/01/01 until 02/02/01
sea %macro in SAS-L where sender contains rjf2 since 02/02/01 until 02/03/01
sea %macro in SAS-L where sender contains rjf2 since 02/03/01 until 02/04/01
sea %macro in SAS-L where sender contains rjf2 since 02/04/01 until 02/05/01
sea %macro in SAS-L where sender contains rjf2 since 02/05/01 until 02/06/01
sea %macro in SAS-L where sender contains rjf2 since 02/06/01 until 02/07/01
sea %macro in SAS-L where sender contains rjf2 since 02/07/01 until 02/08/01
sea %macro in SAS-L where sender contains rjf2 since 02/08/01 until 02/09/01
sea %macro in SAS-L where sender contains rjf2 since 02/09/01 until 02/10/01
sea %macro in SAS-L where sender contains rjf2 since 02/10/01 until 02/11/01
sea %macro in SAS-L where sender contains rjf2 since 02/11/01 until 02/12/01
sea %macro in SAS-L where sender contains rjf2 since 02/12/01 until 02/12/31

sea %macro in SAS-L where sender contains rjf2 since 03/01/01 until 03/02/01
sea %macro in SAS-L where sender contains rjf2 since 03/02/01 until 03/03/01
sea %macro in SAS-L where sender contains rjf2 since 03/03/01 until 03/04/01
sea %macro in SAS-L where sender contains rjf2 since 03/04/01 until 03/05/01
sea %macro in SAS-L where sender contains rjf2 since 03/05/01 until 03/06/01
sea %macro in SAS-L where sender contains rjf2 since 03/06/01 until 03/07/01
sea %macro in SAS-L where sender contains rjf2 since 03/07/01 until 03/08/01
sea %macro in SAS-L where sender contains rjf2 since 03/08/01 until 03/09/01
sea %macro in SAS-L where sender contains rjf2 since 03/09/01 until 03/10/01
sea %macro in SAS-L where sender contains rjf2 since 03/10/01 until 03/11/01
sea %macro in SAS-L where sender contains rjf2 since 03/11/01 until 03/12/01
sea %macro in SAS-L where sender contains rjf2 since 03/12/01 until 03/12/31

sea %macro in SAS-L where sender contains rjf2 since 04/01/01 until 04/02/01
sea %macro in SAS-L where sender contains rjf2 since 04/02/01 until 04/03/01
sea %macro in SAS-L where sender contains rjf2 since 04/03/01 until 04/04/01
sea %macro in SAS-L where sender contains rjf2 since 04/04/01 until 04/05/01
sea %macro in SAS-L where sender contains rjf2 since 04/05/01 until 04/06/01
sea %macro in SAS-L where sender contains rjf2 since 04/06/01 until 04/07/01
sea %macro in SAS-L where sender contains rjf2 since 04/07/01 until 04/08/01
sea %macro in SAS-L where sender contains rjf2 since 04/08/01 until 04/09/01
sea %macro in SAS-L where sender contains rjf2 since 04/09/01 until 04/10/01
sea %macro in SAS-L where sender contains rjf2 since 04/10/01 until 04/11/01
sea %macro in SAS-L where sender contains rjf2 since 04/11/01 until 04/12/01
sea %macro in SAS-L where sender contains rjf2 since 04/12/01 until 04/12/31

sea %macro in SAS-L where sender contains rjf2 since 05/01/01 until 05/02/01
sea %macro in SAS-L where sender contains rjf2 since 05/02/01 until 05/03/01
sea %macro in SAS-L where sender contains rjf2 since 05/03/01 until 05/04/01
sea %macro in SAS-L where sender contains rjf2 since 05/04/01 until 05/05/01
sea %macro in SAS-L where sender contains rjf2 since 05/05/01 until 05/06/01
sea %macro in SAS-L where sender contains rjf2 since 05/06/01 until 05/07/01
sea %macro in SAS-L where sender contains rjf2 since 05/07/01 until 05/08/01
sea %macro in SAS-L where sender contains rjf2 since 05/08/01 until 05/09/01
sea %macro in SAS-L where sender contains rjf2 since 05/09/01 until 05/10/01
sea %macro in SAS-L where sender contains rjf2 since 05/10/01 until 05/11/01
sea %macro in SAS-L where sender contains rjf2 since 05/11/01 until 05/12/01
sea %macro in SAS-L where sender contains rjf2 since 05/12/01 until 05/12/31

sea %macro in SAS-L where sender contains rjf2 since 06/01/01 until 06/02/01
sea %macro in SAS-L where sender contains rjf2 since 06/02/01 until 06/03/01
sea %macro in SAS-L where sender contains rjf2 since 06/03/01 until 06/04/01
sea %macro in SAS-L where sender contains rjf2 since 06/04/01 until 06/05/01
sea %macro in SAS-L where sender contains rjf2 since 06/05/01 until 06/06/01
sea %macro in SAS-L where sender contains rjf2 since 06/06/01 until 06/07/01
sea %macro in SAS-L where sender contains rjf2 since 06/07/01 until 06/08/01
sea %macro in SAS-L where sender contains rjf2 since 06/08/01 until 06/09/01
sea %macro in SAS-L where sender contains rjf2 since 06/09/01 until 06/10/01
sea %macro in SAS-L where sender contains rjf2 since 06/10/01 until 06/11/01
sea %macro in SAS-L where sender contains rjf2 since 06/11/01 until 06/12/01
sea %macro in SAS-L where sender contains rjf2 since 06/12/01 until 06/12/31

sea %macro in SAS-L where sender contains rjf2 since 07/01/01 until 07/02/01
sea %macro in SAS-L where sender contains rjf2 since 07/02/01 until 07/03/01
sea %macro in SAS-L where sender contains rjf2 since 07/03/01 until 07/04/01
sea %macro in SAS-L where sender contains rjf2 since 07/04/01 until 07/05/01
sea %macro in SAS-L where sender contains rjf2 since 07/05/01 until 07/06/01
sea %macro in SAS-L where sender contains rjf2 since 07/06/01 until 07/07/01
sea %macro in SAS-L where sender contains rjf2 since 07/07/01 until 07/08/01
sea %macro in SAS-L where sender contains rjf2 since 07/08/01 until 07/09/01
sea %macro in SAS-L where sender contains rjf2 since 07/09/01 until 07/10/01
sea %macro in SAS-L where sender contains rjf2 since 07/10/01 until 07/11/01
sea %macro in SAS-L where sender contains rjf2 since 07/11/01 until 07/12/01
sea %macro in SAS-L where sender contains rjf2 since 07/12/01 until 07/12/31

sea %macro in SAS-L where sender contains rjf2 since 08/01/01 until 08/02/01
sea %macro in SAS-L where sender contains rjf2 since 08/02/01 until 08/03/01
sea %macro in SAS-L where sender contains rjf2 since 08/03/01 until 08/04/01
sea %macro in SAS-L where sender contains rjf2 since 08/04/01 until 08/05/01
sea %macro in SAS-L where sender contains rjf2 since 08/05/01 until 08/06/01
sea %macro in SAS-L where sender contains rjf2 since 08/06/01 until 08/07/01
sea %macro in SAS-L where sender contains rjf2 since 08/07/01 until 08/08/01
sea %macro in SAS-L where sender contains rjf2 since 08/08/01 until 08/09/01
sea %macro in SAS-L where sender contains rjf2 since 08/09/01 until 08/10/01
sea %macro in SAS-L where sender contains rjf2 since 08/10/01 until 08/11/01
sea %macro in SAS-L where sender contains rjf2 since 08/11/01 until 08/12/01
sea %macro in SAS-L where sender contains rjf2 since 08/12/01 until 08/12/31

sea %macro in SAS-L where sender contains rjf2 since 09/01/01 until 09/02/01
sea %macro in SAS-L where sender contains rjf2 since 09/02/01 until 09/03/01
sea %macro in SAS-L where sender contains rjf2 since 09/03/01 until 09/04/01
sea %macro in SAS-L where sender contains rjf2 since 09/04/01 until 09/05/01
sea %macro in SAS-L where sender contains rjf2 since 09/05/01 until 09/06/01
sea %macro in SAS-L where sender contains rjf2 since 09/06/01 until 09/07/01
sea %macro in SAS-L where sender contains rjf2 since 09/07/01 until 09/08/01
sea %macro in SAS-L where sender contains rjf2 since 09/08/01 until 09/09/01
sea %macro in SAS-L where sender contains rjf2 since 09/09/01 until 09/10/01
sea %macro in SAS-L where sender contains rjf2 since 09/10/01 until 09/11/01
sea %macro in SAS-L where sender contains rjf2 since 09/11/01 until 09/12/01
sea %macro in SAS-L where sender contains rjf2 since 09/12/01 until 09/12/31

sea %macro in SAS-L where sender contains rjf2 since 10/01/01 until 10/02/01
sea %macro in SAS-L where sender contains rjf2 since 10/02/01 until 10/03/01
sea %macro in SAS-L where sender contains rjf2 since 10/03/01 until 10/04/01
sea %macro in SAS-L where sender contains rjf2 since 10/04/01 until 10/05/01
sea %macro in SAS-L where sender contains rjf2 since 10/05/01 until 10/06/01
sea %macro in SAS-L where sender contains rjf2 since 10/06/01 until 10/07/01
sea %macro in SAS-L where sender contains rjf2 since 10/07/01 until 10/08/01
sea %macro in SAS-L where sender contains rjf2 since 10/08/01 until 10/09/01
sea %macro in SAS-L where sender contains rjf2 since 10/09/01 until 10/10/01
sea %macro in SAS-L where sender contains rjf2 since 10/10/01 until 10/11/01
sea %macro in SAS-L where sender contains rjf2 since 10/11/01 until 10/12/01
sea %macro in SAS-L where sender contains rjf2 since 10/12/01 until 10/12/31

sea %macro in SAS-L where sender contains rjf2 since 11/01/01 until 11/02/01
sea %macro in SAS-L where sender contains rjf2 since 11/02/01 until 11/03/01
sea %macro in SAS-L where sender contains rjf2 since 11/03/01 until 11/04/01
sea %macro in SAS-L where sender contains rjf2 since 11/04/01 until 11/05/01
sea %macro in SAS-L where sender contains rjf2 since 11/05/01 until 11/06/01
sea %macro in SAS-L where sender contains rjf2 since 11/06/01 until 11/07/01
sea %macro in SAS-L where sender contains rjf2 since 11/07/01 until 11/08/01
sea %macro in SAS-L where sender contains rjf2 since 11/08/01 until 11/09/01
sea %macro in SAS-L where sender contains rjf2 since 11/09/01 until 11/10/01
sea %macro in SAS-L where sender contains rjf2 since 11/10/01 until 11/11/01
sea %macro in SAS-L where sender contains rjf2 since 11/11/01 until 11/12/01
sea %macro in SAS-L where sender contains rjf2 since 11/12/01 until 11/12/31

sea %macro in SAS-L where sender contains rjf2 since 12/01/01 until 12/02/01
sea %macro in SAS-L where sender contains rjf2 since 12/02/01 until 12/03/01
sea %macro in SAS-L where sender contains rjf2 since 12/03/01 until 12/04/01
sea %macro in SAS-L where sender contains rjf2 since 12/04/01 until 12/05/01
sea %macro in SAS-L where sender contains rjf2 since 12/05/01 until 12/06/01
sea %macro in SAS-L where sender contains rjf2 since 12/06/01 until 12/07/01
sea %macro in SAS-L where sender contains rjf2 since 12/07/01 until 12/08/01
sea %macro in SAS-L where sender contains rjf2 since 12/08/01 until 12/09/01
sea %macro in SAS-L where sender contains rjf2 since 12/09/01 until 12/10/01
sea %macro in SAS-L where sender contains rjf2 since 12/10/01 until 12/11/01
sea %macro in SAS-L where sender contains rjf2 since 12/11/01 until 12/12/01
sea %macro in SAS-L where sender contains rjf2 since 12/12/01 until 12/12/31

Weekly Logs

How much is there to search?

index SAS-L


File: "SAS-L FILELIST"
* Archive files for the SAS-L list at LISTSERV.UGA.EDU
* (weekly logs)
*
* filename      filetype        GET PUT size (bytes) date       time
* --------      --------        --- --- ------------ ---------- --------
 SAS-L         LOG9601B        LOG OWN          765 1999-06-04 14:21:11
 SAS-L         LOG9601D        LOG OWN        2,543 1999-06-04 14:21:13
 SAS-L         LOG9601E        LOG OWN       83,412 1999-06-04 14:21:14

The log files contain all posts to SAS-L for a seven-day week. The list above shows logs for three weeks: the second, fourth and fifth weeks of January, 1996.

*                         interval: 
* filename     LogYYMMw   ccYY-Mmm-dd -- dd      
* --------      --------  -----------------     
 SAS-L         LOG9601B   1996-Jan-08 -- 15     
 SAS-L         LOG9601D   1996-Jan-22 -- 28     
 SAS-L         LOG9601E   1996-Jan-29 -- 31     

To get the file with the entire weeks' posts use this command:

get SAS-L LOG9601B

Remember: in later years these logs are huge!

 SAS-L         LOG0804A        LOG OWN    1,918,237 2009-06-10 13:25:43
 SAS-L         LOG0804B        LOG OWN    1,682,141 2008-04-14 23:49:33
 SAS-L         LOG0804C        LOG OWN    1,288,855 2008-04-21 23:46:33
 SAS-L         LOG0804D        LOG OWN    2,142,131 2008-04-28 23:03:37
 SAS-L         LOG0804E        LOG OWN      413,380 2008-04-30 23:46:37

 SAS-L         LOG1101B        LOG OWN    8,285,670 2011-01-15 00:41:39

References

--Ronald_J._Fehd macro.maven == the radical programmer 11:15, 23 May 2012 (EDT)