Hi,
I have a dataset like below
name indicator1 indicator2 indicator3 indicator4 - --- indicator65
danny 1 . 1 1 .
danny . 1 . . . 1
danny 1 1 1 1 1
sam 1 . . . .
sam 1
output
name indicator1 indicator2 indicator3 indicator4 - --- indicator65
danny 1 1 1 1 .
sam 1 . . . .
please help
Try this,
data trans;
input Name $ Field1-Field5 ;
cards;
danny 1 . 2 3 .
danny . 4 . 3 5
sam . 4 . 4 5
sam 1 . 2 4 .
;;;;
run;
data flat;
update trans(obs=0) trans;
by Name;
run;
proc print;
run;
I seen a similar post yesterday in this forum as well.
Hello,
Another solution:
data have;
input name $ indicator1 indicator2 indicator3 indicator4 indicator5;
datalines;
danny 1 . 1 1 .
danny . 1 . . 1
danny 1 1 1 1 1
sam 1 . . . .
sam . . . . 1
;
proc means data=have nway ;
var indicator1-indicator5;
class name;
output out=want (drop=_type_ _freq_) max=;
run;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.