topic Need help with the sas code for specifying all numerical variables in SAS Programming

Need help with the sas code for specifying all numerical variables

mdoddala — Wed, 06 Feb 2019 21:39:32 GMT

data dummy;
input q1 q3 q4 q2 q6$ bu$ q5;
cards;
1 2 3 5 sa an 3
2 4 3 6 sm sa 4
6 5 3 8 cb na 3
;
proc print;
run;

data dummy1 (drop= q1--q5);
set dummy;
sum=sum(of_numeric_);
proc print;
run;

Need help with this code. I'm getting a blank output for the sum variable.

Thanks,
Mohan

Re: Need help with the sas code for specifying all numerical variables

PeterClemmensen — Wed, 06 Feb 2019 21:43:16 GMT

Hi and welcome to the SAS Communities 🙂

Use an Array Statement to get all numeric variables and sum over the array

data dummy;
input q1 q3 q4 q2 q6$ bu$ q5;
cards;
1 2 3 5 sa an 3
2 4 3 6 sm sa 4
6 5 3 8 cb na 3
;

data dummy1;
   set dummy;
   array nums[*] _numeric_; 
   sum=sum(of nums[*]);
run;

proc print;
run;

Re: Need help with the sas code for specifying all numerical variables

mdoddala — Wed, 06 Feb 2019 21:43:26 GMT

Is it wrong to use of_numeric_?

Re: Need help with the sas code for specifying all numerical variables

novinosrin — Wed, 06 Feb 2019 21:45:21 GMT

Hi @mdoddala Your code is fine and works well.. just a typo


data dummy;
input q1 q3 q4 q2 q6$ bu$ q5;
cards;
1 2 3 5 sa an 3
2 4 3 6 sm sa 4
6 5 3 8 cb na 3
;


data dummy1 (drop= q1--q5);
set dummy;
sum=sum(of _numeric_);
run;

The typo was

sum=sum(of_numeric_);

instead of

sum=sum(of _numeric_);

Re: Need help with the sas code for specifying all numerical variables

PeterClemmensen — Wed, 06 Feb 2019 21:46:12 GMT

No. Not at all. Just an alternative 🙂 Your code works well too if you correct a small typo:

data dummy;
input q1 q3 q4 q2 q6$ bu$ q5;
cards;
1 2 3 5 sa an 3
2 4 3 6 sm sa 4
6 5 3 8 cb na 3
;

data dummy1;
   set dummy;
   sum=sum(of _numeric_);
run;

proc print;
run;

Re: Need help with the sas code for specifying all numerical variables

mdoddala — Wed, 06 Feb 2019 21:47:46 GMT

Thank you so much @novinosrin 🙂 for pointing out my mistake.

Re: Need help with the sas code for specifying all numerical variables

novinosrin — Wed, 06 Feb 2019 21:48:26 GMT

You are welcome!

Re: Need help with the sas code for specifying all numerical variables

mdoddala — Wed, 06 Feb 2019 21:48:57 GMT

Thank you @PeterClemmensen 🙂

Re: Need help with the sas code for specifying all numerical variables

Andygray — Wed, 06 Feb 2019 21:55:27 GMT

Hello @mdoddala

Acknowledge @novinosrin 's answer by marking the answer as accepted though I don't think somebody who is prolific with super user status cares for credits. But that's ethic. That was a sharp catch.

Re: Need help with the sas code for specifying all numerical variables

mdoddala — Wed, 06 Feb 2019 21:56:52 GMT

I just did that:)

Re: Need help with the sas code for specifying all numerical variables

mdoddala — Wed, 06 Feb 2019 22:03:26 GMT

Also @novinosrin , what are the other ways I can use of _numeric_? Is it possible to use in proc print statement? Please let me know. Thank you very much again for your help:)

Re: Need help with the sas code for specifying all numerical variables

novinosrin — Wed, 06 Feb 2019 22:04:27 GMT

I assume other ways meaning other scenarios

Yes anywhere variable lists usage is permitted

for example

proc print data=dummy;
var _numeric_;
run;

proc print data=dummy(keep=_numeric_);
run;

and so on and so forth

Re: Need help with the sas code for specifying all numerical variables

novinosrin — Wed, 06 Feb 2019 22:06:28 GMT

data dummy;
input q1 q3 q4 q2 q6$ bu$ q5;
cards;
1 2 3 5 sa an 3
2 4 3 6 sm sa 4
6 5 3 8 cb na 3
;


data dummychar(keep=_char_) dummynumeric(keep=_numeric_);
set dummy;
run;

Re: Need help with the sas code for specifying all numerical variables

mdoddala — Wed, 06 Feb 2019 22:08:01 GMT

Thank you so much @novinosrin for enlightening me:)

Re: Need help with the sas code for specifying all numerical variables

mdoddala — Wed, 06 Feb 2019 22:33:32 GMT

Also @novinosrin, what books do you suggest for beginners like me to become an expert in SAS programming and how long will it take to become an expert?

Re: Need help with the sas code for specifying all numerical variables

novinosrin — Wed, 06 Feb 2019 22:39:39 GMT

Certainly I can suggest books but expertise I don't know how long. I think that's up to the individual.

SAS^® University Edition Compatible

The same question was asked by another user @new_sas_user_4 while ago And again, I will point you to @ShelleySessoms for the best advice on what SAS press can offer.

Re: Need help with the sas code for specifying all numerical variables

novinosrin — Wed, 06 Feb 2019 22:47:14 GMT

Hi @mdoddala

EXPERT level:

High performance coding

Get hold of

https://www.amazon.com/High-Performance-SAS-Coding-Christian-Graffeuille/dp/1512397490

Sir @ChrisNZ Would that be overwhelming for OP or can manage with slow reading ?

Re: Need help with the sas code for specifying all numerical variables

mdoddala — Wed, 06 Feb 2019 22:50:07 GMT

Thank you @novinosrin for the prompt response:)

Re: Need help with the sas code for specifying all numerical variables

ChrisNZ — Thu, 07 Feb 2019 00:59:57 GMT

@novinosrin Thank you so much for the recommendation. 🙂

The link to the latest edition is https://www.amazon.com/gp/product/179345647X

Some chapters are readily accessible to non-advanced users like common-sense or proc sort. Others are an opportunity to learn. 🙂

Re: Need help with the sas code for specifying all numerical variables

ShelleySessoms — Thu, 07 Feb 2019 12:31:55 GMT

Hi @mdoddala ,

@novinosrin has recommended the two books I would recommend. @ChrisNZ 's book is excellent, as is anything by Ron Cody. You can't go wrong with either.

Best of luck to you,

Shelley