Advanced search
64 search results
Page 4 out of 7 Pages
- PROC SQL: Can I stop the "WARNING: This CREATE TABLE statement recursively references the target table. A
Answer: WARNING and ERROR messages in SAS serve a useful purpose, but there are certain situations where the message is known, anticipated, and it may be ... - PROC SQL: How can I create a row count variable in DATA step and PROC SQL?
Answer: There is an automatic variable generated by the system in the PDV when processing DATA step syntax which will in many circumstances provide the necessary ... - PROC SQL: Is there a facility in PROC SQL to repeat a value down a BY-GROUP in
Answer: Sometimes when data is combined from different sources it is possible to end up with undesirable missing values. Run the following code against the attached ... - Macros: Is it possible to generate a shorthand SELECT Clause in PROC SQL with every column
Answer: No. Although there is the facility to return all columns using the SELECT * syntax, there is no equivalent for the DROP = dataset option ... - Procedures: Why do I get missing values for all rows in a COMPUTED column in PROC
Answer: The REPORT Procedure is a veritable Swiss Army knife of a procedure and can turn its hand to many different forms of reporting, but with ... - Macros: SAS ignores comments, right?
Answer: You'd like to think so, and mostly this is true - but not always! When it comes to using comments, the two main options are comment ... - Macros: Is there an equivalent to the 'begins with' colon modifier to identify variables which 'end
Answer: Efficient programmers (some call us lazy) love the shorthand notation which allows a variable list to be shortened by the colon modifier: data out ; set ... - Macros: Can I use the colon modifier to create a 'begins with' list of variables on
Answer: No. Shame though - it's a really handy way to save typing long lists of repetitive variables! Submitting the code: proc sql ; select unit: from sashelp.applianc ... - DATA Step: How can I suppress 'bad data' issues when making an explicit character to numeric conversion?
Answer: The INPUT statement includes several modofiers which provide greater control of bad data issues when reading in raw data. The INPUT function will also accept ... - Macros: Is there an easy way to delete macro programme definitions and user-defined macro variables?
Answer: There is always a potential for cross-contamination when running code from different programmes in the same session resulting in unexpected ERRORs / WARNINGs, or outcomes ...
The most popular searches are:
- all except (29391x)
- length (2222x)
- the quoted string (1796x)
- call execute (1492x)
- 2023 (1172x)
- AUnH (811x)
- $varying (755x)
- AUnH'vNvFWmRH (681x)
- message box (638x)
- %include (627x)