About Brandon16

Brandon16 · ‎02-27-2018

We have a datAset loaded into SAS and I have written a PROC SQL to bring back the variables I need. I'm not sure what else I can provide you as I don't create/load the dataset stored within SAS.

Brandon16 · ‎02-27-2018

This is the datastep proc sql; create table test.testing as select distinct cmonth, contactnumber, pf, fymonth, from newtest_all group by cmonth;

Brandon16 · ‎02-27-2018

This is the Tabulate code which produces the first table output proc tabulate data = test.testing; class pf fymonth; var count percent; keylabel SUM = ' '; tables (pf="PF" * fymonth = "FYMonth"), (count="Count") (percent="percent"*f=8.3) /row=float; run;

Brandon16 · ‎02-27-2018

I have managed to resolve this by using / row=float; Thanks for all your help and suggestions.

Brandon16 · ‎02-27-2018

The problem is I am encountering these issues as the code develops so hard to foresee at the time what Is needed. Each post is at the time of a problem and as I am learning, I don't know what issue I will face next, hence the multiple threads.

Brandon16 · ‎02-27-2018

Hi, How do I change my tabulate from looking like this..... Count Percent PF FYMonth 120 0.946 A Dec-17 Jan-18 541 8 Nov-17 2 7 Oct-17 6 18 B Dec-17 2 0.327 Jan-18 2 28 Nov-17 276 1 Oct-17 2 7 C Dec-17 2 8 Jan-18 15 23.491 Nov-17 1 7 Oct-17 5 99 D Dec-17 41 8 Jan-18 2 8 Nov-17 1 0.046 Oct-17 4 8 E Dec-17 6 8 Jan-18 1 84 Nov-17 38 4 Oct-17 48 0.033 To this....... Count Percent PF FYMonth 120 0.946 A Dec-17 A Jan-18 541 8 A Nov-17 2 7 A Oct-17 6 18 B Dec-17 2 0.327 B Jan-18 2 28 B Nov-17 276 1 B Oct-17 2 7 C Dec-17 2 8 C Jan-18 15 23.491 C Nov-17 1 7 C Oct-17 5 99 D Dec-17 41 8 D Jan-18 2 8 D Nov-17 1 0.046 D Oct-17 4 8 E Dec-17 6 8 E Jan-18 1 84 E Nov-17 38 4 E Oct-17 48 0.033

Brandon16 · ‎02-26-2018

I have come across a nocellmerge but that isn't recognised within my code. I would love to know a way around this as it's very annoying how the data is now presented within excel. If anyone has any idea how to resolve this, I would be most grateful.

Brandon16 · ‎02-26-2018

No, never used either of those

Brandon16 · ‎02-26-2018

Using an ODS HTML BODY=filepath then ODMS HTML CLOSE - At the bottom of the tabulate

Brandon16 · ‎02-26-2018

That makes sense, thank you. I need to get the data currently in a dataset into a format where I can automate it into excel. Without using a Tabulate, im not sure how else I would go about doing it, any ideas at all please?

Brandon16 · ‎02-26-2018

Hi, How do you prevent a value from shifting up when my tabulate exports into Excel? Example below: I want the values 68 and 0.8746 to be in line with the row below Count Percent Value Month 68 0.8746 A Dec-17

Brandon16 · ‎02-26-2018

Hi, How do I create a proc tabulate with 23 columns (each column is a different variable)? I get an error saying their are too many dimensions when using a small sample below. proc tabulate data=test.testing; class pdte; var F1 F1V F2 F2V; table (pdte="2") * (F1="1") , (F1V="2") , (F2="3") , (F2V="4"); run;

Brandon16 · ‎02-26-2018

The data is already set out that way in production (I just sent dummy data across) and I want to create a tabulate on the back of the data but there will be too many dimensions (unless I am doing the tabulate wrong).

Brandon16 · ‎02-26-2018

Hi, I can't seem to get a SAS dataset working with an ODS HTML BODY= Any idea why this doesn't work please but does on tabulates? Thanks

Brandon16 · ‎02-26-2018

Hi, How do I create a proc tabulate by using the following code below proc sql; create table test.testing_one as select pdte, mnth, sum(fns) as test_fns, sum(val) as test_Val from test.testing group by pdte, mnth; to output like pdte mnth test_fns test_val 1 1 898 54545 1 2 45454 54548 Thanks

Online Status	Offline
Date Last Visited	‎03-07-2018 07:33 AM

Re: Unmerge Tabulate Variable

Re: Unmerge Tabulate Variable

Re: Unmerge Tabulate Variable

Re: Proc Tabulate Top row data shifts in Excel

Re: Unmerge Tabulate Variable

Unmerge Tabulate Variable

Re: Proc Tabulate Top row data shifts in Excel

Re: Proc Tabulate Top row data shifts in Excel

Re: Proc Tabulate Top row data shifts in Excel

Re: proc tabulate too many dimensions

Re: Unmerge Tabulate Variable

Re: Unmerge Tabulate Variable

Re: Unmerge Tabulate Variable

Re: Proc Tabulate Top row data shifts in Excel

Re: Unmerge Tabulate Variable

Unmerge Tabulate Variable

Re: Proc Tabulate Top row data shifts in Excel

Re: Proc Tabulate Top row data shifts in Excel

Re: Proc Tabulate Top row data shifts in Excel

Re: proc tabulate too many dimensions

Proc Tabulate Top row data shifts in Excel

proc tabulate too many dimensions

Re: Create a New Variable

ODMS HTML - SAS Dataset

Create a Proc Tabulate