Am I a new programmer? Let me see. I was a new programmer when I wrote my first program in college. I was a new programmer when I wrote my first SAS program during SAS Programming 1 class. And if I were to sit down to write a program today, I’d…
Category: SAS
Script to remove the subversion folder from project directory
Many a times we would want to remove the subversion folders which are present in the project directory for various reasons. (Eg: Copy the structure to another drive, zip it and mail it, etc..). The subversion folders are present in every directory (Eg:…
Replace a String in Unix
Now that we know how to find a string in a list of files in the home directory, we may also want to replace the string with something else.. Eg: Replacing a password in all the files as and when it is getting changed.The command to do this is:find . -t…
Combining Graphs/Procs with Custom HTML in a SAS Stored Process
The %STPBegin and %STPEnd macros are pretty powerful pieces of code for SAS Stored Processes. They embed all sorts of information on devices, where content is located, and just make everything work. However for creating those fancy custom HTML forms or…
Print global macro variables
The call symput(“macroname”, varname) is really useful for getting data from a data set into SAS code that’s executed later. One example is shown here.
This entry is inspired by a simulation project I’m coding right now where there are many…
Find a String in UNIX
We’ve become so much addicted to find/search functionality these days that I tend to look out for Ctrl+F button when I want to find something on a hard bound book as well!!I had a requirement where I had to search for all the files in my home directory…
“call symputX” is the symput upgrade
SymputX is the upgrade from Call Symput. Syntax: call symputx(“macro_var_name”, character_value (or numeric to be converted to char), symbol table def); Where symput will produce a note about converting character values to numeric, symputx won’t produce such a note. Additionally it will strip leading and trailing spaces form the character value. Lastly, you can define […]
Converting SAS datasets to SPSS
If you want to view SAS dataset in SPSS you can use GET SAS command of SPSS.
Here is the syntax;
get sas data=’C:\data\class.sas7bdat’.
For conversion of SAS to SPSS we need to see if any formats assigned to variables in the dataset or not.
…