topic Re: proc transpose when value is missing or null in SAS Procedures

proc transpose when value is missing or null

Q1983 — Wed, 03 Sep 2014 15:10:25 GMT

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

Re: proc transpose when value is missing or null

RW9 — Wed, 03 Sep 2014 15:17:45 GMT

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;

Re: proc transpose when value is missing or null

Hima — Wed, 03 Sep 2014 16:15:18 GMT

Base SAS(R) 9.2 Procedures Guide