In EM, there is setting where you can find the default score cut above which your prediction is flagged as yes. Otherwise NO. I think that default is 0.5. Play with different cut-off values to see you can just manage away the problem. This is perfectly legal. Nobody says you have to accept 0.5 as cut-off. This is low-hanging fruit kind of approach.    A bit harder route is when you exhaust your play above and the symptom remains. To find out, take the validation data set from EM. Now the prediction 1 and 0 based on your 'optimized' score cut above is the new prediction target. Run another model, preferably intuitive decision tree which allows you see the drivers in the background. You cannot do this with your original target because that means you simply are adding a separate stand alone model alongside your ensemble.    Jia Xin ... View more

/*Check original Probability*/ proc freq data=sashelp.heart; table status; run; /*Start split dataset*/ data training validation test; set sashelp.heart; call streaminit(123); _id=rand('table',0.6,0.2,0.2); if _id=1 then output training; if _id=2 then output validation; if _id=3 then output test; run; proc freq data=training; table status; run; proc freq data=validation; table status; run; proc freq data=test; table status; run; ... View more

Hello,   Easy to do with an Enterprise Miner code node. I would give you the URL to SAS Code Node :: SAS® Enterprise Miner™ 15.2: Reference Help , but the SAS docu server is temporarily unable to service my request due to maintenance downtime.   I know the code node has an example on how to change the metadata of your variables. Look there !   Good luck, Koen ... View more

Does the information in this thread https://communities.sas.com/t5/SAS-Data-Science/How-to-set-a-class-as-a-Positive-class/td-p/360957 help? ... View more

Look for the 2020 Call for Content, which should open sometime over the summer, and submit your abstract, and a draft paper, if possible, sometime before the deadline. Thanks! Nancy ... View more

Sorry, late to the party.   Been to lots of SGF (SUGI before).   See if you can spend time with some of the SAS vets. They will normally have pins that indicate how many years. Talk to speakers afterwards and get some sit down advice. Also, once things start to end, they are found in the hotel bars nearby chatting. Everyone is normally friendly, just ask to join. Looks like a SAS coder, probably is.   I watch a lot of stuff via streaming now.   I spend a lot of time in the booth area and speaking to speakers. they are all very qualified.   Enjoy it. It is always a great time. ... View more

There are exams being held on Wednesday but currently they are all full. You can swing by the exam room or check-in area on Wednesday to see if anyone canceled last minute.    Good luck! ... View more

The simplest is to generate static HTML reports (in which you can easily embed hyperlinks for navigation). These files can be uploaded to an FTP server or copied to a UNC destination, as needed, as part of the reporting process, This can be done as often as you want by scheduling the reporting job. ... View more

This is NOT a csv file AT ALL. It's a tab separated file, so you need to treat it as such. The extension should be .tsv. And it's a Windows text file. Your infile statement therefore needs to be infile 'C:\myfolders\Lesson10_2016EPAfuelEconomy.csv' dlm='09'x termstr=CRLF dsd firstobs=2; And your input statement input dummy MfrName :$20. dummyc $ Carline :$20. dummyc $ dummyc $ EngDispl Cyl dummyc $ dummy dummy CombFE; followed by drop dummy dummyc; After copying your file to my server (binary mode), I ran this code data want; infile '$HOME/sascommunity/ahobby9.tsv' dlm='09'x termstr=CRLF dsd firstobs=2; input dummy MfrName :$20. dummyc $ Carline :$20. dummyc $ dummyc $ EngDispl Cyl dummyc $ dummy dummy CombFE; drop dummy dummyc; run; proc print data=want noobs; run; and got this result: Eng Comb MfrName Carline Displ Cyl FE FCA US LLC 4C 1.8 4 28 aston martin V12 Vantage S 6.0 12 14 ... View more

Thank you for plugging my new book, PROC Star!  I really appreciate it!   I hope all is well!   Kirk ... View more

The online version of the SAS Language Reference: Concepts is found here. ... View more