If you want to define  variable name with "space", generally we use n. for example if you  want to create a variable with name "customer name",SAS won't accept this name directly because there is a space between customer and name.. For this you need to specify like this 'customer name'n. Let me know if any clarification needed. Thank you. Sanjeev. ... View more

you can use ct='text/html' instead of CONTENT_TYPE.. off-course both are same.. ct is short form of CONTENT_TYPE... ... View more

Sorry to all. A small typo error happened in my above post. I am not getting correct output. there i am using if first.'emp id'n ne 1 then 'emp taget'n=0  condition. this condition was not working because the variable names that i mentioned as 'emp id'n and 'emp taregt'n. if I change variable names to emp_id and emp_target, the condition was working.... So  what's wrong with variable names????? ... View more

Dear Linlin.. For identifying purpose, that macro variable value showed in double quotes, actual values are stored like this.. aaa,bbb,ccc it won't include double quotes ... View more

Let me know you got the point or not.. if NO i'll try in other way... Regards,, Sanjeev ... View more

I am not sure whether you understand this  or not. but i tried my level best.... proc sql noprint;   select quote(trim(name)) into      :names separated by ','          from dictionary.columns                   where libname='WORK' AND memname='B'; In above code you are storing all name column values  into a macro variable with "," separator.. (the names will stores in this macro variable like this.."aaa,bbb,ccc,ddd".) create table temp as     select * from renames              where original in (&names); In above you are creating a temp dataset and here you are putting a condition where original values in names(name macro variable having all the name value in B data set). select catx('=',original,newname)     into :rename separated by ' '          from temp; Here you are creating another macro variable with name called "rename" and you are storing "original=newname" value into that macro variable. (the value will stores like this.."aaa=aaa1,bbb=bbb1...so on" proc datasets nolist lib=work;        modify b ;         rename &rename;         run;        quit; Here you are changing all the b data set name by using "rename" macro. Thank you.. Sanjeev ... View more

What you want to do exactly with code??? is there any error getting in this code??? ... View more

Not sure I understand what you are trying say. Can you  please explain..?? ... View more

Sorry TOM, i did't get you. insted of writing all the mail id's in "to=" option ,i am storing all the mail id's in a silgle macro variable and i am puting that variable in to= option. ... View more

I am using that macro variable in filename statement... filename email from="**************@####.com" to="&email"; ..............so on..... ... View more

YES.. i had faced this this question in  one interview..... ... View more