See this: FILENAME mail EMAIL TO=("name@place.com" "name2@place" "3" etc) CC=("Othername@place") SUBJECT="blah" CONTENT_TYPE="text/html" ATTACH="filename.csv" ; If I have a lot of recipients, and I keep them in a macro variable, I do this: %let rec=rec1@domain.com; %let rec=&rec rec2@domain.com; and so on. ... View more

Just wrap your condition inside of parentheses instead of quotes.   %test((ap_period='1234')) Also note that you can use named parameters in the macro call, even if the macro has it defined as a positional argument.  You just can't try to pass a value by position when the parameter is defined as named in the %macro statement. %test(where=ap_period='1234') ... View more

Use one the series of concatenate functions that SAS has.  1569 data _null_; 1570 do _n_=1 to 3 ; 1571 length formula $ 50; 1572 formula = cats('=CONCATENATE($B',_N_,',$G',_N_,')'); 1573 put _n_= formula = :$quote.; 1574 end; 1575 run; _N_=1 formula="=CONCATENATE($B1,$G1)" _N_=2 formula="=CONCATENATE($B2,$G2)" _N_=3 formula="=CONCATENATE($B3,$G3)" They will also silently convert numbers to strings for you unlike when you apply a character function like trim() to them.  But if your numbers are not integers or can get too big then you should use PUT() function to convert your numbers to string rather than letting SAS guess at what you want.   ... View more

@StaticFX wrote: Bingo! THANK YOU !!! whats the diff between Informat and Length? You use the LENGTH statement to define a variable. You tell it the type (character or numeric) and the number of bytes that you want it to use. You use the INFORMAT statement to attach an informat to the variable. An informat is instructions on how to convert text to the value to be stored.   The reason is mainly works to use INFORMAT when you mean LENGTH is because SAS will define a variable based on how you first use it.  So if the first use is in the INFORMAT (or FORMAT) statement then SAS will make a guess at what type of variable you wanted to create based on the informat (or format) you are attaching to it. ... View more

You also might try writing directly to a compressed file and see if that makes it faster.  The computer will probably spend more CPU cycles compressing the file, but much less time will be spend waiting for the data to be written to the disk. You could use the ZIP filename engine. And if you have at least SAS 9.4 M5 release you can use GZIP format which should be a little faster as it does not have the overhead of multiple file archives like ZIP format. %let path=%sysfunc(pathname(work)); filename csv "&path/class.txt"; proc export data=sashelp.class file=csv dbms=csv ; run; filename csvgz zip "&path/class.txt.gz" gzip ; proc export data=sashelp.class file=csvgz dbms=csv ; run; filename csvzip zip "&path/class.zip" member='class.txt' ; proc export data=sashelp.class file=csvzip dbms=csv ; run; ... View more

@StaticFX wrote: ahhh i dint see the n after thank you! that was driving me nuts!! 🙂 I am renaming it from the query too lol     PS: im looking for the person who started it! lol   Start with the person in your shop refers to "macros" the most. ... View more

The EDITOR is not SAS. ... View more