hello
im new to enterprise miner;
id like to know if this is posible to achieve the following in enterprise miner:
source data format:
policy_id policy_type customer_id
1 house 1
2 vehicle 1
3 life 1
4 house 2
5 vehicle 2
6 life 2
desired layout
customer_id no_of_policies_house no_of_policies_vehicle no_of_policices_life
1 1 1 1
2 1 1 1
?
if yes, how can this be achieved?
i apprieciate any tips
thx
rgds
Hey MB,
I don't think there is a way to transpose your data automatically in Enterprise Miner. Same as Jaap, I would prefer to do it in base SAS or Enterprise Guide.
How complex is this SAS transpose program that we need to write? Do you have a finite number of policy_type (house, vehicle, life), or your SAS program has to catch that? Are your records in order (by customer id)?
To get the transposed data set you want I would use a SAS data step with arrays.
This paper will get you started: Sharpening your skills in reshaping data: proc transpose vs array processing
If you run into trouble, the guys on this community are the bomb! SAS support community: SAS Macro, Data Step, and SAS Language Elements
This book is a fantastic read to start doing complex, efficient SAS programs in no time. Carpenter's Complete Guide to the SAS Macro Language
Good luck!
-Miguel
The Eminer is doing predictive analytics on prepared data. Preparing data is better to do with Eguide running SAS-base code. Yes you could define basic code nodes in Eminer as you could bake eggs on an Ipad.
Hey MB,
I don't think there is a way to transpose your data automatically in Enterprise Miner. Same as Jaap, I would prefer to do it in base SAS or Enterprise Guide.
How complex is this SAS transpose program that we need to write? Do you have a finite number of policy_type (house, vehicle, life), or your SAS program has to catch that? Are your records in order (by customer id)?
To get the transposed data set you want I would use a SAS data step with arrays.
This paper will get you started: Sharpening your skills in reshaping data: proc transpose vs array processing
If you run into trouble, the guys on this community are the bomb! SAS support community: SAS Macro, Data Step, and SAS Language Elements
This book is a fantastic read to start doing complex, efficient SAS programs in no time. Carpenter's Complete Guide to the SAS Macro Language
Good luck!
-Miguel
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.