If your e-mail is of the form xyyyyy@domain.com (like jsmith@foobar.com ) you can use this to derive the email address from system variable _CLIENTUSERNAME:
/* determine email address from _CLIENTUSERNAME */
data _null_;
emailaddress=trim(compress(lowcase(substr(scan(&_CLIENTUSERNAME, -1),1,1)||scan(&_CLIENTUSERNAME, 1))||'@domain.com'));
firstname =trim(compress(lowcase(scan(&_CLIENTUSERNAME,-1))));
lastname =trim(compress(lowcase(scan(&_CLIENTUSERNAME,+1))));
call symput('firstname', trim(firstname));
call symput('lastname', trim(lastname));
call symput('emailaddress', trim(emailaddress));
run;
%put &=emailaddress;
Hi @tomrvincent. It looks like you're trying to post content that can be shared/library type reference code for people. This is a great idea, please consider posting them as Articles rather than posts. Posts are typically for questions. I also like to keep a set over on github, personal choice.
https://communities.sas.com/t5/SAS-Communities-Library/tkb-p/library
And add New Article.
Looking forward to seeing your posts!
I had never heard of or seen that...thanks for the suggestion.
just tried it...got this:
You have not yet achieved the experience level on the community to create your own article. Keep coming back and posting discussion topics though, and you'll earn it!
oh, well...
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.