Here’s just a brief post about a function I just stumbled across. The PROPCASE function coverts a string to “proper case” wherein the first letter of each word is upper case and all others are lower case. Clearly this is a very useful thing for column …
Tag: syntax
NOTE: Whither the WEEK Format?
My friend Eli recently wrote to tell me of a very successful 9.1 to 9.2 upgrade that was marred by just one issue. His colleague Sarah discovered that the WEEK format disappeared between 9.1 and 9.2. Sarah had been using the WEEK format to produce week…
NOTE: Latest SAS-Related Periodicals (plus IN in macro)
The last few weeks have seen a couple of SAS-related periodicals published:
Issue 51 of VIEWS News is available. As ever, the archive of back-issues is a valuable resource
System Seminar Consultants released the autumn 2010 issue of The Missing Semicol…
NOTE: DATA Step’s _N_ is PROC SQL’s Monotonic
I’ve made a few posts over the last few months about SQL (particularly its use within Enterprise Guide). One of my unstated issues with SQL is the inability to do the equivalent of DATA step’s _N_ to count unique rows. The ability to add a sequence num…
NOTE: More on sorting and SQL
Further to my recent post on telling SAS that your data is pre-sorted, it’s worth mentioning the SORTVALIDATE system option. This yes/no option tells SAS whether the SORT procedure should verify if a data set is sorted according to the variab…
NOTE: What is PROC SORTT?
My friend and ex-colleague CB drew my attention to an intriguing thread on SAS-L recently. It asked “What is PROC SORTT” and drew a response from Paul Kent
At times we’ve issued “the same proc with a new name” as a way of allowing us to get feedb…