Hi all, similarly like this step i have write 24 steps if shcheck1 = 1 then do; TERM =Strip(sb1_display); CAT ='HISTORY' ; output; end; like this if shcheck2 = 1 then do; TERM =Strip(sb2_display); CAT ='HISTORY' ; output; end; if shcheck3 = 1 then do; TERM =Strip(sb3_display); CAT ='HISTORY' ; output; end; is there any easy way to give it in a macro for the numbers changing till 24? Thanks in adv
... View more
how to get the required output from the condition if check1-check24 = '1' then TERM=(frac1_ to frac24_). Using macro. Check1_ Check2_ Check3_ 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 frac1_ frac2_ frac3_ Extreme Good Good Extreme Good Average Not Good Good Not Good Good Neat Neat Vba Neat Average Required output. TERM Extreme Good Average Not Good Neat Vba Average Extreme Not Good Neat Neat Good Good Good Good
... View more
Hi i want to separate character from numeric value for eg : Txt 50mg slicing data 100/50 mg mg unknown 0.25 mmmgb how to get the output like this: c Txt_b 50 mg slicing data 100/50 mg mg unknown 0.25 mmmgb
... View more
Hi i have got a column xy where the values are stored as shown. XY (Drug A)-(Drug-BB)-(Drug-CCC) (Drug-BB)-(Drug A)-(Drug-CCC) (Drug-CCC)-(Drug-BB)-(Drug A) I wanted the output like this.The values to be stored in separate column under a b and c. Please help me if anyone knows the answer for this. A B C Drug A Drug-BB Drug-CCC Drug-BB Drug A Drug-CCC Drug-CCC Drug-BB Drug A Thanks in advance.
... View more
How can I select rows in reverse order? For example I have a column sample1 which has values like. This Sample1 1 2 A Sr R Y 7 The output I want is : 7 Y R Sr A 2 1 I anyone knows please help me.. Thanks in advance
... View more
I have three libraries for eg lib a, lib b, lib c And that lib a has 10 data sets like ae, demo, concom, etc... And so does lib b and c.... I have to write a common program using macro ...than separate pogram for each 3 library ..
... View more
