data _null_; if month(today())=1 then         do;             proc sql noprint;                insert into table1(date,tag)                set date=today(),                 tag=0;        end; else;       do;             %put @@@@@NO NEED TO INSERT@@@@@@;       end; run;   There was 1 unclosed DO block,but I can't find it..how to fix?thanks! ... View more

I want to make a variable flag,if the max(date) of three tables— A,B,C  are same then let flag=1 else let flag=0   proc sql noprint; select max(date) into:date01 from tableA; select max(date) into:date02 from tableB; select max(date) into:date03 from tableC; quit;   %put &date01@@&date02@@&date03;   I got the result: 28FEB2018@@28FEB2018@@31JAN2018   and I am using codes below to set vaule for variable flag,it returns error 72-185 for year and month function,and error22-322 for syntax wrong.why and how should I fix? data _null_; %global flag;  if year(&date01)=year(&date02)=year(&date03)=year(today())  and month(&date01)=month(&date02)=month(&date03)=month(today())  then     do;      %let flag=1;     end;  else      do;       %let flag=0;       end; run; ... View more

I have searched some info about this error,but it seems none match mine,may someone familiar with this error take a look. "Code generated by a SAS macro, or submitted with a "submit selected" operation in your editor, can leave off a semicolon inadvertently." it is still abstruse for me to explore in my code by this comment.may someone give any advice..thanks! %let cnt=500; %let dataset=fund_sellList; %let sclj='~/task_out_szfh/fundSale/'; %let wjm='sz_fundSale_'; %macro write_dx;     options spool;     data _null_;     cur_date=put(today(),yymmdd10.);     cur_date=compress(cur_date,'-');     cnt=&cnt;     retain i;     set &dataset;     if _n_=1 then i=cnt;         if _n_<=i then do;             abs_filename=&sclj.||&wjm.||cur_date||'.dat';             abs_filename=compress(abs_filename,'');             file anyname filevar=abs_filename encoding='utf8' nobom ls=32767 DLM='|';                 put cst_id @;                 put '@|' @;                 put cust_name @;                 put '@|' ;         end;     run; %mend write_dx; %write_dx();   and if I am not using macro,there is no error. data _null_;     options spool;     cur_date=put(today(),yymmdd10.);     cur_date=compress(cur_date,'-');     cnt=&cnt;     retain i;     set &dataset;     if _n_=1 then i=cnt;         if _n_<=i then do;             abs_filename=&sclj.||&wjm.||cur_date||'.dat';             abs_filename=compress(abs_filename,'');             file anyname filevar=abs_filename encoding='utf8' nobom ls=32767 DLM='|';                 put cst_id @;                 put '@|' @;                 put cust_name @;                 put '@|' ;         end;     run; ... View more

I have two table looks like and I want to add column score to tableA from tableB,then get tableC,how to do in SAS? the only rule is to add a column in tableA name "score " and its value is same as column "score" in tableB(which are all the same in tableB) +----+---+---+---+ | id | b | c | d | +----+---+---+---+ | 1 | 5 | 7 | 2 | | 2 | 6 | 8 | 3 | | 3 | 7 | 8 | 1 | | 4 | 5 | 7 | 2 | | 5 | 6 | 8 | 3 | | 6 | 7 | 8 | 1 | +----+---+---+---+ tableA +---+---+-------+ | e | f | score | +---+---+-------+ | 3 | 7 | 11 | | 4 | 6 | 11 | | 5 | 5 | 11 | +---+---+-------+ tableB +----+---+---+---+-------+ | id | b | c | d | score | +----+---+---+---+-------+ | 1 | 5 | 7 | 2 | 11 | | 2 | 6 | 8 | 3 | 11 | | 3 | 7 | 8 | 1 | 11 | | 4 | 5 | 7 | 2 | 11 | | 5 | 6 | 8 | 3 | 11 | | 6 | 7 | 8 | 1 | 11 | +----+---+---+---+-------+ tableC   ... View more

I am use select into creating a macro array   proc sql; select numValue into:num_value separated by ' ' from tableA; quit;   %put %scan(num_value,1);     however,the value in macro num_value  did not arrange their numeric values from its original order（from small to large）. so how could I arrage their values descending or ascending depending on their index,or the macro array has a same order as the original table is.   thanks! ... View more