About Scorpx

Scorpx · ‎05-16-2023

This is the answer. Thank you. Yes, I wanted just one variable with one value: As I mentioned: I want to create just one variable without the duplicates Next time I will try to provide better explanations. Thank you for your time.

Reeza · ‎05-09-2022

Transpose before you get the PROC TABULATE results. When you have missing values in CLASS statements that row will get excluded from all values, which means your values will be wrong. So as stated you have two options - either call proc tabulate for each variable alone. Or transpose and then do a proc tabulate. Since you're proc transposing after, this is the better option but you should also check the PROC FREQ code I posted which could help you avoid this all together.

ballardw · ‎01-05-2021

@Scorpx wrote: Thanks Reeza, I will accept your answer as the solution due to the examples you gave me. Evidently, the solution was easier than what I thought it should be. Large economy sized hint: When you start wanting to do the exact same thing to multiple variables some solution involves one or more arrays. There are may be other approaches but arrays are very powerful.

Scorpx · ‎01-01-2021

Thanks a lot!

PaigeMiller · ‎04-22-2019

This particular example could be "replicated" (maybe not exactly) via PROC TABULATE or PROC REPORT, and in each you can color code certain cells (or make the number bold, or change the color of the numbers, etc.) based upon whatever criteria you want, in this case statistical significance.

Scorpx · ‎01-30-2019

Thank you Tom, I did work with your suggestion!

Online Status	Offline
Date Last Visited	‎05-16-2023 05:39 PM

Re: merge columns in the same dataset without duplicates

Re: merge columns in the same dataset without duplicates

Re: merge columns in the same dataset without duplicates

Re: merge columns in the same dataset without duplicates

merge columns in the same dataset without duplicates

Re: Why the class statement in Proc Tabulate mess the code?

Why the class statement in Proc Tabulate mess the code?

Re: if/then macro consecutive variable creation

Re: if/then macro consecutive variable creation

if/then macro consecutive variable creation

Re: Nested %do %while-loops inside a macro

Nested %do %while-loops inside a macro

Re: merge columns in the same dataset without duplicates

Re: Why the class statement in Proc Tabulate mess the code?

Re: if/then macro consecutive variable creation

Re: Show several variables with the same scale on the same table

Re: How to flag/highlight statistical significance on the same table

Re: Nested %do %while-loops inside a macro