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

Hi guys, Which best for optimization code  KEEP statement  DROP statement Could you explain in PDV execution  If we use drop input stack read drop varibales or not  which is best  ... View more