/* create sample data */
data one;
input a $ b $ c $ d e;
cards;
a . a 1 3
. b . 2 4
a a a . 5
. . b 3 5
a a a . 6
a a a . 7
a a a 2 8
;
run;
/* create a format to group missing and non-missing */
proc format;
value $missfmt ‘ ‘=’m…
Category: SAS
Counting the number of missing and non-missing values for each variable in a data set.
/* create sample data */
data one;
input a $ b $ c $ d e;
cards;
a . a 1 3
. b . 2 4
a a a . 5
. . b 3 5
a a a . 6
a a a . 7
a a a 2 8
;
run;
/* create a format to group missing and non-missing */
proc format;
value $missfmt ‘ ‘=’m…
Counting the number of missing and non-missing values for each variable in a data set.
/* create sample data */
data one;
input a $ b $ c $ d e;
cards;
a . a 1 3
. b . 2 4
a a a . 5
. . b 3 5
a a a . 6
a a a . 7
a a a 2 8
;
run;
/* create a format to group missing and non-missing */
proc format;
value $missfmt ‘ ‘=’m…
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…
Dynamic dashboard ranges – its all in the data
Business Problem: The traffic lighting (red/green/yellow) range is different for one group/category than the others but the indicator needs to include all group values. Recommendation: It’s all in the data. Here is an example. For the Candy_Sales_Summa…
Bad words in SAS – PG rating
Picture this – a student grabs the Programming 1 textbook, scans it quickly seemingly searching for something specific, and shakes his head indicating an unsuccessful search. He plants himself smack dab in the front row, looks me squarely in the eye,…