21 search results

Page 1 out of 3 Pages

• 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 remove consecutive blanks from a text string?
  Answer: While the COMPRESS function in SAS will remove, by default, every instance of the blank space, sometimes it is desirable to remove all-but-one of the ...
• DATA Step: How do I remove repeated characters from a text string?
  Answer: The COMPRESS function has a number of additional arguments which allow for the removal of all instances of certain designated characters, or groups of characters ...
• 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 ...
• Macros: Can I get SAS to create pop-up message boxes in Windows?
  Answer: Using Display Manager commands allow you to create pop-up boxes which enable you to issue bespoke messages to the user. Create a 'utility' macro program which will ...
• Macros: Is it possible to use both single and double quotes inside a quoted text string?
  Answer: Attempting to include examples of both single and double quotation marks inside a quoted string causes problems with early termination of the quoted string, e.g.: title ...
• 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 ...
• DATA Step: Can I stop SAS from reading lines from a csv file where all values are
  Answer: Sometimes when generating a CSV file, e.g. from an Excel Spreadsheet there may be lines in the file which consist of nothing but the field ...

The most popular searches are:

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