About eyespike1

eyespike1 · ‎01-26-2015

For each ID there will only be one Gender value and one Education value like the combined columns below. id Gender Combined Gender1 Gender5 Education Combined Education1 Education5 1 F F 1 1 2 F F 2 2 3 F F 3 3 4 F F 3 3 5 F F 1 1 6 M M 1 1 7 F F 8 F F 1 1 9 F F 1 1 10 F F 2 2 11 F F 1 1 12 F F 1 1 13 M F M 3 3 3 14 F F 1 1 15 F F 1 1 16 F F 1 1

eyespike1 · ‎01-26-2015

Yes, the variables are in the same data set.

eyespike1 · ‎01-26-2015

Hi, I hope I am posting in the correct area. I would like to combine Gender1 and Gender5 with Gender5 being the winner if there is a value in both. Also for Education1 and Education5. Is this possible in EG or EM? I would do this in excel, but there are about 20 columns i would like to combine. Any help would be appreciated. Thanks! Seth id Gender1 Gender5 Education1 Education5 1 F 1 2 F 2 3 F 3 4 F 3 5 F 1 6 M 1 7 F 8 F 1 9 F 1 10 F 2 11 F 1 12 F 1 13 F M 3 3 14 F 1 15 F 1 16 F 1

eyespike1 · ‎04-09-2014

Hi Miguel, I have added a Metadata node and can now see the output variables with their roles and levels. I'm not sure how to "save" the roles and levels to be applied to a newly added dataset. Do I export path as a SAS program then add that as a node? Thanks! Seth

eyespike1 · ‎04-08-2014

Hi, I am currently using RPM in Excel to create a basic model. I am then using Enterprise Miner 12.3 to tweak the model and use scoring and code nodes. When you open the RPM Diagram in Enterprise Miner it has a temporary dataset WORK._EXCEL_. Since the dataset is temporary I have been replacing the node with a file import node. When I import the new file (which is the same as the temp file) using the file import node, existing roles and levels are lost. Is it possible to copy them so I don't have to make the changes again? Hope this makes sense. Thanks! Seth

eyespike1 · ‎11-05-2013

Hi Kanyange I have success doing it this way: Click on File then select Save Diagram "Response Model 1" as xml. Then Click on File and Import Diagram from XML. Select the "Response Model 1.xml" file. Hopefully this works for you. Seth

eyespike1 · ‎10-31-2013

Hi, we just installed EM 12.3 previous version EM 12.1 When importing excel files I am seeing the following error in the log file: The SAS/ACCESS Interface to PC Files is not installed. Please install this module in order to IMPORT/EXPORT to these file types. I am able to import text files. I have installed the SAS drivers for ODBC "Client Version" but the error persists. This is a stand alone workstation version with no connections to external servers. 64 bit. Thanks for any help Seth

eyespike1 · ‎09-17-2013

Hi, Yes the first 3 would be good... but I also think ((latest month) minus (Average of first month through latest month)) would be a good demonstration of growth/loss.

eyespike1 · ‎09-17-2013

Hi, unfortunately we are not licensed to use Time Series Analysis. Seth

eyespike1 · ‎09-12-2013

Hi Tom, Thanks for reply. All the clients in the file, the flat file is less that 50,000 records currently in excel. Annual periods. This is what my data looks like: ID 08_31_2012 09_30_2012 10_31_2012 11_30_2012 12_31_2012 01_31_2013 02_28_2013 03_31_2013 04_30_2013 05_31_2013 06_30_2013 07_31_2013 410764 358 317 327 167 167 379 336 349 363 369 327 348 89254 303 261 303 98 98 279 227 272 275 274 291 317 65320 233 211 234 101 101 280 250 264 267 304 263 302 163328 218 188 227 98 98 249 230 227 251 246 238 277 36919 174 198 243 80 80 218 203 210 236 211 197 232 28341 78 159 207 61 61 177 171 183 191 179 180 204 448691 32 32 56 60 83 179 192 Thanks! Seth

eyespike1 · ‎09-12-2013

Hi, did you ever get this figured out? I am doing something similar and would like some guidance. Seth

eyespike1 · ‎09-11-2013

Linlin and Anca tilea thank you both for the quick response! I was able to get both to work. Thanks! Seth

eyespike1 · ‎09-11-2013

Hi, EM newbie. I have a data set that has multiple observations. I want to consolidate the ID's and sum the corresponding Wire. I have been attempting to do it by attaching a SAS Code node to my file import node and running a PROC Sort command. I will then want to merge this data with another file. Is the PROC Sort command the right way to go, if so please help with syntax... or is there an easier way. Thanks! Seth Original Data Desired Output ID Wire ID Wire 18 1 18 1 77 2 77 8 77 6 110 14 110 5 116 1 110 9 378 0 116 1 667 1 378 0 667 1 667

Online Status	Offline
Date Last Visited	‎07-08-2016 03:09 PM

Re: Join Variables and Observations

Re: Join Variables and Observations

Join Variables and Observations

Re: Rapid Predictive Modeler Variables

Rapid Predictive Modeler Variables

Re: Duplicate a diagram in Enterprise Miner, Please Help. Many Thanks

SAS/ACCESS Interface to PC Files

Re: Trend Analysis- SAS Logic?

Re: Trend Analysis- SAS Logic?

Re: Trend Analysis- SAS Logic?

Re: Join Variables and Observations

Re: Join Variables and Observations

Join Variables and Observations

Re: Rapid Predictive Modeler Variables

Rapid Predictive Modeler Variables

Re: Duplicate a diagram in Enterprise Miner, Please Help. Many Thanks

SAS/ACCESS Interface to PC Files

Re: Trend Analysis- SAS Logic?

Re: Trend Analysis- SAS Logic?

Re: Trend Analysis- SAS Logic?

Re: Trend Analysis- SAS Logic?

Re: Multiple Observations

Multiple Observations