topic Re: macro question in SAS Procedures

macro question

Tal — Mon, 29 Jul 2019 17:15:16 GMT

hi,

i hate when small things in SAS bother me 🙂

so this is a part of my code:

proc sql noprint;

select count(*) into :rowcount1 from xx.secured;

quit;

data _null_;

SET xx.secured;

file "/aa/bbb/ccc/ddd/test.txt" dlm='|';

if _n_ = 1 then

put "&sysdate9.|&rowcount1.|&sysuserid.";

put (_all_)(~);

run;

then the header in my output file will show something like
29JUL2019| 2936|abcdr4

then i would change the select into query to

proc sql noprint;

select strip(put((count(*),6.)) into :rowcount1 from xx.secured;

quit;

and I get this 29JUL2019|2936 |abcdr4

but i need to get this 29JUL2019|2936|abcdr4.

also ,can i capitalize the sysuserid in the put statement?

Any one please?

Thanks,

Re: macro question

novinosrin — Mon, 29 Jul 2019 17:16:48 GMT

Use Trimmed

proc sql noprint;

select count(*) into :rowcount1 Trimmed from xx.secured;

quit;

Re: macro question

Tal — Mon, 29 Jul 2019 17:59:53 GMT

thank you novinosrin!

and do you maybe know how I can capitalize the sysuserid with some changes in the put statement?

abcdr4 to ABCDR4

Re: macro question

novinosrin — Mon, 29 Jul 2019 18:10:18 GMT



data _null_;


put "&sysdate9.|%upcase(&sysuserid.)";

put (_all_)(~);

run;

It's a simple %upcase function.

Hi @Tal Tell you what, this is when @Kurt_Bremser 's maxims is so handy. I have it printed in my desk. It directs beautifully to look where for what. Slick stuff and you should get that too

Re: macro question

Kurt_Bremser — Mon, 29 Jul 2019 18:19:25 GMT

Find the link to what @novinosrin mentioned in my footnotes.

The SAS Global Forum paper is online at https://www.sas.com/content/dam/SAS/support/en/sas-global-forum-proceedings/2019/3062-2019.pdf

Re: macro question

Tal — Mon, 29 Jul 2019 18:20:00 GMT

thank you again but how I get to this article of his. He got many 🙂

Re: macro question

Tal — Mon, 29 Jul 2019 18:22:10 GMT

thank you 🙂

Re: macro question

novinosrin — Mon, 29 Jul 2019 18:50:52 GMT

Btw, so this would fall into Maxim 9

Honestly, it's so eloquent and a time saver. I use the Maxim 5 as the last option. For my convenience, I have sorted the maxims in my printed paper as 5th one to me is 52 the last one. 🙂 coz no need in asking if I can find it. In essence Maxim 9 or Maxim 7 answers/guides this thread