topic Re: Output values for only specified variables in SAS Programming

Output values for only specified variables

moreka — Sat, 13 Jun 2015 14:53:01 GMT

I'm trying to more or less transpose a dataset by groups of variables, and am currently attempting to do so with the output statement in a datastep. However, that method outputs the current value of all variables, and I'd like to only output the values of the variables I'm listing per time period, while others remain missing.

What is a better way to do this or improve my current code?

Have:

w4_wt_lbs w4_ht_in w4_bmi m3_brstfeed m3_supplement m6_brstfeed m6_supplement

121.5 63 21.520408163 1 0 1 1

Want:

week wt_lbs ht_in bmi brstfeed supplement

4 121.5 63.0 21.5204 . .

12 . . . 1 0

24 . . . 1 1

Currently output:

week wt_lbs ht_in bmi brstfeed supplement

4 121.5 63.0 21.5204 . .

12 121.5 63.0 21.5204 1 0

24 121.5 63.0 21.5204 1 1

Currently code:

data want; set have;

week=4;

wt_lbs = w4_wt_lbs ;

ht_in = w4_ht_in ;

bmi = w4_bmi ;

output;

week=12;

brstfeed = m3_brstfeed ;

supplement = m3_supplement ;

output;

week=24;

brstfeed = m6_brstfeed ;

supplement = m6_supplement ;

output;

run;

Thanks!

Re: Output values for only specified variables

Ksharp — Sat, 13 Jun 2015 15:14:04 GMT

data want; set have;

week=4;

wt_lbs = w4_wt_lbs ;

ht_in = w4_ht_in ;

bmi = w4_bmi ;

output;

call missing(of _all_);

week=12;

brstfeed = m3_brstfeed ;

supplement = m3_supplement ;

output;

call missing(of _all_);

week=24;

brstfeed = m6_brstfeed ;

supplement = m6_supplement ;

output;

run;

Re: Output values for only specified variables

sbb — Sat, 13 Jun 2015 17:24:31 GMT

Can be accomplished programmatically, using the DATA step function VNAME to assign a numeric value for WEEK - based on a SUBSTR(...) and output each variable instance from inside a DO/END loop using an array that references the w#_xxxxx and m#_xxxx variables.

Another possibility is to use DICTIONARY.COLUMNS to generate the required SAS code based on the actual variable names found -- again, without any hardcoded programming where the "#" must already be known.

Scott Barry

SBBWorks, Inc.

Re: Output values for only specified variables

moreka — Sat, 13 Jun 2015 18:30:39 GMT

Hm, looks like the code above using the call function seems to brings down the missing values of the last two variables instead of setting them to the intended value for that line:

week wt_lbs ht_in bmi brstfeed supplement

4 121.5 63 21.5204 . .

12 . . . . .

24 . . . . .

Re: Output values for only specified variables

Ksharp — Sun, 14 Jun 2015 04:20:57 GMT

Code: Program

data have;
input w4_wt_lbs   w4_ht_in   w4_bmi   m3_brstfeed   m3_supplement   m6_brstfeed   m6_supplement;
cards;
121.5 63 21.520408163 1 0 1 1
;
run;
data want; set have;
  week=4;
  wt_lbs = w4_wt_lbs ;
  ht_in = w4_ht_in ;
  bmi = w4_bmi ;
  output;
  call missing(wt_lbs , ht_in ,  bmi);
  week=12;
  brstfeed = m3_brstfeed ;
  supplement = m3_supplement ;
  output;
  week=24;
  brstfeed = m6_brstfeed ;
  supplement = m6_supplement ;
  output;
run;

Re: Output values for only specified variables

BPD — Mon, 15 Jun 2015 12:18:36 GMT

Use Xia Keshan's code but add a keep statement to the want dataset.

E.g.

data want(keep=week wt_lbs ht_in bmi brstfeed supplement);

set have;

Regards,

BPD