topic Re: how do we separate numeric variables and character variables from a dataset to other two dataset in SAS Programming

how do we separate numeric variables and character variables from a dataset to other two datasets?

rajeshalwayswel — Mon, 30 Oct 2017 04:40:31 GMT

How do we separate numeric variables and charcter variables from a dataset to other tow dataset one with numeric and one with character variables?

Re: how do we separate numeric variables and character variables from a dataset to other two dataset

andreas_lds — Mon, 30 Oct 2017 04:54:34 GMT

I can't imagine any reason to do this, except for using proc iml.

Untested code:
data onlyChar(keep= _character_) onlyNum(keep= _numeric_) ;
set have;
run;

Not sure that _character_ and _numeric_ can be used in this place. If not you have to query sashelp.vcolumn twice and create two macro-variables containing the variable names. Something like
proc sql noprint ;
select name into :charity separated by " "
from sashelp.vcolumn
where memname = upcase("want") and type = "num" ;
Quit;

I am sure you figure out the second select by yourself.

Re: how do we separate numeric variables and character variables from a dataset to other two dataset

rajeshalwayswel — Mon, 30 Oct 2017 05:28:11 GMT

Thank's... you written in data step it really helpful.....