About user021

user021 · ‎05-13-2023

@JeffMeyers Can you add option to calculate 95% CI of the mean for continuous variable, and 95% CI of the proportion for categorical variable?

user021 · ‎02-25-2023

Has SAS acknowledged this issue? They might not be aware of this if no ticket has been created for it. I have to downgrade my system to Windows 10 to be free of this annoying issue.

user021 · ‎02-08-2023

Have you reported this issue to SAS support and had a ticket created? There is definitely something not working very nicely between SAS and Windows 11. I suspect that Windows 11 introduced something new that caused this freeze/non response of SAS. BTW, I didn't notice this kind of freeze when copying in Office or UEStudio.

user021 · ‎02-08-2023

This happened to me as well. I just installed SAS 9.4 (TS1M7) to Windows 11 and noticed this freeze with SAS after copying anything within SAS.

user021 · ‎09-28-2022

I had this error, and it turns out that my SAS Universal Viewer is too old. After updating to the latest version, the error is gone. This way I don't need to do anything to the dataset. But if you only have access to an old version, then this can be a solution.

user021 · ‎09-28-2022

@JeffMeyers I want only Yes values of a Yes/No variable and I specified DIS_ORDER=2. It works, but can we have such an option to merge the row of Yes with the row of variable name in this scenario?

user021 · ‎08-26-2022

Hello @JeffMeyers, I think @Crystal_F meant to say 95% CI or CL (Confidence Limit) of MEAN for continuous variable. It is generated with CLM option of proc means. Can you add it as options of CL and MEAN_CL in this macro? Thank you!

user021 · ‎06-02-2022

Hello @JeffMeyers, Any chance a row total can be added? Right now the row total is included in the column label as (N=xxx). It's a pain to transfer those into a row total. Thank you!

user021 · ‎09-09-2021

@JeffMeyers I followed your advice on the pairwise comparison by duplicating corresponding group then using the COLBY option. The summary table is created successfully, but some columns are duplicated due to some group are duplicated. I want to remove those duplicated column and create a summary table look like below where pairwise p-values are on the right half. any advice? 2. I tried SHOWTOTAL=0 and the column for Total is gone, but when I used the option pvals=0, a blank column for p-value is still there. Is it supposed to be like that?

user021 · ‎08-06-2021

Hi @JeffMeyers Thanks for the awesome code. 1. It seems the option PVALDIGITS doesn't work well for me. When I add the option PVALDIGITS=2, all p values including the threshold are in 2 digits, while I want the threshold to be displayed as "<0.0001". Can you let the macro treat p value less than threshold and the rest differently by something like adding an option for threshold (threshold =[0.05, 0.001, et al])? 2. Is there a way to do pairwise comparison when the by group is more than 2?

user021 · ‎07-13-2018

Good news! It's fixed by following suggestion found here https://groups.google.com/forum/#!topic/comp.soft-sys.sas/iFieFW_jeNg proc template; delete Base.Freq.CrossTabFreqs ; run; cheers!

user021 · ‎07-13-2018

Thanks for the reply! I used the same code by copy and paste. I just noticed something in log and I'm looking for a fix online: 50 ; 51 52 proc freq data=Color; 53 tables Eyes Hair Eyes*Hair / out=FreqCount outexpect sparse; 54 weight Count; 55 title 'Eye and Hair Color of European Children'; 56 run; WARNING: Format pctfmt. failed to load! WARNING: Format pctfmt. failed to load! NOTE: There were 27 observations read from the data set WORK.COLOR. NOTE: The data set WORK.FREQCOUNT has 15 observations and 5 variables. NOTE: PROCEDURE FREQ used (Total process time): real time 0.17 seconds cpu time 0.04 seconds

user021 · ‎07-13-2018

This might not be a question on programming. I just had SAS 9.4 1M5 64 bit installed on a PC running Win 10. Then I followed the example below: http://support.sas.com/documentation/cdl/en/procstat/66703/HTML/default/viewer.htm#procstat_freq_examples01.htm The problem is, compared to what's online (Output 3.1.2: Crosstabulation Table), there are missing elements in my output: 1. variable names of those variables cross-tabled are missing 2. Percent and Col PCT are missing. There are only Count and Row % there. This is from a brand new restart of SAS without running anything else prior to this. I searched the web and this community but couldn't find a clue. Any idea? Thanks,

Online Status	Offline
Date Last Visited	‎05-26-2023 03:10 AM

Re: Demographic Table and Subgroup Summary Macro %TABLEN

Re: SAS9.4 freezes/non responding when copying

Re: SAS9.4 freezes/non responding when copying

Re: SAS9.4 freezes/non responding when copying

Re: SAS Universal Viewer v9.2: Unable to load table error

Re: Demographic Table and Subgroup Summary Macro %TABLEN

Re: Demographic Table and Subgroup Summary Macro %TABLEN

Re: Demographic Table and Subgroup Summary Macro %TABLEN

Re: Demographic Table and Subgroup Summary Macro %TABLEN

Re: Demographic Table and Subgroup Summary Macro %TABLEN

Re: SAS9.4 freezes/non responding when copying

Re: SAS Universal Viewer v9.2: Unable to load table error

Re: SAS9.4 freezes/non responding when copying

Re: SAS Universal Viewer v9.2: Unable to load table error

Re: Demographic Table and Subgroup Summary Macro %TABLEN

Re: SAS9.4 freezes/non responding when copying

Re: SAS9.4 freezes/non responding when copying

Re: SAS9.4 freezes/non responding when copying

Re: SAS Universal Viewer v9.2: Unable to load table error

Re: Demographic Table and Subgroup Summary Macro %TABLEN

Re: Demographic Table and Subgroup Summary Macro %TABLEN

Re: Demographic Table and Subgroup Summary Macro %TABLEN

Re: Demographic Table and Subgroup Summary Macro %TABLEN

Re: Demographic Table and Subgroup Summary Macro %TABLEN

Re: Elements missing in proc freq output

Re: Elements missing in proc freq output

Elements missing in proc freq output