23 search results

Page 1 out of 3 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 ...
• Macros: How can I search for a phrase in all SAS files in a directory and
  Answer: /************************************************************************************/ /*** ...
• 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 ...
• 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 ...
• Macros: How long is a character variable retrieved from a macro variable?
  Answer: Macro variables are always stored as text and have different characteristics to dataset variables.  Variables in a dataset have a minimum length of 1, a ...
• DATA Step: Why shouldn't I use TRANWRD or TRANSLATE to remove characters from a string?
  Answer: The TRANWRD function can be used to replace a 'word' within a character string, and the TRANSLATE function can be used to replace any of ...
• PROC SQL: How can I stop certain functions setting the length of the result to 200?
  Answer: In the Language of SAS there are essentially three lengths which character manipulation functions will return: 8 bytes 200 bytes Inherited from the source Where the system can make ...
• DATA Step: How can I avoid the message: "WARNING: The quoted string currently being processed has become
  Answer: The maximum length of a character string in the Language of SAS is 32,767 characters, however when issuing an instruction containing a long quoted string ...

The most popular searches are:

• all except (2336727x)
• length (12756x)
• the quoted string (10367x)
• call execute (2366x)
• 2023 (1381x)
• 2024 (1026x)
• AUnH (903x)
• $varying (847x)
• AUnH'vNvFWmRH (759x)
• message box (708x)