64 search results

Page 1 out of 7 Pages

• DATA Step: How do I add a blank line in PROC REPORT positionally i.e. Insert a blank
  Answer: *** First add a 'dummy' column with the row numbers *** ; data class ;   set sashelp.class (keep = name sex age) ;     row ...
• DATA Step: How do I add comments to code in SAS?
  Answer: /**********************************************************************************/ /*** ...
• Macros: How can I search for a phrase in all SAS files in a directory and
  Answer: /************************************************************************************/ /*** ...
• Macros: How can I create a macro variable containing a quoted list from a dataset?
  Answer: Using PROC SQL and the INTO clause along with the SEPARATED BY option and a compound separator creating quoted lists is easy. Using the PROC SQL ...
• DATA Step: How do I change the order of columns in a dataset?
  Answer: Changing the order of columns in an output dataset requires the use of a compile-time-only statement appearing before the SET statement to order the columns in ...
• PROC SQL: Can I create an Excel Workbook containing the metadata for all datasets in a library?
  Answer: The metadata for datasets can be obtained using the DATASETS procedure with he CONTENTS statement and directing the output to a dataset.  Use ODS TAGSETS.EXCELXP ...
• DATA Step: How does the 'SOUNDS LIKE' (=*) operator work in a WHERE statement?
  Answer: The SOUNDS LIKE (=*) operator uses a soundex algorithm to simplify a word for comparison purposes.  The algorithm is predicated on English however, and is less ...
• PROC SQL: Do PROC SQL Joins and DATA Step Merges produce the same results?
  Answer: Be careful when combining datasets horizontally when there are columns with the same names in the contribution tables, but not specified in the join condition ...
• Macros: When are leading and trailing blanks removed from macro variables?
  Answer: Macro variables created with %LET have leading and trailing blanks removed. %let num = 1234 ...
• DATA Step: Should variable names be treated as case-sensitive?
  Answer: Generally it is not necessary to worry about case when typing code and referring to variable names, dataset and library names etc., however a consistent ...

The most popular searches are:

• all except (2336728x)
• length (12756x)
• the quoted string (10368x)
• call execute (2367x)
• 2023 (1382x)
• 2024 (1026x)
• AUnH (903x)
• $varying (848x)
• AUnH'vNvFWmRH (759x)
• message box (708x)