About Will_FBB

Will_FBB · ‎04-02-2021

I need to add more blank space above so Male column and Female column would be farther apart from each other. Can someone please help? Here is the code: data job_1; input dem $ year apply_count interviewed_mean hired_mean; select(first(dem)); when('M','F') gr=1; otherwise gr=2; end; datalines; Male 2013 288 0.15972 0.21739 Female 2013 61 0.09836 0.33333 Male 2014 279 0.19355 0.2963 Female 2014 59 0.25424 0.26667 Male 2015 293 0.18089 0.28302 Female 2014 61 0.27869 0.17647 Degree 2017 108 0.28704 0.19355 NoDeg 2016 241 0.08714 0.28571 Degree 2018 108 0.36111 0.28205 NoDeg 2019 230 0.13043 0.3 Degree 2020 124 0.23387 0.2069 NoDeg 2021 230 0.17826 0.29268 run; proc computab data=job_1; columns m f ; columns m/'Male'; columns f/'Female'; rows apply_count/'# Apps'; rows interviewed_mean/'Interviewed' ul; rows hired_mean/'Hired' dul; m=dem='Male'; f=dem='Female'; run;

Will_FBB · ‎03-30-2021

yes, I have. It didn't do anything.

Will_FBB · ‎03-30-2021

Item 1 - 7, subtotal, total on the report output.

Will_FBB · ‎03-30-2021

how do I move item list above to the left instead of sitting in between numbers. Thanks proc computab data=rpt_data cspace=1 CWIDTH=4 ; columns act bud var ytdact ytdbud ytdvar / /*zero=' '*/; columns act--var / format=negparen14.0 mtitle="- Month to Date: &mon_char -" ; columns ytdact--ytdvar / format=negparen14.0 mtitle='- Year To Date -'; columns act ytdact / 'Actual' f=negparen14.0; columns bud ytdbud / 'Budget' f=negparen14.0; columns var ytdvar / 'Var' f=negparen14.0; columns act--ytdvar / '-'; columns ytdact / _titles_; retain curmo &mon_num; /* current month: February */ rows x1 / ' ' ' Item 1'; rows x2 / ' Item 2' ; rows x3/ ' Item 3' ; rows x4 / ' Item 4' ; rows x5/ ' Item 5' ; rows x6/ ' Item 6' ; rows x7/ ' Item 7' ; rows subtotal/ ' Subtotal' ul; rows total/ ' Total' dul ; act = type = 'Actual' & month(rpt_dt) = curmo; bud = type = 'Budget' & month(rpt_dt) = curmo; ytdact = type = 'Actual' & month(rpt_dt) <= curmo; ytdbud = type = 'Budget' & month(rpt_dt) <= curmo; rowcalc: subtotal=x3+x4+x5+x6+x7; total=x1+x2+subtotal; colcalc: var = act-bud; ytdvar=ytdact-ytdbud; run;

Will_FBB · ‎09-06-2019

Thank you so much! this works perfectly!!

Will_FBB · ‎09-06-2019

How do I calculate y so the first ID will be equal to x, while the subsequent y in Month 2 - 10 will be previous y - previous a - previous b - previous c for each ID? I am not sure if lag function is the best solution for this, it does not calculate the way I wanted. data test; set test_data end=eof; by ID; do _n_=1 until (eof); if first.ID then y=x; y+lag(y)-lag(a)-lag(b)-lag(c); output; end; run; attach shows finished table that I want (before and after)

Will_FBB · ‎08-20-2019

I know if I clean the data, it will come out okay. I just wonder there might be some system setting that I could adjust. Thanks for your input!

Will_FBB · ‎08-19-2019

this is proc tabulate result, this shows you it has valid value for month 48 - 49

Will_FBB · ‎08-19-2019

I think there is a misunderstanding here. When I say month 48 and 49 are missing, I mean the entire fields are missing. After transpose, month 1 - 49 would become field names. Field/Column 48 and 49 are just not there in the output data table.

Will_FBB · ‎08-19-2019

It has thousands of ID in the data set, it misses some months here and there for some ID's, but it does have ID's that have valid values from month 1 - 49. If I have to clean up the data first, it almost defeat the purpose of using transpose.

Will_FBB · ‎08-19-2019

Will_FBB · ‎08-19-2019

I have 49 month on the data set ( 1 - 49 vertically), when I transpose the data set, I can see month 1 - 47 horizontally as expected but missing month 48 and 49. Does anybody have any idea what might cause this? I already tried to fill blank values with dummy numbers. proc transpose data=test out=test_t; id month; by ID; var sale; run; Thanks in advance.

Online Status	Offline
Date Last Visited	‎05-22-2025 02:53 PM

Insert Blank Space on Proc Computab

Re: Proc Computab - move item list to the left

Re: Proc Computab - move item list to the left

Proc Computab - move item list to the left

Re: Lag in Data Loop

Lag in Data Loop

Re: Proc Transpose Missing Field

Re: Proc Transpose Missing Field

Re: Proc Transpose Missing Field

Re: Proc Transpose Missing Field

Re: Insert Blank Space on Proc Computab

Insert Blank Space on Proc Computab

Re: Proc Computab - move item list to the left

Re: Proc Computab - move item list to the left

Proc Computab - move item list to the left

Re: Lag in Data Loop

Lag in Data Loop

Re: Proc Transpose Missing Field

Re: Proc Transpose Missing Field

Re: Proc Transpose Missing Field

Re: Proc Transpose Missing Field

Re: Proc Transpose Missing Field

Proc Transpose Missing Field