Advanced search
64 search results
Page 3 out of 7 Pages
- 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 ... - PROC SQL: Can I use the FIRSTOBS= and OBS= options in PROC SQL?
Answer: Yes, but there are two PROC SQL options which you might also want to consider. The FIRSTOBS= and OBS= options are normally used on a SET ... - 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 ... - PROC SQL: Is there an equivalent for the COALESCE function to find the first non-missing value in
Answer: The COALESCE function allows for the first non-missing argument to be returned from a list of variables reading across a row: non_miss = coalesce(arg1,arg2,arg3) the ... - PROC SQL: Is it possible to perform a merge where key values are split across two columns?
Answer: Normally when performing a horizontal join of datasets, or performing a lookup, the key values exist in a single column, however sometimes 'dirty' data may ... - Macros: How can I compare two datasets with similarly-named variables by joining them horizontally?
Answer: Rather than using PROC COMPARE to identify differences, which can sometimes generate 'too much' information, it is preferable to join datasets horizontally, then perform a ... - PROC SQL: Can I exclude certain columns from the select * clause?
Answer: The simple answer is no: there is no SQL equivalent to the DROP= dataset option on a SET or MERGE statement to exclude only a few ... - DATA Step: Can I count instances of values stored in a group of variables in an observation?
Answer: As with most things in SAS, the simple answer is "Yes!". A combination of functions allow you to create a concatenated string from all of the ... - DATA Step: Can I count instances of values with mixed response types stored in a group of
Answer: Counting simple boolean Y | N or 1 | 0 responses is fairly straighforward in SAS, however where the responses are more complex some additional ... - PROC SQL: How can I build sample datasets to perform fuzzy matches?
Answer: Sometimes data coming from different sources can be subtly different, resulting in a mis-match when performing a straight character comparison, but a visual comparison would ...
The most popular searches are:
- all except (29436x)
- length (2254x)
- the quoted string (1819x)
- call execute (1510x)
- 2023 (1199x)
- AUnH (819x)
- $varying (762x)
- AUnH'vNvFWmRH (688x)
- message box (643x)
- %include (633x)