topic Re: encode64 in SAS Enterprise Guide

encode64

alepage — Thu, 24 Aug 2023 21:01:13 GMT

Hello,

I am trying to convert some string using encode64 but it does not seem to work.

length newString $200.;
%let client_id=cl8z50x6hs18bjfhvaiayktqb;
%let client_secret=c34e0aj4uokasfbe9zcgtcbjurt451mxzufyph7x3svn8i0htylg7dr1at4e;
newString=cats("&client_id.",":","&client_secret.");
call symputx('Basic_Auth',put(newString,$base64x64.));
%put &=Basic_Auth;
run;

Does someone know how to use this format

Re: encode64

ChrisHemedinger — Thu, 24 Aug 2023 21:08:06 GMT

When you say "it doesn't work" do you mean the result is not encoded, or that the API doesn't recognize it as valid?

Here's an example that I've used with a different API (Brightcove), but it may be similar to what Qualtrics needs.

data _null_; length cred $ 128; cred = "&client_id.:&client_secret."; call symputx('_bccred',put(trim(cred),$base64x256.)); run;

Re: encode64

Tom — Thu, 24 Aug 2023 21:49:21 GMT

You haven't posted working code so it is hard to tell what you are trying to do here.

To use data step statements, like CALL SYMPUTX() you need to have a data step.

Move any macro code to before or after the data step.

You defined NEWSTRING as length 200. You should not pass the trailing spaces to the PUT() function. You need to use a format width that is long enough to encode all 200 of those characters.

%let client_id=cl8z50x6hs18bjfhvaiayktqb;
%let client_secret=c34e0aj4uokasfbe9zcgtcbjurt451mxzufyph7x3svn8i0htylg7dr1at4e;

data _null_;
  length newString $200.;
  newString=cats("&client_id.",":","&client_secret.");
  call symputx('Basic_Auth',put(trim(newString),$base64x300.));
run;

%put &=Basic_Auth;

Result

423  %put &=Basic_Auth;
BASIC_AUTH=Y2w4ejUweDZoczE4YmpmaHZhaWF5a3RxYjpjMzRlMGFqNHVva2FzZmJlOXpjZ3RjYmp1cnQ0NTFteHp1ZnlwaDd4M3N2bjhpMGh0eWxnN2RyMWF0NGU=

Or you could just skip the data step code completely.

%let basic_auth=%sysfunc(putc(&client_id:&client_secret,$base64x300.));
%put &=Basic_Auth;