Hi Experts, I want to automat report  to export as following txt format to particular location  abc_202401 abc_202402 abc_202403 abc_202404 ........................ ....................... abc_202412   ... View more

options symbolgen mlogic mprint ; %let x = Tom&Harry; %put &x; Above macro not resolve how get correct the code ... View more

  data vertical_split; name = 'William Shakespeare'; length character $30; do i = 1 to length(name); character = substr(name, i, 1); output; end; drop i; run; proc print data=vertical_split noobs; run; required output    ame character William  W William  i William  l William  l William  i William  a William  m     Shakespeare S  Shakespeare h  Shakespeare a  Shakespeare k  Shakespeare e  Shakespeare s  Shakespeare p  Shakespeare e  Shakespeare a  Shakespeare r  Shakespeare e ... View more

Hi Experts,   data dsn; length string $26; string = 'abcdefghijklmnopqrstuvwxyz'; do i = 1 to length(string); if i =1 then do;from_string=substr(string,i-1);end; from_string = cat(substr(string, 1, i-1), substr(string, i+1)); extract_letter = substr(string, i, 1); output; end; drop i; proc print noobs; run; i want ouput like below i want extract each letter from string variable that letter should not be in from_string variabe         ... View more