Note also that if the encoded string is not an exact multiple of 4 bytes long then you need to append equal signs until it is so that the BASE64 string has the right number of bits to be split back into base256 strings. Example: 217 data test; 218 x='AB'; 219 encode = put(x,$base64x4.); 220 put encode=; 221 run; encode=QUI= NOTE: The data set WORK.TEST has 1 observations and 2 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 222 223 224 %let coded=QUI; 225 %let raw_length=%length(&coded); 226 %let actual_length=%eval((&raw_length+3)/4*4); 227 %put &=raw_length &=actual_length ; RAW_LENGTH=3 ACTUAL_LENGTH=4 228 %put %sysfunc(inputc(&coded,$base64x&raw_length)); 229 %put %sysfunc(inputc(&coded,$base64x&actual_length)); 230 %put %sysfunc(inputc(&coded===,$base64x&actual_length)); AB So make sure to figure out the right length to use and to append some equal signs. ... View more

Work! Thanks! i_column=1; _column_char='_payment'; payments.add_column('payment','float'); payments.add_column(_column_char,'float'); payments.add_column('payment'||i_column,'float'); my logs: payment payment payment _payment payment payment1 ... View more

Your data has to meet the integrity constraints defined for that table. Consult your DBA people, they should be able to help you make your data compatible. ... View more

Primary keys come from the database world, they are not a SAS thing.  Two different technologies!  You can fake it with: https://communities.sas.com/t5/Base-SAS-Programming/Primary-key/td-p/456421 @s_lassen   However why?  Start thinking SAS if your going to use SAS, its different technology to databases. ... View more

Your posted code has neither commas nor macro parameters.   But to answer you question. 1) Don't.  Why would you want to pass in commas in the value of a macro parameter?  If you need to pass in a list use a space or some other character as the delimiter in the list. 2) If you must you need to "protect' the comma in some way.   You can add quotes or parenthesis to the value. Just remember to either remove them (or don't add them) when you use the value. Or as a LAST resort you can add macro quoting around the value (or just the troubling values). %mymacro (parm1=space delimited list ,parm2=pipe|delimited|list ,parm3='single,quoted,list' ,parm4="double,quoted,list" ,parm5=(parentheses,around,list) ,parm6=%str(macro,quoted,list) );     ... View more

You need to explain what you are actually trying to do. Your posted code does not make much sense. Just read that code line by line and ask yourself what each line is doing. First you have wrapped the whole thing into a macro %DO loop. So I assume there is also a macro definition that this is part of. %macro xxx ; %do i=1 %to &count; ... %end; %mend xxx; %xxx; Let's ignore that as irrelevant to your question. So first you run this: %let data =%sysfunc(inputc("&&pfrbase64code&i", $base64x32767)); %let FILE = &path/file_&i..xml; FILENAME FILE "&FILE" encoding='wcyrillic' LRECL=32767; Not sure what the purpose of the first line is as it does not appear to be used any where.  The other two lines look like an attempt to define a fileref name FILE.   Then you create this dataset named TMP2 by using a macro variable named TMP2 that has not been referenced before. Not sure what purpose this step serves as the generated dataset is never used for anything. data tmp2; tmp2=translate(&tmp2,'&','"'); run; You then run another separate data step where it looks like your intent is to write to the fileref defined before. data _null_; file FILE LRECL=32767; length tm $32767; put "&tmp2"; run; But all you are trying to write is the unmodifed content of the previous read macro variable TMP2. So again what was the purpose of the first data step with its TRANSLATE() function call? You also define but never use a variable named TM.  Why is that line there?   ... View more

This is untested but should work.  Change this:   &decodedata,",   Use this instead:   %bquote(&decodedata),%str(%"),   If it's possible, I do agree with the others that claim you would be well-served by switching to SAS language instead of macro language. ... View more

What do you mean by "I need to get..."?  This is where posting test data as a datastep and what you want out is so important.  We are now all guessing what you want to do!  From what you post, it seems that you want to replace , with " ", which would be: want=tranwrd(have,',','" "'); Posting clear concise questions will get you clear concise answers. ... View more

Thanks so much! ... View more