What do you do if you have a SAS data set with formatted variables, but you don’t have access to the format? You have to remove the format from the variables if you want to work with the data set.The easiest way to remove formats from variables in a d…
Tag: proc
Remove Formatting From Variables
What do you do if you have a SAS data set with formatted variables, but you don’t have access to the format? You have to remove the format from the variables if you want to work with the data set.The easiest way to remove formats from variables in a d…
Remove Formatting From Variables
What do you do if you have a SAS data set with formatted variables, but you don’t have access to the format? You have to remove the format from the variables if you want to work with the data set.The easiest way to remove formats from variables in a d…
Efficiently Drop/Keep SAS Data Set Columns
What is the most efficient way to drop/keep columns (variables) in sas tables (data sets)?For the most part, we would correctly say “using a keep= option on the data set as it is being read into the current step.” A quick example to illustrate: data s…
Efficiently Drop/Keep SAS Data Set Columns
What is the most efficient way to drop/keep columns (variables) in sas tables (data sets)?For the most part, we would correctly say “using a keep= option on the data set as it is being read into the current step.” A quick example to illustrate: data s…
Efficiently Drop/Keep SAS Data Set Columns
What is the most efficient way to drop/keep columns (variables) in sas tables (data sets)?For the most part, we would correctly say “using a keep= option on the data set as it is being read into the current step.” A quick example to illustrate: data s…
Sorting Pitfalls
SAS Proc sort is probably one of the easiest procs to use. And sorting in other programs/software is generally pretty straightforward. However, there are a few things I always remind myself when sorting.When you use proc sort you don’t know who is do…
Proc FCMP
A long time ago I figured out how to write functions for SAS using SAS/Toolkit. It was not a straightforward process and not very useful. In fact, someone recently asked me about it and I was unable to share much useful info. However, I did find pro…