Thank you, Tom. Now I am much clearer about these macro functions. Really appreciate.  ... View more

Thank you, Tom. I see. %sysfunc(quote()) can keep macro values as what they are, including " " . I also tried just  put quote(&list); but error occurs 1 "A" "B" "C" --- 22 76 ERROR 22-322: Syntax error, expecting one of the following: a name, arrayname, _ALL_, _CHARACTER_, _CHAR_, _NUMERIC_. ERROR 76-322: Syntax error, statement will be ignored.   It seems %sysfunc is needed in macro invocation when quoting something. Thanks. ... View more

I see, thank you so much. I really appreciate. ... View more

Yes, you are right, ballardw. Actually I realized this point, but I don't know how to correct it, I mean how to use a macro to solve this problem. Now I got ideas from this post, thanks. ... View more

Hello Tom, thanks. Your way also worked perfectly. But I know nothing about %sysfunc and %qsysfunc, could you explain them? Thank you very much.   ... View more

Hello Shmuel, thanks. I tried your two ways and they both work perfect. One more thing, why do we need single quotation marks ' '? Could you please give me some explanation? Thanks. ... View more

Thanks for all help. Let me describe my question more clearly: data admit; input ID $4. Name :&$14. @23 Sex $1. Age Date Height Weight Actlevel $4. Fee 7.2; datalines; 2458 Murry. W M 27 1 72 168 HIGH 85.20 2462 Almers. C F 34 3 66 152 HIGH 124.80 2501 Bonaventure, T F 31 17 61 123 LOW 149.75 2523 Johnson, R F 43 31 63 137 MOD 149.75 2539 LaMance, K M 51 4 71 158 LOW 124.80 2544 Jones, M M 29 6 76 193 HIGH 124.80 ; proc print data=admit; where name="Murry. W"; title "print dataset with name: Murry. W"; run; proc print data=admit; where name in ("Murry. W", "Almers. C"); title "print dataset with name: Murry. W, Almers. C"; run; I have a dataset, called admit, and i want to print some records with where statement. The value of name can be one, like the first proc print; the name value might be two, like second print. Now I want to write a macro to combine these two cases. My macro is in the following: options symbolgen; %macro output(name=); title "print dataset with name: &name"; proc print data=admit; where name in ("&name"); run; %mend output; %macro output(name=Murry. W) But when I invoke the above macro, nothing comes out and even there is nothing showing up in LOG, so something must be wrong. Any suggestions? Thanks. ... View more

Thank you so much. This is what I want. ... View more

I see. Thank you so much. Now I am much clearer. Really appreciate it. 😁 ... View more

I see your meaning. Thanks. I might need to reconsider this problem and see if there is another way to solve it. Thanks. ... View more

You alignment values right, and there are distinct space in the from. Actually I like the same indent for all those values. Let me modify my question, so you can get more information.  Here is my original dataset: data a; input Family $1-4 color $ 6-12 Num; datalines; Xu                  5             Red    1             Blue   3 Chen              2           Yellow  0           White   1 ; I want my result to print like Xu               5    Red          1    Blue         3 Chen          2    Yellow     0    White      1 There are the same indents in front of color value. Any suggestions?   ... View more

I am working on a project now. I made one column, which was created by the other two, for example, the new column called A, the original two columns called A1 and A2. I want to print it like the following: When all values are from A1, JUST=L; when all values are from A2, I want to indent them a little bit. Let me modify my problem. data a; input Family $ color $; datalines; Xu Red Xu Blue Chen Yellow Chen White ; I want my result to show like: Xu Red Blue Chen Yellow White There are some indents for those colors. Any suggestions? Thanks. ... View more