hi,
I have 4 character columns in a table, and am tring to combine the 2 columns into new column, like append with two columns.
data have;
infile datalines truncover dlm=',' dsd;
input catX $ catY $ value $ ALFA $;
datalines;
X1,Y1,2,A
X1,Y1,4,D
X1,Y2,1,G
X1,Y2,3,H
X2,Y1,2,K
X2,Y2,2,H
X2,Y2,3,Y
X2,Y2,3,G
;
proc report data=have nowd out=temp;
column catY catX value ALFA;
define catY/group noprint;
define catX / 'A' group;
define ALFA / 'B' ;
Compute before catY;
Line @1 catY $50.;
endcomp;
run;
First is output on my query and second table i want .
... View more
