Hi all I intend to create table like this x a b c a 1 2 3 b 2 4 6 c 3 6 9 where in base we have a b and c and the values for a b c are given if we check them horizontally or vertically it should show the same value like a should be 1 and for a and b it should be 2 even in column and row .Please advise how to do it. Thanks.
... View more
the numeric is stored in character value which i have to convert and after that i will get the number as output in data 4 and the character values like present will return as null in data 4
... View more
Hii I am practicing SAS with dummy datasets i came across this condition where a variables contains both numeric and character . Data 1 Data 2 present 4 abs 6 12 9 332 . 21 . 31 . 27 4 not defined 7 i got a condition like (i)if data1 is numeric and data 2 is not missing then data3=data1 (ii) if data 1 is not numeric then data 4 is null can anyone please help me how to solve this ....thanks in advance
... View more
Hii i have a dataset like this id reas freq count 1 3 17 1 6 23 1 7 56 1 9 33 1 10 24 2 3 64 2 6 23 2 7 34 2 8 64 2 10 43 and the output i want is can anyone help me how to solve this ? reas id=1 id=2 3 17 64 6 23 23 7 56 34 8 33 64 10 24 43 thanks in advance
... View more
Hi i want to get only numeric values where this is the input data have; length var1 $30.; var1='hdhdxha82873jdjsd';output; var1= 9293293991 ;output; var1='123431hud';output; var1=1223444;output; run; and the required output is var1 9293293991 1223444 How can I extract just the numeric values. thanks
... View more
