Advanced search
64 search results
Page 5 out of 7 Pages
- 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, ... - Procedures: How can I re-start an EG session with all settings from a previous session?
Answer: For long-running code it can be frustrating when a session ends (either intentionally or unintentionally) and the process must be re-started from the beginning as: all ... - Macros: Can I use MACRO language statements like %IF in open code?
Answer: Historically these MACRO language statements could only be used within a MACRO program definition which led to many developers contriving MACRO programs just to use ... - 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 delete observations from a dataset where all values are missing?
Answer: Yes. A perfect example of a utility macro which retrieves the number of variables in the dataset, counts the number of missing character / numeric variables ... - 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 ... - DATA Step: Can I create a password-protected Excel spreadsheet using tagsets.excelxp?
Answer: No the XML file generated by the ExcelXP tagset does not support passwords, however the following code can generate a VB script which can be ... - Procedures: Can I keep all of the repeating GROUP / ORDER values in PROC REPORT?
Answer: PROC REPORT is a hugely versatile reporting procedure and comes with a number of inbuilt features - for example when a column is defined as ... - DATA Step: Can I dynamically create a sub-directory and assign a LIBREF to it?
Answer: How cool would that be! Imagine that you have a need to create a new sub-directory to store data for each run of your code, ...
The most popular searches are:
- all except (29456x)
- length (2267x)
- the quoted string (1828x)
- call execute (1517x)
- 2023 (1208x)
- AUnH (820x)
- $varying (763x)
- AUnH'vNvFWmRH (690x)
- message box (644x)
- %include (634x)