%let C=test; Data a; input x $; cards; LI  GI  H&C ; Proc sql noprint; select x into: test2 separated by "," from a; quit;   I want macro variable test2 to be resolved as LI,GI,H&C   ... View more

data test; input email_add $50.; infile datalines; datalines; arun@abc.com arun@abc.com arun@abc.com ; run; filename abc email; data _null_; set test end=eof; file abc; put ; put "This is a test email"; PUT '!EM_TO!' up_email; PUT '!EM_SUBJECT!' 'final test3'; PUT '!EM_SEND!'; IF eof THEN PUT '!EM_ABORT!'; run; When I am sending an email through sas then first email recipient get exact content as expected then after consecutive emails get repeated text in email body. Please suggest what to do.   ... View more

Hi All, I am running below Teradata code using passthrough but facing some error:   SELECT * FROM ABC LEFT JOIN BCD on A.ABC = B.BCD WHERE MONTH > concat( cast(extract(year from add_months((DATE - extract(day from DATE)) ,-9)) as varchar(4)), SUBSTR(cast(100 + extract( month from add_months((DATE - extract(day from DATE)) ,-9)) as varchar (3)) ,2 ,2) )   I am not sure if we can use add_months in SAS, if not how can we resolve this? ... View more

data a; input id sal; cards; 1 10 1 20 1 40 1 35 1 5 2 3 2 6 2 4 2 78 ; run; * I want within each distinct group of id I want 3rd largest sal value using monotonic(); ... View more

data a1 a2 a3; input x; cards; 1 2 3 ;   I want a1 a2 a3 to be appended into a single dataset using an array. Please, suggest.    ... View more

* I want to retain my format of values even after proc transpose how to do that;   data a; input year groupx respondents resa resb resc; cards; 2007 5 10 100 . . 2008 4 13 61 23 15 2009 5 13 38 53 7 2010 7 20 60 25 15 ; run; proc transpose data=a out=b; run; proc transpose data=b out=c(drop=_name_); run; data d(drop=i resa resb resc); set c; format b1 b2 b3 percent6.; array a[*] resa resb resc ; array b[3] b1 b2 b3; do i=1 to 3; b{i}=a{i}/100; end; run;     ... View more