Help using Base SAS procedures

proc transpose when value is missing or null

Reply
Frequent Contributor
Posts: 131

proc transpose when value is missing or null

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

Super User
Super User
Posts: 7,420

Re: proc transpose when value is missing or null

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;

Regular Contributor
Posts: 233

Re: proc transpose when value is missing or null

Ask a Question
Discussion stats
  • 2 replies
  • 215 views
  • 0 likes
  • 3 in conversation