proc transpose when value is missing or null

[Q1983]

data test;

set test1;

run;

Here is sample data

ln           com_cd            comm_dt

000           ccf                     6/16/2014

001          ccb                     6/5/2012

003         fbb                      10/13/14

proc transpose data=test out=test3   (drop = _name_ _label_);

by ln;

id comm_cd;

var comm_dt;

run;

Lets say one of the comm_cd (say ccb) does not populate and is a null value, this will cause errors in other parts of the program if I were to reference that comm_cd

[RW9]

Create a base template of expected variables which you use in your program:

proc sql;

     create table TEMP

     (

          IN char(3),

          CCF char(10),

          CCB char(10)

     );

quit;

Then set this with your transposed dataset to get full list of variables:

data want;

     set temp your_dataset;

run;

[Hima]

Base SAS(R) 9.2 Procedures Guide