About Brandon16

Brandon16 · ‎02-26-2018

Hi, I have this dummy code (only a section as this goes up to December) below where I have sum for each variable. How do I group this into one variable so my next part of code referencing the table will look at variable 'x' instead of having to type out each individual variable name again? I basically want sum(jancount) as onecount, sum(janvalue) as onevalue, sum(febcount) as twocount, sum(febvalue) as twovalue, sum(marcount) as threecount, sum(marvalue) as threevalue as all_data I hope that makes sense. proc sql; create table test.test_cas as select pydate, sum(jancount) as onecount, sum(janvalue) as onevalue, sum(febcount) as twocount, sum(febvalue) as twovalue, sum(marcount) as threecount, sum(marvalue) as threevalue from test.testing group by pydate;

Brandon16 · ‎02-22-2018

I think the issue is on our drive, I have moved location and it now works fine. Thanks anyway.

Brandon16 · ‎02-22-2018

I get this error message when running with that code 'body= ___ 22 202 16 ! 'KTY.HTML' ERROR 22-322: Syntax error, expecting one of the following: ;, (, ANCHOR, ARCHIVE, ATTRIBUTES, BASE, BODY, CHARSET, CLOSE, CODE, CONTENTS, CSS, CSSSTYLE, ENCODING, FILE, FRAME, GFOOTNOTE, GPATH, GTITLE, HEADTEXT, IMAGE_DPI, LAYOUT, METATEXT, NEWFILE, NOGFOOTNOTE, NOGTITLE, OPTIONS, PACKAGE, PAGE, PARAMETERS, PATH, RECORD_SEPARATOR, RENDER, STYLE, STYLESHEET, TEXT, TRANTAB. ERROR 202-322: The option or parameter is not recognized and will be ignored.

Brandon16 · ‎02-22-2018

Hi, I have multiple tabulates within my SAS code but when I come to connect it in excel via the web connection, I get this error message This file could not be accessed. Try one of the following: - Make sure the specific folder exisits - Make sure the folder contains the file is not read only - Make sure the file name does not contain any of the following charecters < > ? [ ] : | or * - Make sure the file/path name doesn't contain more than 218 charecters All of these seem fine so I am at a loss as to why it won't work. Any ideas please? This is the HTML SAS String used ods html body="X:/location/Dep/Area/KTY.HTML" style=HTMLBlue; Then closed off the tabulate with run; ods html close; I have tried to open it with Internet explorer and Chrome but neither work.

Brandon16 · ‎02-13-2018

Would it be possible (it not to much trouble please) to have a breakdown of what the code is actually doing for my development? Just conscious that if a change is required, I am not sure what to do.

Brandon16 · ‎02-13-2018

It does, I have just copied the code and re ran it, apologies. The code is spot on, thank you for your help, much appreciated

Brandon16 · ‎02-13-2018

Sorry, I hadn't updated the table correctly, the years are 2013 NOT 2017. So C_date and D_date are both 18/03/2013 not 18/03/2017. if any of the values match within A_count - G counts, I want the value that displays the latest date So in this example, as A_Count relates to A_date (which has the latest date) I want Variable_New_Name to show A_COUNT

Brandon16 · ‎02-13-2018

It lookes like the blanks are always C_Date for some reason, they are all in the same format so not quite sure why they seem to be excluded. Maybe once that's captured correctly, the code will work as expected.

Brandon16 · ‎02-13-2018

Another issue is I should see the following results returned below........ A_Count B_Count C_Count D_Count E_Count F_Count G_Count A_Date B_Date C_Date D_Date E_Date F_Date G_Date Max_Date_New Variable_Name_New 8 0 8 8 8 0 0 20/04/2015 . 18/03/2017 18/03/2017 . . . 20/04/2015 A_Count Instead I get this… A_Count B_Count C_Count D_Count E_Count F_Count G_Count A_Date B_Date C_Date D_Date E_Date F_Date G_Date Max_Date_New Variable_Name_New 8 0 8 8 8 0 0 20/04/2015 . 18/03/2013 18/03/2013 . . . 20/04/2015 C_Count

Brandon16 · ‎02-13-2018

No I didn't run the code where you mentioned Dataline with my sample data as I thought that was just a test.

Brandon16 · ‎02-13-2018

I have plugged the code it and I do have a question on some outputs. A_Count was the only variable to populate a value which variable_name_new captures, however the the new variable MAX_DATE_NEW has a blank date, when it should be 02/12/2015 as it is in variable a_date, any idea why that might be please?

Brandon16 · ‎02-13-2018

data have; input A_Count B_Count C_Count D_Count E_Count F_Count G_Count (A_Date B_Date C_Date D_Date E_Date F_Date G_Date)(:ddmmyy10.); format A_Date B_Date C_Date D_Date E_Date F_Date G_Date ddmmyy10.; datalines;8 0 0 0 10 10 6 01/01/2017 01/02/2017 . . 03/03/2017 04/03/2017 02/02/2017 9 1 1 10 6 4 1 02/01/2018 01/06/2016 05/06/2017 09/02/2017 11/11/2017 16/12/2017 08/03/2016 9 0 10 9 0 0 10 28/10/2016 . 25/01/2017 16/10/2017 . . 22/06/2017 2 0 0 0 0 0 0 18/08/2016 . . . . . . 2 4 6 5 8 0 0 24/04/2017 22/05/2016 17/07/2017 23/03/2016 28/07/2017 . .;

Brandon16 · ‎02-13-2018

Apologies, that was my fault, good spot! I'm still trying to get my head around this, is the first statement just a test as I don't want to key in the variables each time on the datalines?

Brandon16 · ‎02-13-2018

Hi Guy's, I have a dataset example (below) and I need to create 2 new variables 1. Max_Date_New 2. Variable_Name_New I need to work out how to populate the new variables highlighted in RED. If the count value is the same for multiple variables (like in the first row), I then need the max date from the date variables which is F_date so I need the 2 new variables to produce F_Count and F_Date. I hope that makes sense. Variable Name - Value Variable Name - Date Returned Variables A_Count B_Count C_Count D_Count E_Count F_Count G_Count A_Date B_Date C_Date D_Date E_Date F_Date G_Date Max_Date_New Variable_Name_New 8 0 0 0 10 10 6 01/01/2017 01/02/2017 . . 03/03/2017 04/03/2017 02/02/2017 04/03/2017 F_Count 9 1 1 10 6 4 1 02/01/2018 01/06/2016 05/06/2017 09/02/2017 11/11/2017 16/12/2017 08/03/2016 09/02/2017 D_Count 9 0 10 9 0 0 10 28/10/2016 . 25/01/2017 16/10/2017 . . 22/06/2017 25/01/2017 C_Count 2 0 0 0 0 0 0 18/08/2016 . . . . . . 18/08/2016 A_Count 2 4 6 5 8 0 0 24/04/2017 22/05/2016 17/07/2017 23/03/2016 28/07/2017 . . 28/07/2017 E_Count

Brandon16 · ‎02-01-2018

Hi, I have created a tabulate below but I need to sort the dates from earliest to latest. Proc tabulate data J_final; Class date; Var move can; Table (date=""), (Move="") (Can=""); Run; My output would go in alphabetical order Date move can April16 4 6 April17 2 3 Aug16 6 4 Aug17 2 5 Etc Any idea what i need to add to change it please?

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

Create a New Variable

Re: ODS HTML Excel Error

Re: ODS HTML Excel Error

ODS HTML Excel Error

Re: Create New MAX Value Variables

Re: Create New MAX Value Variables

Re: Create New MAX Value Variables

Re: Create New MAX Value Variables

Re: Create New MAX Value Variables

Re: Create New MAX Value Variables

Re: Create New MAX Value Variables

Re: Create New MAX Value Variables

Re: Create New MAX Value Variables

Create New MAX Value Variables

Order by Date on Proc tabulate