Index to SAS-L Chance to Make SAS-L History Posts

From sasCommunity
Jump to: navigation, search

Contents

Abstract

In 2006, Michael Raithel challenged SAS-L members to become part of a thread that was intended to be the longest running SAS-L thread ever. The goal of the thread, other than to become the longest running thread, was to get people to share tips they thought would be useful to other SAS users.

Well, the thread did indeed become the longest running one ever on SAS-L, and is still ongoing, but was criticized because it was just a bunch of posts without any inherent organization.

The goal of this page is to provide a way for people to discover those posts and categorize them as desired. The index is downloadable as a spreadsheet to make it easy for you to save and modify it as desired. The sheet contains the same information as shown in the table, below, including links to all of the posts that actually contained tips, brief summaries of every post, the posting dates, and our crude attempt to assign each post to a category.

Download Index

If you want to download a copy of the spreadsheet, itself, click on the following link: File:Chance to make sas-l history.xls.

Link to Paper

Click here to read the paper that was presented at the 2011 SAS Global Forum regarding this index.

Powerpoint Presentation

To view the presentation, click on the menu's far left item, then PgDn through the presentation.

Index

Link Date Subject Category

219909

2-Nov-2006 You can increase the page size of SAS indexes when they are first created by using the IBUFSIZE option? Useful to know

219910

3-Nov-2006 Title statement options that were originally supported only in SAS/GRAPH to support changing the height and justification of title and footnote text are now supported in many ODS destinations? Useful to know

219911

3-Nov-2006 As an aid to figuring out what your created data sets are about when a few days have elapsed, consider using data set labels Data Set Labels

219914

3-Nov-2006 Options details ; (in your autoesec.sas) or -details in your config (sasv9.cfg) file will display dataset labels (and n-rows and n-cols) in the details display of a SAS Explorer window Useful to know

219915

3-Nov-2006 In DATA step code, the CONTINUE statement stops processing only the current DO loop. In SCL code, the CONTINUE statement stops processing the current DO loop or DO group Useful to know

219918

3-Nov-2006 Current values in Proc REPORT compute blocks can be examined by using CALL EXECUTE Call Execute

219920

3-Nov-2006 Did you know you can use dataset options in proc sql? SQL

219922

3-Nov-2006 Always use Call SymputX over Call Symput when you can Functions

219924

3-Nov-2006 You can refer to a list of variables, either if they are consecutive in PDV or named consecutively such as VAR1, VAR2...., VAR25 by using a dash Useful to know

219926

3-Nov-2006 Missing is less than everything. Missing Values

219932

3-Nov-2006 You can set up one of your function keys to automatically clear the log and output windows? Shortcuts/Abbreviations

219935

3-Nov-2006 You can dramatically speed up many SAS programs by launching SAS with the -memlib option Useful to know

219947

3-Nov-2006 In the enhanced editor, highlight a procedure name, a function name, or a keyword and press the F1 key to gain quick access to the documentation pertaining (or relevant) to that topic. Shortcuts/Abbreviations

219949

3-Nov-2006 To comment out a large chunk of code, just highlight the lines you want to comment and then press CTRL /. To UNcomment the code, highlight the lines of code you want to UNcomment and then press SHIFT CTRL /. Comments

219950

3-Nov-2006 You can pass macro variables to and from a remote session Useful to know

219954

3-Nov-2006 To comment out a block of code, make it a macro. Comments

219966

3-Nov-2006 You can print just the first N observations in a dataset Useful to know

219971

3-Nov-2006 The verify() function makes it easier to examine character variables for non-numeric characters before using the input statement Functions

219976

3-Nov-2006 You can save paper using the formdlim option Useful to know

219977

3-Nov-2006 "Run cancel;" compiles a datastep for syntax check but does not execute it. Useful to know

219977

3-Nov-2006 If you highlight some lines (or your program with ctrl-a) then "ctrl-shift-w" trims all the unwanted whitespace from the ends of your lines. Shortcuts/Abbreviations

219977

3-Nov-2006 Learn what the colon operator can do for you Operators

219983

3-Nov-2006 Variable Lists Variable Ranges

219988

3-Nov-2006 You can use variable lists in SQL data set options SQL

219993

3-Nov-2006 You can use the postMessage command to display messages via a message box Useful to know

219996

3-Nov-2006 In UNIX you can reference an environment variable directly in a libname statement Environment Variables

220000

3-Nov-2006 You can easily take a quick and dirty random sample of records from a data step or almost any procedure by simply using the where statement combined with the ranui function Useful to know

220006

3-Nov-2006 How many of us have - at some point - used SUBSTR() and accidentally fed it a starting position or length, with tragic results? SUBSTRN() doesn't object. If you give it a length that is not a positive number (say, a pattern match that failed), you just get a zero-length string as your result. If you give it a non-positive starting position, it acts as though you gave it a start of 1 Functions

220010

3-Nov-2006 In Windoze you can also reference an environment variable directly in a libname statement: the prefix to a Win environment variable is the bang or exclamation point: libname mydir "!MYWORK"; Environment Variables

220013

3-Nov-2006 One of the few times I think a data step drop statement is handy and should be used over a data step drop option is when you want define two data sets in on data step and drop the same variable(s) from both data sets Options

220025

3-Nov-2006 Nifty way to read in multiple files Input

220028

3-Nov-2006 Little "flatten" jewel... it keeps the last non-missing value in each column by the by group Data Manipulation

220041

3-Nov-2006 Windows directory paths will support either / or \ Useful to know

220048

3-Nov-2006 The unix '.' notation for the current directory and '..' for the parent directory will also work in Win OSes Useful to know

220052

3-Nov-2006 Want to save some file space and decrease your I/O significantly? Store dates in four byte numeric columns. Useful to know

220053

3-Nov-2006 Did you know that SAS comes with games? Trivia

220055

3-Nov-2006 And did you know that there are other SAS games out there? Games

220058

3-Nov-2006 Do something in all datasets in a lib (like droppping one variable from each dataset) Data Manipulation

220067

4-Nov-2006 You can set the coordinates for the dependent variable when using proc gmap by creating some dummy records Graphs and Maps

220068

4-Nov-2006 In Windows, you can use Window's shortcuts to organize your directories so that you can access them directly by pointing and clicking Shortcuts/Abbreviations

220095

4-Nov-2006 You can use proc sql with dictionary.columns to create a macro variable you can use to rename columns Useful to know

220097

4-Nov-2006 Lex Jansen keeps up a page where one can easily search and read all of the SAS National User's Conference paper submissions since 1995? Reference

220101

4-Nov-2006 You can get almost any SAS question answered by posting it to SAS-L? Useful to know

220102

4-Nov-2006 The SAS Data Step's ability to create multiple target tables in a single pass of the source tables has big advantages over any SQL-only tool for ETL type tasks Useful to know

220107

5-Nov-2006 Base SAS contains a method that can be used to help one remember all of the intricacies of various SAS procs so that you always aren't forced to pull up the SAS documentaion Shortcuts/Abbreviations

220109

5-Nov-2006 You can quickly assign dummy treatment groups when programming against blinded data with: trtnum = mod(usubjid, &nrx) 1; where &nrx contains the number of treatment arms in the study Useful to know

220132

5-Nov-2006 Using Guessing Rows to get proc import to scan enough records Useful to know

220154

5-Nov-2006 Using the colon operator in a variable list Operators

220139

6-Nov-2006 Configuration options: papersize, orientation and sasinitialfolder Configuration

220165

6-Nov-2006 DI Studio suports the multiple output dataset data step with both the pre-packaged "Data Transform" called "SAS Splitter" and the Transformation Generator wizard. Output

220172

6-Nov-2006 SCL-like functions are available within SAS/Base Functions

220187

6-Nov-2006 On windows, one may find the games via the dropdowns Solutions/Accessories/Games Games

220188

6-Nov-2006 One useful set of documentation that may be easily overlooked is the SAS Companion for (insert your operating system) Useful to know

220190

6-Nov-2006 As unix is case-sensitive, to be used as a libref, an environment variable must be in uppercase Environment Variables

220203

6-Nov-2006 The MSGLEVEL=I option prints additional SAS INFO messages related to index usage, merge processing, sort utilities, and CEDA usage, into your SAS log Options

220222

6-Nov-2006 By using the SOURCE and FROM arguments rather than the TO and FROM arguments one can neatly shuffle any characters based on position rather than the character values Functions

220225

6-Nov-2006 Advantages of running in batch mode: easier to reproduce your results, promotes reuse of code and promotes deliberation Batch vs. Interactive

220236

6-Nov-2006 For a whole lot of tips, read "In the Know...SAS Tips & Techniques from Around the Globe" by Phil Mason Reference

220271

6-Nov-2006 We should start a wiki .. hmm .. what should we call it? sascommunity.org? Critiques

220280

7-Nov-2006 The DEFAULT option in proc format's value definition gives you a substring of a variable without creating a new one Formats

220282

7-Nov-2006 Using SAS/Access products for a SAS library leaves the SAS explorer details window fairly empty, but it's still there! Use the statement: options details; Useful to know

220290

7-Nov-2006 Another way to get a substring of a variable without creating a new one is to specify an explicit length for the $CHAR format when associating it with the variable of interest Formats

220309

7-Nov-2006 The DM command is extraordinary for doing things when instructed by you accordingly Shortcuts/Abbreviations

220321

7-Nov-2006 More things you can do with display manager System

220337

7-Nov-2006 Using different FORMAT lengths can make a format do double duty Formats

220428

8-Nov-2006 Create a shortcut for SAS Shortcuts/Abbreviations

220479

8-Nov-2006 Entering dm "out;clear;log;clear;" will clear log and output window when it given in the command line Shortcuts/Abbreviations

220788

13-Nov-2006 Filename Clipboard File Engines

220804

13-Nov-2006 There is a facility almost missing from the enhanced editor that appears on the old pgm editor run menu: submit clipboard Useful to know

220815

13-Nov-2006 Under Unix(at least for AIX) for the Program Editor, SAS assigns "submit" to the "End" key by default Shortcuts/Abbreviations

220825

13-Nov-2006 Determining the setting of a SAS option without having to print out all of the SAS options Options

220828

13-Nov-2006 Even more SAS options can be seen if you submit: Proc Options Internal ; Run ; Options

220839

13-Nov-2006 You can use the %sysfunc macro with the getoption function to access the value of a single option Useful to know

220850

14-Nov-2006 Clipboards can even be accessed with SAS 8 Engines

220862

14-Nov-2006 The KEYWORD argument to the GETOPTION function can be used to return the option's value in a form suitable for subsequent use in an OPTIONS statement Options

220880

14-Nov-2006 Obtaining related system options: proc options Group= SASFILES;run; Options

220881

14-Nov-2006 Getting and using environment variables Environment Variables

220915

14-Nov-2006 You can make parts of a regex case (in)sensitive Functions

220925

14-Nov-2006 How to retrieve ALL environment variables Environment Variables

220932

14-Nov-2006 Where to find the list processing support macro Macros

220987

14-Nov-2006 Some important things to know about regular expressions Regular Expressions

220998

14-Nov-2006 SASZIPAM and SOCKET and filename engines Undocumented

220973

15-Nov-2006 The ~ modifier in put statement enables you to specify a format that the PUT statement uses to write the variable value Modifiers

221689

20-Nov-2006 REVERSE function can be very useful and also a lot of fun to use Functions

221693

21-Nov-2006 When the SCAN function is passed a negative argument, the scanning goes right to left Functions

221904

22-Nov-2006 You need to be a little careful when using the \w ("word") character class in regular expressions Useful to know

221908

22-Nov-2006 A suggestion regarding: You need to be a little careful when using the \w ("word") character class in regular expressions Regular Expressions

222004

24-Nov-2006 There exists a SAS oriented "communications platform" for those who prefer to communicate in German Useful to know

222247

28-Nov-2006 A quick way to extract every nth record from a large dataset Data Manipulation

222428

29-Nov-2006 Sampling methods Sampling

222477

30-Nov-2006 There is a SAS add-in for Microsoft Office Useful to know

222557

30-Nov-2006 Determining the nature of SAS files when viewing them on your operating system Useful to know

222708

3-Dec-2006 It often makes sense to use all three dimensions (page, row, and column) in a PROC TABULATE TABLE statement Procedures

225513

9-Jan-2007 You can estimate the size of SAS V9 data sets and indexes Useful to know

225959

12-Jan-2007 You can use simple point and click techniques to easily copy SAS files to Excel spreadsheets and that you don't need SAS/Access for PC files to do it Useful to know

225968

13-Jan-2007 You can read SAS data sets that were FTP-ed from other operating systems and are in still in a different data representation than that of your host computer Useful to know

226078

15-Jan-2007 There are at least three ways to deal with the "Output window full" message Useful to know

227053

25-Jan-2007 An undocumented proc: proc delete Undocumented

227078

26-Jan-2007 Newer way of deleting files: proc datasets Procedures

227079

26-Jan-2007 SQL way to delete files SQL

227094

26-Jan-2007 proc sortt Useful to know

227096

26-Jan-2007 Using wildcards with proc datasets Useful to know

227107

26-Jan-2007 You can't delete a view with proc delete Useful to know

227172

26-Jan-2007 SortH will sort both Numeric or Character Arrays Useful to know

227175

26-Jan-2007 Some useful but unfamiliar functions Functions

227176

26-Jan-2007 Catc Functions

227214

28-Jan-2007 Increase the upper limit for LRECL under Windows Options

227517

31-Jan-2007 Mark, copy, paste and delete columns of text in the Enhanced editor, log and output windows Shortcuts/Abbreviations

227632

31-Jan-2007 Using the force option in proc sort Options

230184

12-Mar-2007 The SAS V9 CALL SYMPUTX routine can save you keystrokes and lead to leaner, cleaner SAS programs Functions

230192

14-Mar-2007 SymputX also allows one to specify a third option which allows you to specify if the macro variable to be created should be Global or Local Functions

230393

16-Mar-2007 You can use SAS to build desired banners to hang for any occassion Undocumented

230445

19-Mar-2007 Not only will SYMPUTX() trim a character string before writing it to a macro variable, it will convert a number to a trimmed string with no message to the log Functions

230451

19-Mar-2007 Use NOOVP rather than OVP option Warnings

230796

22-Mar-2007 Proc datasets runs faster than proc delete for large files Useful to know

230883

23-Mar-2007 If one is using the SAS Windows editor, the name of the file is displayed at the top left corner of the screen to the right side of the SAS logo. If the name has an asterisk appended to it, the file has been modified since it was last saved Useful to know

231487

29-Mar-2007 Fetching a program name and its path from a DM session

231507

29-Mar-2007 &SYSPROCESSNAME contains the name of the currently running BATCH program in Unix Environment Variables

231603

30-Mar-2007 The TRANWRD function has a hidden gotcha Gotchas

231636

30-Mar-2007 The length limitation is different depending on how you submit your code Useful to know

232003

4-Apr-2007 You can improve the performance of using count(distinct xxxx) in proc sql Useful to know

233991

25-Apr-2007 You can subset obs using Proc Format Formats

234057

25-Apr-2007 Improving on: you can subset obs using Proc Format Formats

234170

26-Apr-2007 You can modify the CSV Tagset such that you get single quotes around numeric and character values, and, for a single column of data, add a comma to make it easier to copy/paste into a SQL Server Query WHERE clause Useful to know

234180

26-Apr-2007 There is an undocumented stack= option to the data statement, which lets you arbitrarily set the allowed depth of the link-return call (documented in 9.2) Undocumented (documented in 9.2)

234244

27-Apr-2007 You can use &SYSJOBID to get the Process ID (PID) of SAS tasks running on UNIX and Linux servers Functions

238239

11-Jun-2007 Various keyboard shortcuts Shortcuts/Abbreviations

238718

15-Jun-2007 When you have two are more SAS (Enhanced Editors ) opened and you need to go from one other use Ctrl Tab Shortcuts/Abbreviations

238725

15-Jun-2007 Another useful key combo Shortcuts/Abbreviations

238739

15-Jun-2007 Even more useful key combs Shortcuts/Abbreviations

238740

15-Jun-2007 Acronym finder Trivia

239572

25-Jun-2007 you can easily obtain the amount of computer memory available to SAS Useful to know

243569

14-Aug-2007 You can use CALL SOUND to have SAS beep you when a job is done Useful to know

243581

14-Aug-2007 Beethoven's 5th symphony Trivia

249911

9-Nov-2007 You can use the INFILE statement with the DATALINES statement Useful to know

251801

7-Dec-2007 Using varnum option in the Proc contents would� arrange the variables in the ascending Order in the Output only not the in the Output dataset Options

253132

28-Dec-2007 You can estimate the future size of a SAS data set with my handy SIZE_THE_DATA SAS program Useful to know

253160

28-Dec-2007 When navigating windows in SAS interactively, the Backspace takes you up one level in many places Shortcuts/Abbreviations

254816

23-Jan-2008 It is possible to exceed Proc Report line size limitation of 256 characters, as well as the variable width limit of 64. Procedures

255768

4-Feb-2008 There is a SAS option, since ver 8.2, called: ignoredoseof Useful to know

255769

5-Feb-2008 Some sql joins force a Cartesian product to be developed that can turn a simple join into a process that can take 250 times longer to compute than it has to take SQL

255904

6-Feb-2008 SAS may use a variable's length to process a WHERE statement Statements

256195

9-Feb-2008 Using the excel libname one can easily get around how SAS reads mixed characters Useful to know

256784

17-Feb-2008 sascommunity.org now exists Useful to know

260983

4-Apr-2008 Getting excel to recognize exported dates Dates

262328

18-Apr-2008 You know you can supress NOTES and even ERRORS, but you can't supress WARNINGS Useful to know

265546

4-Jun-2008 You can apply a WHERE statement (or WHERE data set option) to PROC DOWNLOAD Useful to know

265554

4-Jun-2008 An automating program that does data aggregation, puts it in a spreadsheet and sends it back in an email Automation

265579

4-Jun-2008 Creating macro variables with proc sql Macro Variables

265604

4-Jun-2008 Creating macro variables with proc sql Refined Macro Variables

265611

5-Jun-2008 Creating macro variables with proc transreg Macro Variables

265646

5-Jun-2008 Creating macro variables with data step Macro Variables

265753

6-Jun-2008 Displaying options associated with a specific "group" Options

265754

6-Jun-2008 You can format a date with slashes by using mmddyyS8 Formats

265757

6-Jun-2008 More about displaying options associated with a specific "group" Options

266015

9-Jun-2008 The datastep IF-THEN-ELSE statements have roughly equivalent CASE expressions in the SELECT statement in SQL Selection Logic

266044

10-Jun-2008 In the header of all my code I invoke %EliStartTimer; and then after each logical section of the processing I include %EliLapsedTimer Performance

266056

10-Jun-2008 More about elapsed time System

266072

10-Jun-2008 Fullstimer Options

266253

10-Jun-2008 Using SAS/CONNECT you can PROC UPLOAD/DOWNLOAD more than just SAS data sets Useful to know

266164

11-Jun-2008 Using the Like operator Operators

266798

18-Jun-2008 You can read files from web sites directly into your SAS programs Useful to know

266807

19-Jun-2008 You can read files from web sites directly into your SAS programs: Sample Code Useful to know

266808

19-Jun-2008 If you do find the need to read an html page and want to avoid all the <markup> (and you happen to be on a unix box) you can use the lynx command in a pipe to return only the rendered text Pipes

266846

19-Jun-2008 Spacing between levels of a filename doesn't have to hurt Language

266875

19-Jun-2008 Spacing between levels of a filename can hurt Language

268700

12-Jul-2008 You can copy and paste from an Excel worksheet, into SAS Useful to know

270959

7-Aug-2008 An interesting reminder for time formats Formats

270981

8-Aug-2008 Month, day and year are similarly truncated with shortend date formats Formats

273287

5-Sep-2008 In where clasues, <> also means not-equal Operators

273288

5-Sep-2008 Caution about <> Operators

273300

5-Sep-2008 If statement gotchas Gotchas

274419

17-Sep-2008 You can add up to eight commands to the Tools pull-down menu in the main SAS window Shortcuts/Abbreviations

274776

22-Sep-2008 If you type help, followed by a proc name (and press enter) in the command line that help for that proc will instantly appear Shortcuts/Abbreviations

274779

22-Sep-2008 Recording keyboard macros can speed up coding time greatly. just press record macro Shortcuts/Abbreviations

275008

24-Sep-2008 There is a macro available to disaggregate aggregated data so that it can be used in most procs Useful to know

276349

14-Oct-2008 Various ways of specifying comments Comments

276422

14-Oct-2008 You can write PROCEDURE in lieu of PROC Useful to know

276428

14-Oct-2008 More ways of specifying comments Comments

282013

5-Jan-2009 Picture formats can manipulate date values Formats

284246

4-Feb-2009 A missing value can/will affect the accuracy of your computations Missing Values

284313

5-Feb-2009 More about missing data Missing Values

288993

31-Mar-2009 You can use Proc Datasets to delete datasets with common letters or numbers in their names Useful to know

289108

1-Apr-2009 If you license SAS/OR and have SAS 9.2, you now have access to the way-cool product called SAS Simulation Studio SAS/OR

289404

6-Apr-2009 You can find an amazing quick-reference to SAS Functions, Informats, and Formats in TS486 Formats

289407

6-Apr-2009 More about TS486 Functions

289459

7-Apr-2009 You can launch SAS programs from within a SAS program and suspend execution of the launching SAS program until the launched SAS programs complete their execution Useful to know

289515

7-Apr-2009 Toolbar buttons Shortcuts/Abbreviations

289773

9-Apr-2009 Creating templates Templates

289782

10-Apr-2009 Creating abbreviations Shortcuts/Abbreviations

289830

10-Apr-2009 SAS provides sample program libraries for many of the SAS sub-products (SAS/Access, SAS/Connect, SAS/Graph, etc.) that you license Code examples

290085

14-Apr-2009 Autocall command macros Macros

290444

19-Apr-2009 DOW and Double-DOW can be extended to Tripple-DOW or even more complex configurations Programming

290479

20-Apr-2009 Base SAS comes with sample SAS data sets that you can use to develop and perfect your SAS programs Sample Data

290484

20-Apr-2009 Another place to get sample data Sample Data

290629

21-Apr-2009 The SAS example datasets Mike Zdeb so helpfully mentions can be yours to download and store with a little SAS filename FTP code Sample Data

290773

22-Apr-2009 You can get a detailed directory listing of the files in a SAS data library without having to print all of the detail information for each and every SAS data set in it Useful to know

291127

27-Apr-2009 You can create a SAS data set in another operating system's internal data representation format Useful to know

291336

29-Apr-2009 You can verify that you installed SAS correctly and that it is operational using two free tools supplied by the SAS Institute Useful to know

291996

8-May-2009 A lot of your questions concerning SAS system requirements can be answered by simply accessing the SAS Institute's SAS System Requirements web pages SAS Documentation

292986

21-May-2009 You can direct SAS to keep an audit trail of all of the updates made to a SAS data set Useful to know

293530

29-May-2009 The new HOLIDAY function allows you to determine the date of major US and Canadian holidays Functions

293608

30-May-2009 Did you know EVERYTHING that the author mentions in this presentation? Reference

293974

5-Jun-2009 You can use the LOCK statement to prevent other SAS programs from either reading from or writing to a SAS data set Useful to know

301382

2-Oct-2009 The CONSTANT function can help you to determine how large a number you can store in a numeric variable with a given number of bytes Functions

301810

9-Oct-2009 You can delete all SAS files in a given SAS data library _EXCEPT_ those that you specifically list in the SAVE statement in PROC DATASETS Useful to know

302687

21-Oct-2009 You can prevent your permanent SAS data sets from being overwritten in a SAS program by using the NOREPLACE system option Useful to know

302700

21-Oct-2009 For protecting production data it is also very useful to use the ACCESS=READONLY option on your LIBNAME statement Useful to know

310756

7-Mar-2010 You can use scan within a proc sort statement Useful to know

310904

9-Mar-2010 You can run SAS from an iphone Useful to know

312025

26-Mar-2010 PDF files created using the Output Delivery System in SAS 9.2 end up being much larger than those created by the same code executed in SAS 9.1.3 Useful to know

312185

30-Mar-2010 You can build a date range format with PROC FORMAT andSAS Date Constants Formats

313020

19-Apr-2010 You can order your contents listing by either position (default) or varnum Useful to know

315199

11-Jun-2010 You can rename SAS data sets, SAS catalog entries, as well as OS directories and files in directory-based operating systems from inside of a SAS program Useful to know

315210

11-Jun-2010 There is a sure-fire cure for "PROC DATASETS phobia Useful to know

315326

17-Jun-2010 Using SAS/CONNECT, you can have a program running on a server "reach back" and process data directly from a SAS data set on your client machine Useful to know

315710

30-Jun-2010 You can now dynamically insert and append SAS format libraries and macro libraries to your list of available SAS libraries Useful to know

315791

1-Jul-2010 GuessingRows: When reading data from an Excel file using either PROC IMPORT or when using the Excel engine on a LIBNAME statement, a determination of whether a variable is character or numeric will be based on information presented in the first N rows of the sheet being read. By default, N=8. Useful to know

315805

2-Jul-2010 You can programatically change the number of rows that GUESSINGROWS will use Useful to know

315836

2-Jul-2010 Changes made to the %sysfunc function in SAS9.2 Functions

315840

3-Jul-2010 Changes made to the %sysfunc function in SAS9.2 - work around Functions

317012

4-Aug-2010 Autosave: you can avoid the loss of SAS for Windows programs due to sudden power outages Useful to know

317237

11-Aug-2010 With PROC SQL you can use the SEPARATED BY clause when generating macro variables, to trim the trailing spaces from a value even when you are pulling only one value Useful to know

317261

11-Aug-2010 If one has date/time data that includes a space between the date and time, you can read it directly with the anydtdtm informat as long as you put an ampersand, after the variable in the input statement, to read past the space Informats

317593

21-Aug-2010 Any external macro variable can be modified and it so will be returned to the caller Macro Variables

318029

1-Sep-2010 There is an option/data step option that causes notes to be treated as errors Useful to know

318050

2-Sep-2010 Silencing known problems when using notetoerr option Useful to know

318065

3-Sep-2010 Did you know about proc spell? Undocumented

318072

3-Sep-2010 Using proc spell: adding to dictionary Undocumented

318075

3-Sep-2010 There is a sasCommunity.org page on proc spell Undocumented

318102

6-Sep-2010 Specialized searches in Google Useful to know

318552

19-Sep-2010 You can help other users by cross-posting Useful to know

319470

8-Oct-2010 You can use "backwards" variable lists when referencing data Useful to know

319707

14-Oct-2010 Showing member details in Explorer Useful to know

319717

15-Oct-2010 You can combine the infile options FTP and FILEVAR Useful to know

322055

16-Dec-2010 You can use proc format to achieve a label containing a superscript Useful to know

322089

17-Dec-2010 Another way to achieve a label containing a superscript Useful to know

322493

30-Dec-2010 A reason why you might want to include informat statements Useful to know

323078

12-Jan-2011 You can export all of your keyboard shorts/abbreviations in one action Useful to know

323462

20-Jan-2011 Sometimes proc summary can provide the easiest way to transpose data Transpose

323471

20-Jan-2011 You can get SAS to send a text message to your cell phone Useful to know

323481

20-Jan-2011 Old Style Macros are still accepted Macros

323493

21-Jan-2011 How to decode garbled sas-l posts Useful to know

323552

21-Jan-2011 Splitting a file using a hash Splitting Files

325699

15-Mar-2011 Did you know about the SAS Wakeup function? Functions

325956

21-Mar-2011 Writing a list of library attributes using libname list option Useful to know

325962

21-Mar-2011 The definitive paper on SASAUTOS Macros

326171

27-Mar-2011 All SUGI and SGF papers now available from Lex Jansen's website Useful to know

326237

29-Mar-2011 In Windows _TO as a prefix hides file from SAS Explorer Useful to know

327413

29-Apr-2011 Prescedence of datastep options is in lexicographical (alphabetical) order Useful to know

327503

3-May-2011 Tip about this index Useful to know

327599

5-May-2011 Obtain detailed report about installed components System Management

327609

5-May-2011 Obtain detailed info about how a query is optimized SQL

327677

6-May-2011 You can get a dictionary of dictionaries with Proc SQL Useful to know

327772

12-May-2011 You can use the FILEVAR option to conditionally create/update a file Useful to know

327881

16-May-2011 You can use PROC SQL to create new, empty SAS datasets that have the same attributes as an existing one Useful to know

327904

16-May-2011 You can also use a datastep to create new, empty SAS datasets that have the same attributes as an existing one Useful to know

328670

08-Jun-2011 You can use system command to open other Window's programs from within SAS Useful to know

328798

13-Jun-2011 You can execute native Database Management System (DBMS) commands via PROC SQL SQL

329334

29-Jun-2011 You can use the same variable name in several IN= dataset options in the same datastep Dataset Options

329720

14-Jul-2011 As of 9.2 there is a system option to increase the allowable size of one's log Useful to know

329937

20-Jul-2011 As of 9.2 you can refer to a list of files in a datastep set or merge statement Useful to know

331271

06-Sep-2011 You can use the intervalds option to define holidays and custom date intervals Useful to know

331451

12-Sep-2011 You can use abbreviations/macros to do things that many thought required tools like Ultraedit Shortcuts/Abbreviations

332471

14-Oct-2011 Various keys and clickable icons one can use to clear their editor window Shortcuts/Abbreviations

334037

05-Dec-2011 sasCommunity.org Tips of the Day are also readily available Useful to know

336261

08-Mar-2012 You can compute ranks with proc sql Useful to know

338650

23-May-2012 Shift-Right Click lets you copy full file path Shortcuts/Abbreviations

338655

23-May-2012 Copy full file path for XP or Win7 or even copy full UNC path Shortcuts/Abbreviations

338663

23-May-2012 Free tools for Windows Useful to know

338672

24-May-2012 Problem searching SAS-L using Google Chrome Useful to know

338675

24-May-2012 Capture screen in Windows Shortcuts/Abbreviations

338676

24-May-2012 Capture active window in Windows Shortcuts/Abbreviations