FILENAME test URL “http://www.indeed.com/jobs?q=sas+programmer&limit=100&fromage=0&start=0” DEBUG LRECL=700;DATA test; infile test length=len; input record $varying700. len; *****DELETE MOST LINES W/O JOB;if index(record, ‘cmpid’)=0 th…
Category: SAS
How to create a macro variable containing a list of variables in a DATA set
Sometimes it is very handy to have a macro variable contanining the variables names of the dataset. Here are the 2 different ways you can create a macro variable with list of variables names …
*Method1: Using Proc Contents and Pro…
The support.sas.com team wants to meet YOU at SAS Global Forum 2010
Contributed by Memsy Price, Manager, Online Customer Support, SAS
Spring has sprung in North Carolina and here on the support.sas.com team our thoughts have turned towards sunny afternoons, daffodils, and — oh my goodness! — all we have…
Excel Pivot Tables and Filtering
So I get a post this morning from my client saying everything looks great and they can’t find any issues with the latest release. Happy moment, cigar time.Well, at this point I am over on the project and am working on my own time. That’s fine consideri…
Validating credit card numbers in SAS
Major credit card issuing networks (including Visa, MasterCard, Discover, and American Express) allow simple credit card number validation using the Luhn Algorithm (also called the “modulus 10″ or “mod 10″ algorithm). The follow…
Use GTL to generate 2X1 panel
1. GTL can easily put multiple images in a single panel;2. GTL can also apply multiple curves in a single column image;proc template; define statgraph graph.one; begingraph; entrytitle “Horsepower Profile in a 2X1 panel”; la…
How many SAS programmer opens by states?
1. Data by state is obtained manually from indeed.com (14 days range @15Mar2010);2. Conclusion: SAS programmer opens most occur on the east and west coastdata sites;length stcode $ 2;input stcode $ region sites;state=stfips(stcode);datalines;AR 6 …
Impressed with SAS Text Miner Help Files
As a tech junkie, people in the office often come by to ask for help with various software. As this is not a part of my job description and I have deadlines to meet, sometimes my response is “Press F1”. Of course, this will usually open the…