As the first step in the decommissioning of sasCommunity.org the site has been converted to read-only mode.


Here are some tips for How to share your SAS knowledge with your professional network.


User:LainieH/sandbox6

From sasCommunity
Jump to: navigation, search
sasCommunity.org User Tip Category Posted By Submitted on Visits
Tips:Now You Can Use the IN Operator in a Macro [[Macro functions, Tip in Use]] Otterm1 May 02, 2015 4647
Tips:Almost automatic PROC REPORT code generator [[REPORT Procedure, Tip in Use]] Art297 Mar 09, 2015 3605
Tips:Check if a WHERE clause is valid [[%SYSFUNC Function, Best Practices, GETOPTION Function, Program Development, Tip in Use, WHERE Statement]] Donh Mar 03, 2015 3021
Tips:Removing License Alias [[SETINIT Procedure, Tip in Use]] Goladin Mar 01, 2015 3436
Tips:Forcing all Character Variables when Importing a CSV File [[IMPORT Procedure, Importing Data, Tip in Use]] ArtCarpenter Feb 19, 2015 2971
Tips:Making Macro Variables READONLY [[%GLOBAL Statement, %LOCAL Statement, Macro Language, Tip in Use]] ArtCarpenter Feb 10, 2015 3568
Tips:Using Multilabel Formats to Expand or Duplicate Data [[Data Structure and Management, FORMAT Procedure, SUMMARY Procedure, Tip in Use, UNIVARIATE Procedure, VAR Statement]] Donh Feb 05, 2015 2686
Tips:Creating an Ordered Subset using PROC RANK [[RANK Procedure, Tip in Use]] ArtCarpenter Feb 03, 2015 3902
Tips:Accessing Internet APIs from DS2 [[DS2 Procedure, Tip in Use]] MarkJordan Jan 18, 2015 2722
Tips:Macro Language Formatted Look-up [[%SYSFUNC Function, Macro Language, PUT Function, Table Lookup, Tip in Use]] ArtCarpenter Dec 16, 2014 2398
Tips:Would you like additional capabilities when exporting data to Excel? [[Excel, IMPORT Procedure, Macro Language, Macro Language Papers, Tip in Use, Utility]] Art297 Nov 28, 2014 3316
Tips:Execution Time Macro Variable Resolution [[Macro Language, SYMGET Function, Tip in Use]] ArtCarpenter Nov 27, 2014 2639
Tips:Splitting into one table can be faster [[SAS Data Integration Studio, Tip in Use]] Cameron Nov 15, 2014 3246
Tips:Using the ZIP engine to read zip files [[Base SAS, FILENAME Statement, Tip in Use]] Ozthegr8 Nov 13, 2014 2997
Tips:BETWEEN does mean between [[SQL Procedure, Tip in Use, WHERE Statement]] Donh Nov 07, 2014 2224
Tips:Determine Product Release Levels [[PRODUCT STATUS Procedure, SETINIT Procedure, Tip in Use]] Donh May 07, 2014 3260
Tips:Dynamic ALTLOG or LOG [[ALTLOG, Configuration File, Options, SAS LOG, Tip in Use]] Peter.Crawford Feb 10, 2014 3129
Tips:Explore config [[%SYSFUNC Function, Configuration File, GETOPTION Function, Tip in Use]] Peter.Crawford Feb 05, 2014 2492
Tips:Adding a date and time stamp message to the SAS Log [[%SYSFUNC Function, DATETIME Function, Tip in Use]] Lpweaver Feb 04, 2014 15880
Tips:Unriddle encoding in SAS Visual Analytics [[CONTENTS Procedure, COPY Procedure, Data Representation, Data Set Options, LIBNAME Statement, SAS Visual Analytics, Tip in Use]] Mhomes Jan 20, 2014 2279
Tips:Use PROC SQL to Create SAS Data sets from Excel files [[Excel, SQL Procedure, Tip in Use]] Rnmishra Aug 29, 2013 13214
Tips:Creating ZIP files with ODS [[Output Delivery System, Tip in Use, ZIP Files]] JackHamilton Jul 24, 2013 4126
Tips:Resolving a macro variable within single quotes [[%STR Function, Macro Language, Tip in Use]] Stfogleman Jun 06, 2013 15847
Tips:Getting Started with SAS and Hadoop [[Data Structure and Management, Hadoop, Tip in Use]] Gmbaker May 08, 2013 4901
Tips:Handy %PUT syntax for mvarName=text output [[%PUT Statement, Macro Language, Tip in Use]] Md4 May 08, 2013 5603
Tips:Reg Exp Substitution in Proc Format [[Tip in Use]] Chang y chung Apr 02, 2013 4168
Tips:%SASDIFF Differential File Comparison Macro [[File Comparison, IFC Function, Macro Language, Program Development, Tip in Use]] Rbettinger Mar 25, 2013 4453
Tips:Images as text - use Base 64 encoding [[HTML, Output Delivery System, SAS/IntrNet, SAS9 BI/EBI, Tip in Use]] Donh Jan 02, 2013 3888
Tips:Compile a Java program with PROC GROOVY [[GROOVY Procedure, Tip in Use]] JackHamilton Nov 27, 2012 7366
Tips:Timekeeping at User Group presentations [[Conferences, Presentations, Tip in Use]] Sraimi Nov 15, 2012 3564
Tips:Read Zipped Files Directly [[FILENAME Statement, Tip in Use, ZIP Files]] ArtCarpenter Oct 22, 2012 4184
Tips:Compress("") Returns a Zero-Length Character String [[COMPRESS Function, Expressions, Tip in Use]] Chang y chung Oct 05, 2012 3748
Tips:DATA Step Comparison Operators Are Non-Associative [[Expressions, Tip in Use]] Chang y chung Oct 04, 2012 4274
Tips:Sorting an Array in Descending Order [[Tip in Use]] Chang y chung Aug 17, 2012 9155
Tips:Using the SASMSG function for table lookup [[SASMSG Function, Table Lookup, Tip in Use]] Chang y chung Aug 02, 2012 6531
Tips:Setting Shortcuts for Code Snippet in EG [[Display Manager, SAS Enterprise Guide, Tip in Use]] Amitsonar Aug 02, 2012 5431
Tips:Displaying a time value as a duration [[FORMAT Procedure, PICTURE Statement, Tip in Use]] Donh Jun 11, 2012 7996
Tips:SAS can manage your temporary external files [[FILENAME Statement, Tip in Use]] Howles Jun 07, 2012 3842
Tips:Legend for Proc Univariate Using Annotate [[Annotate Facility, Tip in Use, UNIVARIATE Procedure]] AncaTilea May 29, 2012 6552
Tips:JMP can enhance Excel usage [[Excel, JMP Software, Tip in Use]] CharlieShipp Apr 27, 2012 5954
Tips:How to list global macro variables in alphabetical order [[SQL Tricks, Tip in Use]] Rjf2 Apr 25, 2012 3315
Tips:Between and Within Group Counters [[BY Statement, DATA Step, Tip in Use]] Msz03 Mar 03, 2012 7093
Tips:Determine the Location of the Executing Program [[Enhanced Editor, Environmental Variables, Tip in Use]] ArtCarpenter Jan 29, 2012 3911
Tips:Changing the Delimiter when Using ODS CSV [[Output Delivery System, Tip in Use]] Msz03 Jan 26, 2012 10696
Tips:Selecting a Random Sample of Observations [[Analytics and Modeling, SET Statement, Statistics, Tip in Use]] Donh Jan 25, 2012 9012
Tips:Calculating Exact Age with the YRDIF Function [[Tip in Use, YRDIF Function]] Msz03 Jan 22, 2012 10543
Tips:Using UPDATE to Collapse a Data Set [[Tip in Use, UPDATE Statement]] ArtCarpenter Jan 03, 2012 7149
Tips:Counting and miscounting occurrences using SQL [[SQL Procedure, Tip in Use]] Jsattler Nov 19, 2011 5374
Tips:Datasets DELETE is Case Sensitive in Excel - but SQL DROP isn't [[DATASETS Procedure, DELETE Statement, DROP Statement, LIBNAME Statement, SQL Procedure, Tip in Use]] Pchoate Nov 17, 2011 5505
Tips:Modifying SAS Explorer's "View in Excel" [[DM Statement, Display Manager, Excel, SAS Component Language, Tip in Use]] Pchoate Nov 07, 2011 6978
Tips:Text Indentation and Forced Linefeed (Carriage Return) with the ExcelXP Tagset [[EXCELXP Tagset, Output Delivery System, Tip in Use]] Otterm1 Nov 04, 2011 9818
Tips:Using REPLACE and REPEMPTY Together [[Options, Tip in Use]] ArtCarpenter Oct 13, 2011 6140
Tips:Tip Sheet for SAS/IML Language [[SAS/IML, Tip in Use]] RickWicklin Oct 10, 2011 4803
Tips:Using Date Prompts in Stored Procesess [[Prompts and Forms, SAS9 BI/EBI, Stored Process, Tip in Use]] Taanderud Oct 06, 2011 6434
Tips:Create an Informat from a User-Defined Function [[FCMP Procedure, Informats, Tip in Use]] Msz03 Sep 29, 2011 5459
Tips:Use CALL MISSING to Set a List of Variables to Missing [[MISSING Routine, Tip in Use]] ArtCarpenter Sep 26, 2011 12281
Tips:Remotely subset a large dataset [[LIBNAME Statement, PATHNAME Function, RSUBMIT Statement, SAS/CONNECT, Tip in Use]] Hejacobs Sep 23, 2011 6035
Tips:Where is TEMP [[Application Development, Environmental Variables, FILENAME Statement, LIBNAME Statement, Tip in Use, Windows]] Peter.Crawford Sep 23, 2011 8201
Tips:Use CATX and IFC to Build a Concatenated List of Treatments [[Base SAS, IFC Function, Tip in Use]] Otterm1 Aug 30, 2011 6622
Tips:INTNX function with Federal Fiscal Year [[Base SAS, Dates and Times, INTNX Function, Tip in Use]] TashaChapman Aug 29, 2011 10513
Tips:Use BYVAL to Write Better Titles [[Base SAS, Tip in Use]] Otterm1 Aug 26, 2011 11589
Tips:Strip Blanks from PROC SQL-Created Macro Variable Values [[Macro Language, SQL Procedure, Tip in Use]] Msz03 Aug 21, 2011 18320
Tips:PROC SQL Join Algorithms and the METHOD Option [[SQL Procedure, Tip in Use]] KirkLafler Aug 18, 2011 9407
Tips:Using formulas in Excel and actual values in HTML and PDF output [[EXCELXP Tagset, Excel, Output Delivery System, Tip in Use]] Donh Aug 16, 2011 6453
Tips:Tutorial Dialog in 2nd Base SAS Session [[Installation Deployment Configuration Support, Tip in Use]] Hawkeye1997 Aug 15, 2011 6283
Tips:Creating a flag avoiding the If ... Then Structure [[DATA Step, IF-THEN/ELSE Statement, IFN Function, MIN Function, Tip in Use]] Sacambro Aug 08, 2011 9256
Tips:Making any repeatable task a file related menu item [[Automation, Base SAS, Programming, Tip in Use]] Art297 Jun 07, 2011 5911
Tips:Two steps in one with Proc SQL – summarize and create macro variable [[Base SAS, Programming, SQL Procedure, Tip in Use]] Sunil Gupta Jun 01, 2011 7508
Tips:Calculate logarithm of any base [[Base SAS, LOG Function, Tip in Use]] Oloolo May 17, 2011 28466
Tips:Simulating Streaming Output in a Workspace Server [[Output Delivery System, SAS9 BI/EBI, Tip in Use]] Donh May 16, 2011 4891
Tips:Weighting in PROC CORR [[Base SAS, CORR Procedure, Tip in Use]] Goladin May 15, 2011 7039
Tips:Different sorting options for variable names with Proc CONTENTS [[Base SAS, CONTENTS Procedure, Ordering Information, Tip in Use]] Md4 May 13, 2011 9485
Tips:Use X Commands within a SAS Program to Issue Commands to Windows or MS-DOS [[Base SAS, Tip in Use, X Statement]] Otterm1 May 05, 2011 22554
Tips:Federal Fiscal Year Date Conversion [[Base SAS, Dates and Times, Tip in Use, YEAR Function]] TashaChapman May 05, 2011 7673
Tips:Use SAS DM Commands to Save and then Clear Your SAS Log [[Base SAS, DM Statement, Display Manager, Tip in Use]] Otterm1 May 05, 2011 36217
Tips:Use IS MISSING and IS NULL with Numeric or Character Variables [[Base SAS, Missing Values, Tip in Use]] Otterm1 May 05, 2011 51010
Tips:Use the CONTAINS Operator as an Alternative to the INDEX Function [[Base SAS, Tip in Use, WHERE Statement]] Otterm1 May 04, 2011 72298
Tips:Accessing multiple location through one library. [[Base SAS, LIBNAME Statement, Tip in Use]] Ayetullah May 04, 2011 6228
Tips:Use the BETWEEN-AND Operator to Search an Inclusive Range of Values [[Base SAS, Tip in Use, WHERE Statement]] Otterm1 May 04, 2011 46657
Tips:Implement Regularized Discriminant Analysis in SAS [[DISCRIM Procedure, Data Mining, Tip in Use]] Oloolo May 04, 2011 7366
Tips:Another Way to Use the SUBSTR Function [[Base SAS, SUBSTR Function, Tip in Use]] LindaJAdams May 04, 2011 5679
Tips:Implement Elastic Net Algorithm in SAS [[Analytics and Modeling, Data Mining, GLMSELECT Procedure, Tip in Use, Variable Selection]] Oloolo May 04, 2011 9040
Tips:Use the RESOLVE Function to Build a List into a Macro Variable [[Base SAS, Macro Language, RESOLVE Function, SQL Procedure, SYMPUT and SYMPUTX Routines, Tip in Use]] Otterm1 May 03, 2011 7988
Tips:Quick Check for Missing or Invalid Data Using Formats [[Base SAS, Data Cleansing, FORMAT Procedure, FORMAT Statement, FREQ Procedure, Tip in Use]] Donh May 03, 2011 9528
Tips:Use the SOURCE2 Option with %include to Get a Detailed Log [[%INCLUDE Statement, Base SAS, Options, Tip in Use]] Otterm1 May 03, 2011 13265
Tips:Create a function key to clear the log and output and return to the SAS program [[Base SAS, Programming, Tip in Use]] Otterm1 Apr 15, 2011 10767
Tips:Ctrl + / is a quick and easy way to comment out SAS code [[Base SAS, Programming, Tip in Use]] Otterm1 Apr 15, 2011 15747
Tips:Retaining Quotes in a Input statement [[Base SAS, DATA Step, Tip in Use]] Goladin Apr 13, 2011 6040
Tips:SPSS Importing Errors [[Base SAS, FORMAT Statement, IMPORT Procedure, Tip in Use]] Goladin Apr 12, 2011 5127
Tips:This Page Intentionally Left Blank [[REPORT Procedure, SAS9 BI/EBI, Tip in Use]] Donh Apr 11, 2011 5618
Tips:Cronbach's Alpha in SAS [[Base SAS, CORR Procedure, Tip in Use]] Goladin Apr 11, 2011 9917
Tips:Specifying a list of variables [[Base SAS, Programming, Tip in Use]] Pskoo Apr 11, 2011 6862
Tips:Index to SAS-L Chance to Make SAS-L History Posts [[SAS-L, Tip in Use, User Groups]] Donh Apr 08, 2011 5893
Tips:The SAS Supervisor [[DATA Step, SAS Supervisor, Tip in Use]] Donh Apr 08, 2011 6226
Tips:Find the LAST Non-Missing Value in a List of Variables [[COALESCEC Function, Tip in Use]] Msz03 Apr 05, 2011 10450
Tips:Waiting for LOCKed datasets. [[LIBNAME Statement, Tip in Use]] Gnilrets Apr 01, 2011 10452
Tips:Automatically assign Unix environment variables to SAS macro variables [[Base SAS, Environment Variables, Programming, SAS9 BI/EBI, SAS Web Report Studio, SYMPUT and SYMPUTX Routines, Tip in Use]] Darrelcusey Mar 31, 2011 10835
Tips:Conversion from Excel Date to SAS Date [[Excel, Tip in Use]] Pskoo Mar 28, 2011 35874
Tips:Dataset COMPRESS option compresses the size of the SAS dataset [[COMPRESS Option, Data Set Options, Options, Tip in Use]] Dilipcl Mar 21, 2011 6363
Tips:Web mining with SAS %TMFILTER macro [[Macro Language, SAS Enterprise Miner, Tip in Use]] Goladin Mar 10, 2011 6474
Tips:Replace Missing Character Values with a Character String [[COALESCEC Function, Tip in Use]] Msz03 Mar 01, 2011 9059
Tips:Derivation of Mathematical Constants in SAS [[Base SAS, CONSTANT Function, Functions and CALL Routines, Tip in Use]] Goladin Feb 11, 2011 8323
Tips:Calculating Distance on the map [[Base SAS, Tip in Use]] Goladin Feb 11, 2011 6248
Tips:Rank of a matrix [[GINV Function, ROUND Function, SAS/IML, TRACE Function, Tip in Use]] Goladin Jan 19, 2011 8360
Tips:Interleaving [[BY Statement, SET Statement, Tip in Use]] Chang y chung Jan 19, 2011 7212
Tips:Multiple Dataset Options [[Base SAS, CONTENTS Procedure, Options, Tip in Use]] Chang y chung Jan 18, 2011 11926
Tips:Double negatives to normalize a boolean value [[Data Representation, Functions and CALL Routines, Tip in Use]] Chang y chung Jan 17, 2011 8914
Tips:LIBREF function return value [[%SYSFUNC Function, FEXIST Function, FILEEXIST Function, FILEREF Function, LIBREF Function, Tip in Use]] Chang y chung Jan 17, 2011 13872
Tips:You can use Google to search sascommunity.org for tips and articles [[Tip in Use]] Art297 Jan 12, 2011 5656
Tips:Saving some or all of your keyboard macros/abbreviations in one step [[Base SAS, Enhanced Editor, Tip in Use]] Art297 Jan 12, 2011 10611
Tips:Check if a variable exists in a dataset [[%SYSFUNC Function, Macro Language, Tip in Use]] Avallee Jan 07, 2011 39725
Tips:Check if a directory exists [[%SYSFUNC Function, FEXIST Function, FILENAME Function, Macro Language, Tip in Use]] Avallee Jan 07, 2011 21127
Tips:Music in SAS [[Base SAS, SOUND Routine, Tip in Use]] Goladin Dec 21, 2010 8653
Tips:INFORMAT Modifiers on the INPUT Statement [[INPUT Statement, Informats, Tip in Use]] ArtCarpenter Dec 19, 2010 5392
Tips:Adding URL Links to a Web Report Studio Report [[Programming, SAS Web Report Studio, Tip in Use]] Angelahall Dec 14, 2010 18993
Tips:Aligning with a Put Function [[PUT Function, PUT Statement, Tip in Use]] Goladin Nov 19, 2010 25802
Tips:CCC in Proc Cluster [[CLUSTER Procedure, Tip in Use]] Goladin Nov 18, 2010 13053
Tips:Summarize data in a rolling window [[Base SAS, FORMAT Procedure, Formats, Tip in Use]] Oloolo Oct 29, 2010 8381
Tips:Highlighting report cells with no data [[FORMAT Procedure, Output Delivery System, REPORT Procedure, Tip in Use]] Donh Oct 13, 2010 7332
Tips:Voice Mining with Text Mining [[Tip in Use]] Goladin Oct 05, 2010 6679
Tips:Using the FLYOVER style attribute to display long text strings [[Output Delivery System, REPORT Procedure, Tip in Use]] Donh Sep 04, 2010 10306
Tips:Using SPANROWS To Repeat Values Across Pages [[REPORT Procedure, Tip in Use]] ArtCarpenter Sep 02, 2010 9137
Tips:Image files that SAS can't load into pdf or rtf documents [[ODS RTF Statement, Output Delivery System, SAS/GRAPH, Tip in Use]] Donh Sep 01, 2010 7646
Tips:Unexpected NOTE becomes ERROR [[Options, Tip in Use]] Peter.Crawford Aug 31, 2010 5938
Tips:Saving Your Work with the SAS Display Manager Autosave Feature [[Display Manager, Tip in Use]] MMMMIIIIKKKKEEEE Aug 17, 2010 6307
Tips:Dynamically Insert and Append SAS Format and Macro Libraries within a SAS Program [[Formats, Options, Tip in Use]] MMMMIIIIKKKKEEEE Aug 17, 2010 6501
Tips:Access Local SAS Directories in SAS/Connect with the INHERITLIB Option [[SAS/CONNECT, Tip in Use]] MMMMIIIIKKKKEEEE Aug 17, 2010 8998
Tips:Easy way to input date/times that contain an imbeded space [[Formats, INPUT Statement, Informats, Tip in Use]] Art297 Aug 15, 2010 5364
Tips:Using the NOQUOTELENMAX Option [[Best Practices, OPTIONS Statement, Output Delivery System, Tip in Use]] Donh Aug 06, 2010 12219
Tips:Corrected Sum of Squares in PROC NLIN [[NLIN Procedure, Tip in Use]] Goladin Aug 04, 2010 9456
Tips:ABS Function [[ABS Function, Tip in Use]] Ayetullah Jul 09, 2010 10848
Tips:Renaming Variables with suffix [[RENAME Statement, Tip in Use]] Goladin Jun 16, 2010 7850
Tips:Using the RENAME Function to Rename SAS Data Sets, Catalogs, OS Files, and Directories [[%SYSFUNC Function, RENAME Function, Tip in Use]] MMMMIIIIKKKKEEEE Jun 16, 2010 14448
Tips:Plotting Residuals in Linear Regression [[REG Procedure, Tip in Use]] Goladin May 22, 2010 10994
Tips:Cochran-Mantel-Haenszel Test using PROC FREQ [[FREQ Procedure, Tip in Use]] Goladin May 22, 2010 10303
Tips:McNemar Statistics [[FREQ Procedure, Statistical Computing, Tip in Use]] Goladin May 21, 2010 7420
Tips:Declaring Macro variables on remote host [[Tip in Use]] Goladin May 21, 2010 4683
Tips:Sorting a sorted data [[SORT Procedure, Tip in Use]] Goladin May 21, 2010 9727
Tips:Deduping using Proc Sort [[SORT Procedure, Tip in Use]] Goladin May 21, 2010 26086
Tips:K Nearest Neighbor in SAS [[Tip in Use]] Oloolo May 13, 2010 8200
Tips:Getting Model Statistics into SAS data set from PROC LOGISTIC [[LOGISTIC Procedure, ODS OUTPUT Statement, Statistical Computing, Tip in Use]] Goladin Apr 26, 2010 15225
Tips:Retrieving the First Character [[Base SAS, FIRST Function, Functions and CALL Routines, Programming, SUBSTR Function, Tip in Use]] ArtCarpenter Apr 20, 2010 27485
Tips:Top level directory in web-based STP list [[SAS9 BI/EBI, Tip in Use]] Nwelke Apr 20, 2010 7052
Tips:Getting % sign in PROC TABULATE [[SAS Code, TABULATE Procedure, Tip in Use]] Goladin Apr 19, 2010 9088
Tips:Durbin Watson Test in Regression [[REG Procedure, Tip in Use]] Goladin Apr 17, 2010 15351
Tips:Marketing Research Macros [[Macro functions, Tip in Use]] Goladin Apr 04, 2010 8016
Tips:How to Display values for every row of an Order or Group Report-Item in Proc Report without using an Alias [[REPORT Procedure, Tip in Use]] Phil am27 Mar 29, 2010 13840
Tips:Starting SAS pointing to a directory of interest [[Tip in Use]] Paige Miller Mar 19, 2010 8710
Tips:Finding the Position of the First Non-Digit in a String [[Tip in Use]] Pskoo Mar 08, 2010 16479
Tips:Embedding the Flash Version of JMP's Bubble Plot into MS PowerPoint 2007 [[JMP Software, Tip in Use]] LauraRyan Mar 04, 2010 9915
Tips:Clearing a library of data [[Tip in Use]] Goladin Mar 03, 2010 9731
Tips:Assign libraries to a path relative to current folder [[Tip in Use]] Oloolo Feb 25, 2010 10427
Tips:Setting Data using Data list [[MERGE Statement, SET Statement, Tip in Use]] Goladin Feb 23, 2010 11436
Tips:Box Cox Transformation [[TRANSREG Procedure, Tip in Use]] Goladin Feb 18, 2010 13563
Tips:Changing the default prompt on login from SAS/Connect [[SAS/CONNECT, Tip in Use]] Webminer Jan 27, 2010 12073
Tips:Detected Characters For the ANY and NOT Functions [[Functions and CALL Routines, Tip in Use]] ArtCarpenter Jan 19, 2010 11684
Tips:Using IFC to Conditionally Execute Global Statements [[IFC Function, Tip in Use]] ArtCarpenter Jan 19, 2010 12513
Tips:Using PROC RANK to Generate Percentiles [[Base SAS, RANK Procedure, Tip in Use]] ArtCarpenter Jan 19, 2010 22753
Tips:Using the SYSSCP and SYSSCPL Macro Variables [[Macro Language, Platform Specifics, Tip in Use]] ArtCarpenter Jan 19, 2010 12691
Tips:Order of SAS Operator Evaluation [[Programming, Tip in Use]] ArtCarpenter Jan 19, 2010 12502
Tips:Modifying PDF Bookmark Text [[Macro Language, SQL Procedure, Tip in Use]] ArtCarpenter Jan 18, 2010 12359
Tips:Using the PATHNAME Function [[%SYSFUNC Function, Macro Language, PATHNAME Function, Tip in Use]] ArtCarpenter Jan 18, 2010 14483
Tips:Using The Asterisk to Comment Macro Code [[Macro Language, Tip in Use]] ArtCarpenter Jan 18, 2010 13287
Tips:Represent numerics as strings with no loss of precision [[Data Representation, Tip in Use]] Howles Jan 11, 2010 11822
Tips:Using the sasdemo account in BI/EBI projects [[SAS9 BI/EBI, Tip in Use]] Donh Jan 08, 2010 14645
Tips:SAS Global Forum Idea Request [[SAS Global Forum 2010, Tip in Use]] LainieH Jan 05, 2010 13067
Tips:Comprehensive list of statistics produced by SAS [[Statistical Computing, Tip in Use]] Howles Jan 03, 2010 12985
Tips:A free SAS getting-started guide [[Tip in Use]] Howles Dec 29, 2009 16327
Tips:Encrypting script in JMP [[JMP Software, Tip in Use]] Goladin Dec 27, 2009 14210
Tips:Diagnosing authentication issues on Unix [[SAS9 BI/EBI, Tip in Use, Unix]] Donh Dec 24, 2009 14650
Tips:Creating Candlestick Chart in SAS [[Tip in Use]] Goladin Dec 23, 2009 23846
Tips:Handling Transcoding Error [[Data Set Options, Tip in Use]] Goladin Dec 23, 2009 18537
Tips:Use Your SAS Programming Skills in SAS Enterprise Guide [[SAS Enterprise Guide, Tip in Use]] Chris Dec 22, 2009 16127
Tips:Creating your own datetime format [[FORMAT Procedure, Formats, Tip in Use]] Altons Nov 25, 2009 25664
Tips:Creating relative links in ODS HTML [[HTML, Output Delivery System, Tip in Use]] Goladin Nov 24, 2009 17498
Tips:Local format using NLS and Locale [[Formats, Tip in Use]] Goladin Nov 21, 2009 17332
Tips:Determining the number of observations in a SAS data set efficiently [[Tip in Use]] Altons Nov 17, 2009 14225
Tips:Changing your titles in ODS Content Page [[Output Delivery System, Tip in Use]] Goladin Nov 13, 2009 15035
Tips:Handling trailing and leading blanks in SAS Macro Variable [[Tip in Use]] Goladin Nov 12, 2009 23084
Tips:Protecting your data with a password [[Tip in Use]] Goladin Nov 09, 2009 12824
Tips:Program run time [[Tip in Use]] Rmatthews Nov 02, 2009 33154
Tips:Using the &SYSUSERID Macro Variable [[Macro Language, Tip in Use]] ArtCarpenter Oct 26, 2009 13549
Tips:Accurately Calculate AUC in SAS [[Statistical Computing, Tip in Use]] Oloolo Oct 23, 2009 35030
Tips:SASware Ballot Voting Now Open [[Tip in Use]] Statprof Oct 13, 2009 14173
Tips:Enterprise Guide - Turning Off the ODS output file creation by code [[Output Delivery System, SAS Code, Tip in Use]] Altons Oct 05, 2009 28975
Tips:Don't mess up your Data - Option OUTSORT in PROC SURVEYSELECT [[Tip in Use]] Altons Oct 05, 2009 14439
Tips:User Specific Autoexecs in Enterprise Guide [[SAS Enterprise Guide, Tip in Use]] Donh Oct 01, 2009 30836
Tips:Enterprise Guide Resources [[SAS Enterprise Guide, Tip in Use]] Donh Sep 30, 2009 15562
Tips:Editor Abbreviations in SAS Enterprise Guide [[Abbreviations and Macros, Enhanced Editor, SAS Enterprise Guide, Tip in Use]] Chris Sep 30, 2009 19629
Tips:SVD in SAS [[PRINCOMP Procedure, Statistical Computing, Tip in Use]] Oloolo Sep 30, 2009 18699
Tips:Tweak PROC FASTCLUS for closest match lookup [[Tip in Use]] Oloolo Sep 30, 2009 22335
Tips:Use The HASH Object to Sort Your Data [[Hash Tables, Tip in Use]] ArtCarpenter Sep 18, 2009 19441
Tips:Easy Way to Get All Variable Names From a Dataset [[SQL Dictionary.Tables, Tip in Use]] Spm Sep 09, 2009 40192
Tips:Start date: 1st Jan, 1960 [[Dates and Times, Tip in Use]] Goladin Sep 07, 2009 19901
Tips:Removing a library reference using the libname function [[Functions and CALL Routines, Tip in Use]] Goladin Sep 04, 2009 21738
Tips:Automatically Separating Data into Excel Sheets [[Tip in Use]] ArtCarpenter Aug 24, 2009 14110
Tips:Page X of Y [[Tip in Use]] Haworthl Aug 20, 2009 13391
Tips:How to add SAS Code on the WIKI [[Tip in Use]] LainieH Aug 18, 2009 11850
Tips:Adding superscripted footnote references to a report [[FORMAT Procedure, Formats, Output Delivery System, Tip in Use]] Haworthl Aug 07, 2009 16452
Tips:ODS Tip Sheets [[Output Delivery System, Tip in Use]] Haworthl Jul 28, 2009 16071
Tips:Jump-start PROC REPORT [[REPORT Procedure, Tip in Use]] Howles Jul 20, 2009 21287
Tips:Static Dates in RTF Output [[ODS RTF Statement, Tip in Use]] Haworthl Jul 20, 2009 15264
Tips:Appending datasets efficiently [[DATASETS Procedure, Tip in Use]] LindaJAdams Jul 16, 2009 17377
Tips:Using JMP with base SAS [[JMP Software, SAS9 BI/EBI, Tip in Use]] Goladin Jun 20, 2009 13901
Tips:Anyspace function: search for the carriage return [[Functions and CALL Routines, Tip in Use]] Goladin Jun 17, 2009 14053
Tips:Checking for a data set [[Macro functions, Tip in Use]] Goladin Jun 17, 2009 13630
Tips:Pound sign using picture format [[FORMAT Procedure, Formats, Tip in Use]] Goladin Jun 17, 2009 17134
Tips:Counting Words in a List [[Macro functions, Tip in Use]] ArtCarpenter Jun 11, 2009 22628
Tips:Using the LOCK Statement for Exclusive Use of a SAS Data Set [[LOCK Statement, SAS/SHARE, Tip in Use]] MMMMIIIIKKKKEEEE Jun 05, 2009 16480
Tips:How to see Recent Changes [[Tip in Use, WikiTips]] NancyWilson Jun 03, 2009 14208
Tips:Detecting outliers using boxplot [[Tip in Use]] Goladin Jun 02, 2009 16591
Tips:PROC DATASETS Efficiencies [[DATASETS Procedure, Formats, Tip in Use]] LindaJAdams Jun 02, 2009 14540
Tips:Using NOTE, WARNING, ERROR in Your Program's Generated Messages [[Best Practices, OPTIONS Statement, Tip in Use]] Donh Jun 02, 2009 17586
Tips:The SAS XML Mapper [[Tip in Use]] LarryHoyle Jun 02, 2009 14816
Tips:Recent changes [[Tip in Use, WikiTips]] NancyWilson May 29, 2009 12285
Tips:Include Debugging Code in Your Programs [[Tip in Use]] Donh May 29, 2009 13466
Tips:Gini Coefficient in SAS [[Data Mining, Statistics, Tip in Use]] Goladin May 29, 2009 27069
Tips:Use the HOLIDAY Function to Compute the Date of a US or Canadian Holiday [[HOLIDAY Function, Tip in Use]] MMMMIIIIKKKKEEEE May 29, 2009 16688
Tips:Use the OBS= Option to Save Time While Testing [[Testing, Tip in Use]] Stefaniegreay May 21, 2009 13344
Tips:Changing FONT color [[Tip in Use, WikiTips]] NancyWilson May 21, 2009 14055
Tips:Utilize SAS Audit Files to Keep Track of SAS Data Set Updates [[DATASETS Procedure, Data Structure and Management, Tip in Use]] MMMMIIIIKKKKEEEE May 21, 2009 13780
Tips:Validate the format of ICD-9 codes [[ICD, Regular Expressions, Tip in Use]] Rpardee May 20, 2009 13607
Tips:Setting Default Values for Macro Parameters [[%SYSFUNC Function, COALESCEC Function, Macro Language, Tip in Use]] Donh May 20, 2009 18792
Tips:Updating an Excel Table the Excel Libname [[LIBNAME Statement, Tip in Use]] Pchoate May 13, 2009 14052
Tips:Changing the SAS Web Report Studio Banner [[SAS9 BI/EBI, SAS Management Console, SAS Web Report Studio, Tip in Use]] Angelahall May 11, 2009 15752
Tips:Easy Way to Research SAS System Requirements Across Computer Platforms and Operating Systems [[Installation Deployment Configuration Support, Tip in Use]] MMMMIIIIKKKKEEEE May 08, 2009 14847
Tips:Give a Presentation at a Local SAS Users Group [[Tip in Use]] MMMMIIIIKKKKEEEE May 07, 2009 13029
Tips:SAS Qualification Tools Ensure SAS is Installed and Operating Correctly [[Installation Deployment Configuration Support, Tip in Use]] MMMMIIIIKKKKEEEE Apr 29, 2009 15306
Tips:I want to hear the sound of SOUNDEX [[Functions and CALL Routines, Statements, Tip in Use]] Goladin Apr 28, 2009 13855
Tips:Do not use SAS random numbers for encryption [[Statistical Computing, Tip in Use]] Goladin Apr 28, 2009 12574
Tips:Getting all data and fields information in a directory [[CONTENTS Procedure, Tip in Use]] Goladin Apr 28, 2009 13456
Tips:Creating a SAS Data Set with Another Operating Systems Data Representation [[Tip in Use]] MMMMIIIIKKKKEEEE Apr 28, 2009 12023
Tips:Bit XOR function in SAS [[BXOR Function, Programming, Tip in Use]] Goladin Apr 26, 2009 17391
Tips:Alternating Logistic Regression [[Analytics and Modeling, GENMOD Procedure, Tip in Use]] Goladin Apr 26, 2009 18083
Tips:Suppressing the Batch Dialog when running SAS in Batch Mode [[Platform Specifics, Tip in Use, User Interfaces]] Donh Apr 25, 2009 13664
Tips:Changing or Suppressing the Default SAS Splash Screen on Windows [[Platform Specifics, Tip in Use, User Interfaces]] Donh Apr 24, 2009 13477
Tips:Sleep Function Under Unix and Linux [[Linux, SLEEP Function, Tip in Use]] Kevin77711 Apr 23, 2009 18667
Tips:Detailed Directory Listing from PROC CONTENTS [[CONTENTS Procedure, Tip in Use]] MMMMIIIIKKKKEEEE Apr 22, 2009 28597
Tips:Heteroskedasticity in Proc Reg [[Analytics and Modeling, REG Procedure, Tip in Use]] Goladin Apr 21, 2009 18134
Tips:Sample SAS Data Sets for Developing SAS Programs [[CONTENTS Procedure, Tip in Use]] MMMMIIIIKKKKEEEE Apr 20, 2009 18967
Tips:Using the SAS Stored Process Web Application: Securing Your SAS Stored Processes by Limiting Debugging Options [[SAS9 BI/EBI, Tip in Use]] Donh Apr 19, 2009 14251
Tips:Using the SAS Stored Process Web Application: Changing the Default/Welcome Page [[SAS9 BI/EBI, Tip in Use]] Donh Apr 19, 2009 16596
Tips:Using ?? in the INPUT Statement [[INPUT Statement, Statements, Tip in Use]] ArtCarpenter Apr 19, 2009 14165
Tips:SecretSQL: Keeping Your Passwords Safe [[Tip in Use]] ArtCarpenter Apr 11, 2009 12398
Tips:Use The SAS Sample Program Libraries [[Tip in Use]] MMMMIIIIKKKKEEEE Apr 10, 2009 12908
Tips:Create a PROC IMPORT or PROC EXPORT Template Program for Ease of Use [[Base SAS, EXPORT Procedure, IMPORT Procedure, Tip in Use]] MMMMIIIIKKKKEEEE Apr 10, 2009 29984
Tips:SUM Statement and the Implied SUM Function [[SUM Function, SUM Statement, Tip in Use]] ArtCarpenter Apr 08, 2009 16640
Tips:Schedule SAS Programs with SYSTASK and WAITFOR [[Tip in Use]] MMMMIIIIKKKKEEEE Apr 07, 2009 20015
Tips:Use the TRANSLATE function to validate data [[TRANSLATE Function, Tip in Use]] Howles Apr 06, 2009 13841
Tips:Great Reference for SAS Functions, Informats, and Formats [[Formats, Functions and CALL Routines, Informats, Tip in Use]] MMMMIIIIKKKKEEEE Apr 06, 2009 15340
Tips:Adding a User in SAS Management Console [[SAS Management Console, Tip in Use]] Angelahall Apr 03, 2009 21849
Tips:Create a CSV file without column names/headers in row 1 [[EXPORT Procedure, Tip in Use]] Donh Apr 03, 2009 15705
Tips:Create An Ad-hoc Measure on an OLAP Cube, without the OLAP Administrator [[OLAP, SAS Enterprise Guide, Tip in Use]] Angelahall Mar 30, 2009 15057
Tips:Have you tried the MISSING function yet? [[MISSING Function, Tip in Use]] Ron-Cody Mar 29, 2009 14365
Tips:Make DATA your friend [[Tip in Use]] Peter.Crawford Mar 23, 2009 15364
Tips:Exploiting the Metadata in SAS Dictionary Tables and Views [[Base SAS, Data Structure and Management, SQL Procedure, Tip in Use]] MMMMIIIIKKKKEEEE Mar 16, 2009 15937
Tips:Convert MISSING to 0 [[Statements, Tip in Use]] Tge123 Mar 13, 2009 40309
Tips:Searching User Group Papers [[Tip in Use]] LittleBirdie Mar 11, 2009 13965
Tips:Use SYSRPUT to determine whether a SAS/Connect session failed [[SAS/CONNECT, Tip in Use]] Kd6ttl Mar 10, 2009 13380
Tips:Using PATHNAME to Retrieve a Physical Path [[PATHNAME Function, Tip in Use]] ArtCarpenter Mar 10, 2009 22858
Tips:Automatically opening Excel workbooks created by the ExcelXP tagset [[EXCELXP Tagset, Excel, Output Delivery System, Tip in Use]] JackHamilton Mar 08, 2009 19969
Tips:Useful Enhanced Editor macros [[Tip in Use]] John Hendrickx Mar 06, 2009 15229
Tips:Where also [[Tip in Use, WHERE Statement]] Donh Mar 05, 2009 16636
Tips:Simple space saving [[Tip in Use]] Peter.Crawford Mar 03, 2009 14590
Tips:Using GETOPTION to Save and Restore Options [[%SYSFUNC Function, GETOPTION Function, Tip in Use]] Donh Mar 01, 2009 15264
Tips:Generating random number seed from the system clock [[Statistics, Tip in Use]] Djnordlund Feb 26, 2009 16697
Tips:PROC TRANSPOSE, using the IDLABEL to label the variable created [[TRANSPOSE Procedure, Tip in Use]] Aywconsulting Feb 23, 2009 34402
Tips:Deploying a Custom Add-In Task [[SAS Add-In for Microsoft Office, SAS Enterprise Guide, Tip in Use]] Donh Feb 23, 2009 15661
Tips:How to ask a statistics question [[Tip in Use]] Plf515 Feb 23, 2009 15965
Tips:Effect coding and class variables in PROC LOGISTIC [[Analytics and Modeling, GLM Procedure, LOGISTIC Procedure, Tip in Use]] Plf515 Feb 22, 2009 19836
Tips:Predicting events and not non-events in PROC LOGISTIC [[Analytics and Modeling, LOGISTIC Procedure, Tip in Use]] Plf515 Feb 22, 2009 15857
Tips:Variable selection in regression [[Analytics and Modeling, GLMSELECT Procedure, Tip in Use]] Plf515 Feb 22, 2009 15287
Tips:Tip Sheets on support.sas.com [[Output Delivery System, Tip in Use]] LittleBirdie Feb 12, 2009 17900
Tips:Get the Metadata Path for the Currently Running Stored Process [[Tip in Use]] Donh Feb 11, 2009 16052
Tips:Spanning Headers in REPORT [[Tip in Use]] ArtCarpenter Feb 09, 2009 14391
Tips:Pointing to Multiple Report Items On One Define Statement [[REPORT Procedure, Tip in Use]] ArtCarpenter Feb 09, 2009 15646
Tips:Stacking REPORT Headers [[REPORT Procedure, Tip in Use]] ArtCarpenter Feb 06, 2009 15021
Tips:Setting Browser Title with the stpbegin macro [[Output Delivery System, SAS9 BI/EBI, Tip in Use]] Donh Jan 30, 2009 16124
Tips:Embedding Links in a Title [[Statements, Tip in Use]] ArtCarpenter Dec 17, 2008 17108
Tips:Editor Abbreviations [[Enhanced Editor, Tip in Use]] ArtCarpenter Dec 17, 2008 16898
Tips:Enhanced Editor Shortcuts [[Enhanced Editor, Tip in Use]] ArtCarpenter Dec 17, 2008 15793
Tips:Missing Values in Classification Variables [[Options, Tip in Use]] ArtCarpenter Dec 17, 2008 16328
Tips:Calculating Ages [[INTCK Function, Tip in Use]] Howles Dec 06, 2008 17964
Tips:Using &SQLOBS to report on empty sets [[Tip in Use]] Howles Nov 19, 2008 14490
Tips:Map insets [[GMAP Procedure, SAS/GRAPH, Tip in Use]] Howles Nov 19, 2008 15999
Tips:Inserting rows in a specified order (SQL) [[SQL Procedure, Tip in Use]] Howles Nov 19, 2008 16930
Tips:Inheriting Column Attributes (SQL) [[SQL Procedure, Tip in Use]] Howles Nov 19, 2008 15224
Tips:Measure Who is Using SAS and What Products They are Using with RTRACE [[Tip in Use]] MMMMIIIIKKKKEEEE Nov 15, 2008 16807
Tips:Read Files From Web Sites Into Your SAS Program [[FILENAME Statement, Tip in Use]] MMMMIIIIKKKKEEEE Nov 15, 2008 25298
Tips:Measure SAS Performance with the LOGPARSE SAS Macro [[Performance, Tip in Use]] MMMMIIIIKKKKEEEE Nov 15, 2008 16683
Tips:SAS/Connect Can Upload More Than Just SAS Data Sets [[SAS/CONNECT, Tip in Use, UPLOAD Procedure]] MMMMIIIIKKKKEEEE Nov 15, 2008 16439
Tips:Determining the Setting of Groups of SAS Options [[Tip in Use]] MMMMIIIIKKKKEEEE Nov 15, 2008 17480
Tips:Limiting File Download Size Using SAS/Connect [[SAS/CONNECT, Tip in Use]] MMMMIIIIKKKKEEEE Nov 15, 2008 15940
Tips:Estimate the Size of a Future SAS Data Set [[Tip in Use]] MMMMIIIIKKKKEEEE Nov 15, 2008 18300
Tips:Obtain the Amount of Computer Memory Available to SAS [[Tip in Use]] MMMMIIIIKKKKEEEE Nov 15, 2008 20978
Tips:Get Process ID (PID) of SAS Tasks Running on Unix and Linux [[Linux, Tip in Use]] MMMMIIIIKKKKEEEE Nov 15, 2008 15994
Tips:Caution with the TRANWRD Function! [[Tip in Use]] MMMMIIIIKKKKEEEE Nov 15, 2008 17989
Tips:Using the SAS V9 CALL SYMPUTX Routine [[SYMPUT and SYMPUTX Routines, Tip in Use]] MMMMIIIIKKKKEEEE Nov 15, 2008 19852
Tips:Reading SAS Data Sets FTP-ed From Other Operating Systems [[CIMPORT Procedure, CPORT Procedure, SAS/CONNECT, Tip in Use]] MMMMIIIIKKKKEEEE Nov 15, 2008 18208
Tips:Estimating the Size of New SAS Data Sets [[Tip in Use]] MMMMIIIIKKKKEEEE Nov 15, 2008 16413
Tips:Determining Nature of SAS Files via their File Extensions [[Tip in Use]] MMMMIIIIKKKKEEEE Nov 15, 2008 16570
Tips:Determining the setting of a particular SAS option [[OPTIONS Procedure, Tip in Use]] MMMMIIIIKKKKEEEE Nov 15, 2008 17743
Tips:Using MSGLEVEL = I [[OPTIONS Statement, Tip in Use]] MMMMIIIIKKKKEEEE Nov 15, 2008 18662
Tips:Increasing the Size of an Index Page [[OPTIONS Statement, Tip in Use]] MMMMIIIIKKKKEEEE Nov 15, 2008 18307
Tips:Finding Multiple Occurrences [[FREQ Procedure, Tip in Use]] Rjf2 Nov 14, 2008 15159
Tips:Searching Options [[SQL Procedure, Tip in Use]] Rjf2 Nov 14, 2008 14260
Tip of the Day:November 6 [[Tip in Use]] NancyWilson Nov 13, 2008 14713
Tip of the Day:September 11 [[Tip in Use]] NancyWilson Nov 13, 2008 11220
Tip of the Day:September 9 [[Tip in Use]] NancyWilson Nov 13, 2008 11430
Tip of the Day:September 8 [[Tip in Use]] NancyWilson Nov 13, 2008 11570
Tip of the Day:July 9 [[Tip in Use]] NancyWilson Nov 13, 2008 11836
Tip of the Day:July 8 [[Tip in Use]] NancyWilson Nov 13, 2008 11012
Tip of the Day:July 7 [[Tip in Use]] NancyWilson Nov 13, 2008 10916
Tip of the Day:July 6 [[Tip in Use]] NancyWilson Nov 13, 2008 10217
Tip of the Day:July 3 [[Tip in Use]] NancyWilson Nov 13, 2008 9643
Tip of the Day:June 24 [[Tip in Use]] NancyWilson Nov 13, 2008 9581
Tip of the Day:June 22 [[Tip in Use]] NancyWilson Nov 13, 2008 10195
Tips:Multiple Reports Per Page [[Output Delivery System, Tip in Use]] Donh Nov 13, 2008 15452
Tips:SAS TableEditor TagSet [[Excel, HTML, Output Delivery System, Tip in Use]] Donh Nov 13, 2008 17836
Tips:Importing a Style Sheet [[ODS PDF Statement, ODS RTF Statement, ODS Styles, Output Delivery System, TEMPLATE Procedure, Tip in Use]] Donh Nov 13, 2008 18421
Tips:Drawing Lines above/below the Output [[Output Delivery System, Tip in Use]] Donh Nov 13, 2008 15698
Tip of the Day:April 3 [[Output Delivery System, SAS/IntrNet, SAS9 BI/EBI, Tip in Use]] NancyWilson Nov 13, 2008 10858
Tip of the Day:March 16 [[Tip in Use]] NancyWilson Nov 13, 2008 12813
Tip of the Day:March 9 [[Tip in Use]] NancyWilson Nov 13, 2008 13454
Tip of the Day:March 7 [[Data Structure and Management, Tip in Use]] NancyWilson Nov 13, 2008 13539
Tip of the Day:February 11 [[Excel, JMP Software, Tip in Use]] NancyWilson Nov 13, 2008 13978
Tip of the Day:January 12 [[%SYSFUNC Function, DATETIME Function, Tip in Use]] NancyWilson Nov 13, 2008 14993
Tip of the Day:December 22 [[Tip in Use]] NancyWilson Nov 13, 2008 17051
Tips:Controlling text height in titles and footnotes [[Output Delivery System, SAS/GRAPH, Tip in Use]] Donh Nov 13, 2008 14778
Tips:Specifying directory paths that work on Window and Unix [[Best Practices, FILENAME Statement, LIBNAME Statement, Tip in Use]] Donh Nov 13, 2008 15131
Tips:Change decimal places in PROC FREQ [[FREQ Procedure, TEMPLATE Procedure, Tip in Use]] Howles Nov 10, 2008 27018