Advanced search
23 search results
Page 2 out of 3 Pages
- 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 ... - 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 ... - 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 ... - 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 ... - DATA Step: Can I validate a postcode using SAS without a lookup to the postcode database?
Answer: While it is possible to obtain a copy of the 1.8M postcodes currently in use in the UK, and merge these against the desired field ... - 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 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 ...
The most popular searches are:
- all except (29451x)
- length (2265x)
- the quoted string (1826x)
- call execute (1515x)
- 2023 (1206x)
- AUnH (820x)
- $varying (763x)
- AUnH'vNvFWmRH (690x)
- message box (644x)
- %include (634x)