communities.sas.comHome - SAS Support Communities

Community Home Welcome Getting Started Community Memo All Things Community SAS Customer Recognition Awards (2024) SAS Customer Recognition Awards (2023) SAS Community Library SAS Product Suggestions Upcoming Events SAS Customer Recognition Awards All Recent Topics Learn New SAS User SAS Software for Learning Community Ask the Expert SAS Certification SAS Tips from the Community SAS Training Programming 1 and 2 Advanced Programming SAS Academy for Data Science Course Case Studies and Challenges Trustworthy AI SAS Global Forum Proceedings 2021 Programming SAS Programming SAS Procedures SAS Enterprise Guide SAS Studio Graphics Programming ODS and Base Reporting SAS Code Examples SAS Web Report Studio Developers Analytics Statistical Procedures SAS Data Science Mathematical Optimization, Discrete-Event Simulation, and OR SAS/IML Software and Matrix Computations SAS Forecasting and Econometrics Streaming Analytics Research and Science from SAS SAS Viya SAS Viya SAS Viya on Microsoft Azure SAS Viya Release Updates Moving to SAS Viya SAS Visual Analytics Valentine’s Day Data Viz Challenge SAS Visual Analytics Gallery Your Journey to Success Administration Administration and Deployment Architecture SAS Hot Fix Announcements SAS Product Release Announcements SUGA Solutions Microsoft Integration with SAS Decisioning Data Management Customer Intelligence SAS Customer Intelligence SAS Customer Intelligence 360 Release Notes SAS 360 Match Risk and Fraud SAS Risk Management Fraud, AML and Security Intelligence Risk & Finance Analytics Insurance Fraud SAS Health SAS Health and Life Sciences SAS Life Science Analytics Framework Hubs Regional Hubs SAS User Groups SAS Community Nordic SAS Network for Women in Norway AML Nordic User Group SAS Japan SAS Korea CoDe SAS German SAS Plattform Netzwerk SAS Brazil Community SAS Spanish Community SAS Users Group in Israel Polish SAS Users Group SAS User Group UK & Ireland 欢迎来到SAS中文社区！ SAS User Group Middle East Special Interest Hubs SAS Innovate 2024 SAS Explore SAS Analytics Explorers The Curiosity Cup SAS Hacker’s Hub SAS Inner Circle Panel SAS Hackathon Team Profiles (Past) Sign In SAS Support Community Get SAS tips, share your knowledge, and find out about upcoming SAS-related events. cancel Turn on suggestions Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. Showing results for Search instead for Did you mean: Start a discussion 57,412 Solutions 7,034 Library Articles 2,045 Users online 34 Groups Recent Solutions Using SGPANEL, how can I highlight specific panels? Answered in Graphics Programming Summary of ANOVA summary - put p value and R squared in the same tabl… Answered in SAS Programming SAS Enterprise Guide Files Not Opening Separately Answered in SAS Enterprise Guide connect files from a web server Answered in SAS Programming All recent solutions Featured Article Relaunch of the SAS Developer Portal Recent Library Articles Recently in the SAS Community Library: @joeFurbee debuts the new SAS Developer Portal. Check it out. Featured Webinar How Do I Manage My SAS® Viya® Environment? Q&A, Slides, and On-Demand Recording Ask the Expert Watch on demand. Recent Activity Most Recent Most Recent Most Liked Solved No Replies Yet Truncation of Data Merging Datasets Cutting Off Character Hello, I am getting the following error messages when trying to merge two datasets. One of the datasets I am getting from a csv file, so maybe the issue could be there? I was trying to specify the length of the PID variable for the redcap_sort dataset from the redcap one, which is the one we got from the csv file. However, I keep getting messages that the variable has multiple lengths and it keeps truncating the data. Any PID after 999 gets shortened. So 1000 and 1001 become 100, 1010 becomes 101, etc. Any help or a nudge in the right direction would be greatly appreciated, thank you so much. Edit: The programming with the csv file already has: data work.redcap; %let _EFIERR_ = 0; infile &csv_file delimiter = ’,’ MISSOVER DSD lrecl=32767 firstobs=1 ; informat pid $500. ; informat pid_ini $500. ; and the code for format: format pid $500. ; It has this for all the variables. I thought the above code would make it so that the variables would have that limit of 500 characters? ... View more By sassy_seb Fluorite | Level 6 SAS Programming 37m ago 0 2 proc causaltrt and stabilized ipw weights Hi, I’m wondering if the IPW weights which are output after running proc causaltrt (method=AIPW) are stabilized weights? In the user guide, I can’t seem to find an option to request stabilized weights, and after running this proc, the mean for my IPW is slightly greater than 1 (as there are a few observations with quite extreme IPW values). Thank you in advance, ... View more By Epi_Stats Obsidian | Level 7 Statistical Procedures Sunday Tags: causaltrt ipw proc stabilized statistics weights 0 1 creating dataset to use for chi squared test of proportions I’m trying to follow the code on this site Test for the equality of two proportions in SAS - The DO Loop for the section called A chi-square test for association in SAS. I basically need to compare the proportion in one area which was tested for something to the proportion in another area which was tested and see if they are significantly different proportions, but I can’t get the code to work right. I get this error: NOTE: Invalid data for N in line 79 1-6. RULE: +1+2+3+4+5+6+7+8+9+0 79 CountyB Yes 71 Group=CountyA Seq=No N=. _ERROR_=1 _N_=2 NOTE: SAS went to a new line when INPUT statement reached past the end of a line. My full code is: data underfive; length Group $15 Test $3; input Group Test N; datalines; CountyA Yes 55 CountyA No 45027 CountyB Yes 71 CountyB No 311726; Once I had that in I figured I would run this: proc freq data=underfive order=data; weight N; tables Group*Test/chisq; run; ... View more By Geoghegan Obsidian | Level 7 Statistical Procedures 3 hours ago 0 8 Using SGPANEL, how can I highlight specific panels? I’m using SGPANEL, and would like to highlight certain panels that are interesting. I think I just want a way to set the wallcolor for each panel dynamically, is that possible? Below code will make 3 panels, and all three will have the wallcolor set to yellow: data have ; input panelid x y ; cards ; 1 10 10 1 20 20 2 10 15 2 20 15 3 10 20 3 20 10 ; proc sgpanel data=have ; panelby panelid/ layout=panel; styleattrs wallcolor="yellow" ; series x=x y=y; run ; Is there a way I can make only the second panel have a yellow wallcolor? I tried using a band plot in the background, which came close, but still extended the y-axis even though I set option NOEXTEND. I’m sure I could try other methods for adding a yellow bar in the background of second panel (e.g. REFLINE instead of a BAND), but before I go down that path, wondered if I’m missing an easier way. My band plot approach: data want ; set have ; if panelid=2 then do ; lowerband=0 ; upperband=100 ; end ; run ; proc sgpanel data=want ; panelby panelid/ layout=panel; band x=x lower=lowerband upper=upperband /fillattrs=(color=yellow) noextend; series x=x y=y; run ; Returned: ... View more By Quentin Super User Graphics Programming yesterday 1 6 Clarification of Unsolved Gambling Analysis Issue Hi, all. My last post (https://communities.sas.com/t5/SAS-Programming/Calculate-How-Prior-Bet-Profits-Losses-Influence-Future-Betting/m-p/928006#M365143) went unsolved (thanks very much to those who gave it a look). I am clarifying here and asking for additional help. Unnecessary columns have been removed and desired calculations are now described within the datalines. Description: When a gambler decides how much to bet, their decision is influenced by their prior wager outcomes (perhaps they start to double down if they have sustained losses, for example), and I am trying to examine how NFL gamblers’ prior betting profits/losses influence their next-round-of-betting behavior. I need a...