@tress wrote: Many of these columns are categorical, with more than 100 unique values each. My issue arises when I try to apply one-hot encoding to these categorical columns. It seems like I’m running into the curse of dimensionality problem, and I’m not quite sure how to proceed from here. You can do level clustering (taking the target variable into account) on your class (categorical) inputs. Something simpler (and unsupervised) is the Group Rare Levels Transformation (for class variables only). This method combines the rare levels (if any) into a separate group, _OTHER_. Rare levels are the variable values that occur less than the specified cutoff value. I would start with a cutoff value of 5% (0.05). BR, Koen ... View more

@rs72 wrote: I get log message as- "link Stat.Logistic.Graphics.EffectCont to Common.Zreg.Graphics.EffectCont;" can someone tell me what does this above log message means ? So you are trying to get the "source code" of the logistic regression effect(s) plot in "&path/reg.txt" but reg.txt is empty ... i.e. no code in it. Correct?   I think you should open a Technical Support track in your country to address this. I don't know what that log message means. You can use the SAS Customer Service Portal (customer portal) for that.        The new customer experience is here        By Kimberly May on SAS Users August 21, 2023 https://blogs.sas.com/content/sgf/2023/08/21/the-new-customer-experience-is-here/   Some general tips : Unless you are determined to use PROC TEMPLATE, it would maybe be easier to save the graph's data (graph = effect plot) using ODS OUTPUT and produce the desired graph with PROC SGPLOT. The documentation for the EFFECTPLOT statement shows the graph names in this section: ODS Graphics: EFFECTPLOT Statement https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/statug/statug_introcom_sect029.htm Please see the following usage note which addresses how you can modify an ODS graph or save its data and reproduce it in the desired form:    http://support.sas.com/kb/24529 The answers to many questions can be found in the Samples and SAS Notes in our searchable knowledgebase, http://support.sas.com/notes.  You can use the search engine there to find the answers you need. BR, Koen ... View more

Hello,   The Model Repository service is always available, so you can still register models if SAS Model Manager is not licensed. So far, so good.   You should have a ModelStore CAS library to the /opt/sas/viya/config/data/modelsvr/astore directory. Don't you see it in the libraries pane after submitting   caslib _all_ assign; ?     Here's where access to registered models is discussed : SAS® Viya® 3.5 Administration Models -- Access to Models https://go.documentation.sas.com/doc/en/calcdc/3.5/calmodels/n1hl4mghwofk6qn1mdih1aezgbtl.htm   I can have a more detailed look on Monday or Tuesday. I think @SophiaRowland can help you out as well.   Koen ... View more

Google search: separate "first name" +"middle name" and "last name" site:communities.sas.com Koen ... View more

Google search: bayesian t-test site:communities.sas.com Koen ... View more

Usage Note 22561: Testing the equality of two or more proportions from independent samples https://support.sas.com/kb/22/561.html Test for the equality of two proportions in SAS By Rick Wicklin on The DO Loop July 5, 2017 https://blogs.sas.com/content/iml/2017/07/05/test-equality-two-proportions-sas.html Chi-square tests for proportions in one-way tables By Rick Wicklin on The DO Loop October 1, 2018 https://blogs.sas.com/content/iml/2018/10/01/chi-square-tests-for-proportions-one-way.html Simultaneous confidence intervals for multinomial proportions By Rick Wicklin on The DO Loop February 15, 2017 https://blogs.sas.com/content/iml/2017/02/15/confidence-intervals-multinomial-proportions.html Funnel plots for proportions By Rick Wicklin on The DO Loop November 23, 2011 https://blogs.sas.com/content/iml/2011/11/23/funnel-plots-for-proportions.html Should you use the Wald confidence interval for a binomial proportion? By Rick Wicklin on The DO Loop April 17, 2023 https://blogs.sas.com/content/iml/2023/04/17/wald-interval-binomial-proportion.html You might need to correct for multiple testing (inflation of the type I - error = false positive rate).   Koen ... View more

@SAS-questioner wrote: 3. Since the polytomous outcome is a three-level categorical outcome, why in the odds ratio output, there is only one odds ratio for group and time each? In this case, how to interpret the 'median', and 'low' using odds ratio? For example, comparing group 1, group 0 was 3 times more likely be in the 'large'. But how to find out the odds ratio for 'median'/'low'? Home > Analytics > Stat Procs > Obtaining odds ratio estimates for each level of ordinal variable in PROC GLIMMIX https://communities.sas.com/t5/Statistical-Procedures/Obtaining-odds-ratio-estimates-for-each-level-of-ordinal/td-p/725370   BR, Koen ... View more

Oh sorry. You want horizontal stacking (instead of vertical).  PROC APPEND cannot do this. Let me re-write.   Koen ... View more

I think you are talking about calling a decision flow that was set up with SAS Intelligent Decisioning (SAS Viya). Therefore I am moving this topic to the "Decisioning"-board under the Solutions header in the menu bar.   Koen ... View more

proc datasets library=work NoList NoDetails memtype=data; delete want; run; QUIT; proc append base=want data=df_a; run; proc append base=want data=df_b; run; Koen ... View more

@Franck1048 wrote: I can't reproduce a window arrangement to see the explorer, code, log and result viewer at the same time.  Explorer + Code + Log ... Yes, you can.  I think adding the Results Viewer in the same browser screen (additional to Explorer + Code + Log) is not possible indeed.   SAS Studio allows you to : move tabs to be horizontally aligned (on top of another) or horizontally aligned (next to each other). Just by dragging. change the preferences (Options > Preferences). Options > Preferences > SAS Programs : you can choose no split (single), a vertical split or a horizontal split for tab layout. But ... as said before ... always having the Results (even when there are none) next to Code & Log is not possible. You claim there's only one coding interface (being SAS Studio) to SAS Viya , but that's not true. There are several coding interfaces (Integrated Development Environments = IDEs) that you can use: there is SAS Studio there is a SAS Extension for Visual Studio Code there is Enterprise Guide access to Viya 4 you can use Jupyter Notebook you can also set up NotePad++ as an editor you can use RStudio with SAS Viya ... probably there are other ways for coding against SAS Viya. Koen ... View more

@lucymonoana wrote: Please if you have any advise for me a new SAS user on how pass my very first Base SAS exam, how to prepare,I will very much appreciate it. Hello @lucymonoana . Welcome ! I understand you want to pass a Base SAS certification exam. Please note there's a board within this SAS Communities that is dedicated to Certification.   Home > Learn SAS > SAS Certification https://communities.sas.com/t5/SAS-Certification/bd-p/certification   Koen ... View more

Can you copy / paste the full code (as part of the full log)?   Copy in EGuide Then use the </> icon in the header  Then paste in the pop-up window. (Avoid screenshots here)   Thanks, Koen ... View more

@LuGa wrote: SAS still ignores multiple ERROR statements and executes procedures on empty data objects. Empty data objects ???? You mean SAS activates OBS=0 option and puts itself in syntax-check modus when a critical error is met?   You don't like that behavior? Why don't you enable ERRORABEND option?   You can also play with (no)replace option or repempty= data set option. REPEMPTY= Data Set Option --> Specifies whether a new, empty data set can overwrite an existing SAS data set. You can also work with %GOTO EXIT; like here : SAS® 9.4 and SAS® Viya® 3.5 Programming Documentation Example: Providing Exits in a Large Macro https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/mcrolref/p0jfeh75p72icen1ddd9una5zbmm.htm   Koen ... View more