BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
vrebeque
Fluorite | Level 6
Hello,
 
Im receiving this error when trying to input data into a decision tree model.
 
ERROR: The format $INARY could not be loaded in Cloud Analytic Services.
ERROR: Some formats could not be loaded in the Cloud Analytic Services.

My data don't have any format defined.

vrebeque_0-1666211206765.png

vrebeque_1-1666211231391.png

ods noproctitle;
ods graphics / imagemap=on;

proc treesplit data=VINCAS.B2B_BASE_PEDIDOS plots(only)=(wholetree zoomedtree);
	partition fraction(validate=0.3 seed=1);
	input data_pedido flag_aparelho valor_solicitado flag_60d num_linhas 
		flag_faturamento score_model_credito flag_manual cp_soci_num dt_fund_empresa 
		/ level=interval;
	input range_valor_solicitado range_linhas RISCO_aus risco_empresa_aus 
		empresa_tipo_aus faixa_score_aus modelo_porte_aus subsegmento_aus 
		flag_whitelist_bin REGIAO tempo_fundacao tipo_empresa CAPITAL_SOCIAL 
		faixa_fat_presu faixa_canal_risco / level=nominal;
	target flag_aprovacao / level=nominal;
	prune none;
	autotune tuningparameters=(maxdepth numbin criterion) objective=misc;
	score out=VINCAS.scored_temp;
	ods output VariableImportance=Work._Treesplit_VarImp_;
run;

proc sgplot data=Work._Treesplit_VarImp_;
	title3 'Variable Importance';
	vbar variable / response=importance nostatlabel categoryorder=respdesc;
run;

title3;

proc delete data=Work._Treesplit_VarImp_;
run;

 

1 ACCEPTED SOLUTION

Accepted Solutions
SASKiwi
PROC Star

At a guess, you have one or more character variables that TREESPLIT is trying to model as BINARY variables, so is trying to apply the numeric BINARY format to. Binary model variables need to be defined as numeric so these need to be converted first.

View solution in original post

2 REPLIES 2
SASKiwi
PROC Star

At a guess, you have one or more character variables that TREESPLIT is trying to model as BINARY variables, so is trying to apply the numeric BINARY format to. Binary model variables need to be defined as numeric so these need to be converted first.

vrebeque
Fluorite | Level 6

Thanks for answering Kiwi. I recoded the variables and setted the binary format and things worked. There was only one problematic variable actually but i didnt noticed.

 

vrebeque_0-1666292050199.png

 

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to choose a machine learning algorithm

Use this tutorial as a handy guide to weigh the pros and cons of these commonly used machine learning algorithms.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 1213 views
  • 2 likes
  • 2 in conversation