SAS Support Communities

When I used cats instead catx the problem is even bigger this time now it removes all spaces and produced data CCD_1; setCD_11CD_12CD_13CD_14CD_15CD_16CD_17CD_18CD_19CD_110; rename COL1=C;                    ------------------------------------------------------------------------------------------------------------- ... View more

Sorry I didn't understand it ... View more

now it working fine but only one error of space between set and CD_11 log error is data CCD_1; setCD_11 CD_12 CD_13 CD_14 CD_15 CD_16 CD_17 CD_18 CD_19 CD_110; rename I am using following sas code data want;                          length names $ 200;                                                                                                                                  do j=1 to 11;                                                                                                                                        names='';                                                                                                                                            do i = 1 to 10;          names = catx(' ',names,cats("CD_",J,I));       end;      call execute(cats('data CCD_',put(j,8.),'; set ', names ,'; rename COL1=C;'));      end;                                                                                                                                               run;                                                                                                                                                                                                                                                            ... View more

When I run you above menetion code and try to print data set CCD_1 the log says that ERROR: File WORK.CCD_1.DATA does not exist. data want;      length names $ 200;      do j=1 to 11;        names='';        do i = 1 to 10;          names = catx(' ',names,cats("CD_",J,I));       end;                 str=cats('data CCD_',put(j,8.),'; set ', names ,'; rename COL1=C;');       put str;      end; run; Proc print data=CCD_1;                                                                                                                                                                                                                                          run;                                                                                                                                                                                                                                                            ... View more

Dear ballardw I would be realy gratefull to you if could write complete statment of call execute inculding names variables becuase i tried it multiple times but getting errors pls ... View more

My problem is not solved yet please guide me towards its solution ... View more

I am trying this but it gives error data _null_;                                                                                                                                                                                                                                                         do j=1 to 10;                                                                                                                                                                                                                                                       call execute(cats('data CCD_',put(j,8.),'; set names ; rename COL1=C;' ));                                                                                                                                                                        end;                                                                                                                                                                                                                                                     run; Log error 1    + data CCD_1; set names ; rename COL1=C; ERROR: File WORK.NAMES.DATA does not exist. ... View more

Thanks ballardw I have successfully generated variables names CD_11 CD_12 CD_13 CD_14 CD_15 CD_16 CD_17 CD_18 CD_19 CD_110 CD_21 CD_22 CD_23 CD_24 CD_25 CD_26 CD_27 CD_28 CD_29 CD_210 CD_31 CD_32 CD_33 CD_34 CD_35 CD_36 CD_37 CD_38 CD_39 CD_310 CD_41 CD_42 CD_43 CD_44 CD_45 CD_46 CD_47 CD_48 CD_49 CD_410 CD_51 CD_52 CD_53 CD_54 CD_55 CD_56 CD_57 CD_58 CD_59 CD_510 CD_61 CD_62 CD_63 CD_64 CD_65 CD_66 CD_67 CD_68 CD_69 CD_610 CD_71 CD_72 CD_73 CD_74 CD_75 CD_76 CD_77 CD_78 CD_79 CD_710 CD_81 CD_82 CD_83 CD_84 CD_85 CD_86 CD_87 CD_88 CD_89 CD_810 CD_91 CD_92 CD_93 CD_94 CD_95 CD_96 CD_97 CD_98 CD_99 CD_910 CD_101 CD_102 CD_103 CD_104 CD_105 CD_106 CD_107 CD_108 CD_109 CD_1010 CD_111 CD_112 CD_113 CD_114 CD_115 CD_116 CD_117 CD_118 CD_119 CD_1110 But I am confused where should I use names in my following code to get my output data _null_;      do j=1 to 11;                 call execute(cats('data CCD_',put(j,8.),'; set CD_',put(j,8.),'1:CD_',put(j,8.),'10; rename COL1=A;' ));       end;            run;     ... View more

Ok thank you now it work fine I have an other query I have data sets like CD_11  CD_12 ........CD_110 CD_21  CD_22.........CD_210 ................................................ CD_111  CD_112.........CD_1110 Now I want merge data sets CD_11 CD_12  CD_13 ..... CD_110  into data set CCD_1 similarly CD_21 CD_22  CD_23..... CD_210  into data set CCD_2 .............................................................................. and CD_111 CD_112  CD_113 ..... CD_1110  into data set CCD_11 For this I am using following sas command data _null_;                                                                                                                                                                                                                                    do j=1 to 11;                                                                                                                                                                                                                                   call execute(cats('data CCD_',put(j,8.),'; set CD_',put(j,8.),'1:CD_',put(j,8.),'10; rename COL1=A;' ));                                                                                            end;                                                                                                                                                                                                                                      run; But it is not producing desired output Pls help ... View more

Ok I am using following code but still get error data _null_; do j=1 to 2;                                                                                                                                            call execute(cats('DATA SIM_',j) ||';merge') ;   do prefix = 'AAD_','BBD_','CCD_' ;      call execute(' ' || cats(prefix,j));   end;   call execute(cats(MIBC = 5*(A)  +B+ C -(6/2)));   call execute(';run;');   end; run;                      error on log NOTE: Variable A is uninitialized. NOTE: Variable B is uninitialized. NOTE: Variable C is uninitialized. NOTE: Variable MIBC is uninitialized. NOTE: Missing values were generated as a result of performing an operation on missing values.       Each place is given by: (Number of times) at (Line):(Column).       2 at -38258:-41   2 at -38258:-37   2 at -38258:-35   2 at -38258:-29 NOTE: DATA statement used (Total process time):       real time           0.02 seconds       cpu time            0.01 seconds NOTE: CALL EXECUTE generated line. 1     + DATA SIM_1;merge 2     +  AAD_1 3     +  BBD_1 4     +  CCD_1 NOTE: Line generated by the CALL EXECUTE routine. 5     + 1         -         22         200 ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, -, :,               ;, END, _DATA_, _LAST_, _NULL_.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            ... View more

thank it works fine One thing I want to know whether call execute allow some calculation or not that is I want  MIBC= 0.5*(A)  +B+ C -(6/2) for both data sets So I am doing this data _null_;                                                                                                                                                                                                                               do j=1 to 2;                                                                                                                                                                                                                                 call execute(cats('DATA SIM_',j) ||';merge') ;                                                                                                                                                                               do prefix = 'AAD_','BBD_','CCD_' ;                                                                                                                                                                                              call execute(' ' || cats(prefix,j));                                                                                                                                                                                                 end;                                                                                                                                                                                                                                           call execute('MIBC= 0.5*(A)  +B+ C -(6/2);');   call execute(';run;');                                                                                                                                                                                                                   end;                                                                                                                                                                                                                                         run;    But gives some error NOTE: Line generated by the CALL EXECUTE routine. 11    + MIBC= 5*(A)  +B+ C -(6/2);             -             22             76 ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, -, :,               ;, END, _DATA_, _LAST_, _NULL_. ERROR 76-322: Syntax error, statement will be ignored. ... View more

So how could I add space in merge command? can you specify please ... View more