Advanced search
21 search results
Page 2 out of 3 Pages
- 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 ... - 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: 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 ... - Procedures: Is there a way in SAS to read in Excel Long Dates?
Answer: SAS is well-equipped with a number of INFORMATs which allow the source data to be read in. There is a particularly useful date informat called ... - 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 ...
The most popular searches are:
- all except (29454x)
- length (2267x)
- the quoted string (1828x)
- call execute (1516x)
- 2023 (1208x)
- AUnH (820x)
- $varying (763x)
- AUnH'vNvFWmRH (690x)
- message box (644x)
- %include (634x)