Advanced search
20 search results
Page 2 out of 2 Pages
- 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 ... - 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 ... - 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 ... - Macros: How can I create sample data to share with others? e.g. on a SAS forum
Answer: SAS fora are a useful way to glean some 'crowd wisdom' when struggling with a coding dilemma. Sometimes this can be answered in the abstract, ... - Macros: Can I retrieve metadata from an empty dataset?
Answer: Whn a dataset contains values, the normal experience is that the dataset is processed sequentially, and values can, for example, can be retrieved and stored ... - Macros: Can I export a dataset to a CSV file?
Answer: There are several ways to do this. This utility macro allows you to specify various paramaters, and validates these before generating the output file. %macro ds2csv ... - Macros: Can I create a macro variable longer than 65,534 bytes?
Answer: Well, no... The maximum length of a macro variable is restricted to the 65,534 characters, just like the maximum length of a character variable in ... - DATA Step: I have a list of names with initials some of which have a period but
Answer: Yes! This is one of those data cleansing routines to create consistent data. The process involves SCANning the character string extracting each word in turn, then ... - Macros: I constructed an IN list from a dataset, but now it breaks my SQL WHERE
Answer: The FAQ Can I create a macro variable longer than 65,534 bytes? is useful for creating a list longer than the 65K character limit imposed by ...
The most popular searches are:
- all except (29390x)
- length (2222x)
- the quoted string (1796x)
- call execute (1492x)
- 2023 (1172x)
- AUnH (811x)
- $varying (755x)
- AUnH'vNvFWmRH (681x)
- message box (638x)
- %include (627x)