%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

proc hpforest data=arun.HR_train maxtrees= 5 vars_to_try=4 seed=600 trainfraction=0.6 maxdepth=50 leafsize=6 alpha= 0.1; target shortlisted/ level=binary; input Skill_1 Skill_2 Skill_3 Skill_4 Skill_5 Skill_6 Skill_7 Skill_8 Skill_9 Skill_10 Skill_11/ level=binary; input Overall/ level=interval; input assessor/level=nominal; ods output fitstatistics = arun.fitstats2; save file = " /home/arun.sh1/my_content/model_fit.bin"; run;   I am trying to save my model into through sas on demand. Please let me how can I store and score my dataset.            ... 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