About AK100

AK100 · ‎04-01-2020

@Kurt_Bremser an other quick case, what if I not want to select the top 1 per SECTION and per DAY but the TOP 4 per SECTION and DAY and add like a RANKING column to show the ranking from 1-4. How will your code below look like then? proc sort data=have; by section date descending value; run; data want; set have; by section date; if first.date; run;

AK100 · ‎04-01-2020

It almost worked, but thank you in advance!

AK100 · ‎04-01-2020

Thank you @Kurt, your good. You made it look really simple! By the way. I'am still working on that conversion to data steps thing. I know it makes it easier for you guys to check the data and solve the problems. Hope I can use it soon.

AK100 · ‎04-01-2020

Hello All, I might ask an easy question but I want the following. I want to select the top 1 highest value per SECTION and per DAY. Please see the example below: *This is the data I have right now (with thousands of rows) ID -- Location -- Section -- Date -- Time -- Type -- Value 01 -- Germany -- BB --1/1/20 -- 10:10 -- VW -- 9,0 02 -- Germany -- AA --1/1/20 -- 11:20 -- AU -- 7,0 03 -- Germany -- AA --1/1/20 -- 13:50 -- AU -- 6,0 04 -- Germany -- BB --1/1/20 -- 13:50 -- AU -- 5,7 05 -- Germany -- BB --2/1/20 -- 15:10 -- MC -- 11,3 06 -- Germany -- BB --2/1/20 -- 19:10 -- VW -- 12,0 07 -- Germany -- AA --2/1/20 -- 15:20 -- OP -- 6,7 08 -- Germany -- AA --2/1/20 -- 15:20 -- AU -- 2,0 09 -- Germany -- BB --3/1/20 -- 16:16 -- MC -- 1,5 10 -- Germany -- BB --3/1/20 -- 11:45 -- MC -- 5,8 11 -- Germany -- AA --3/1/20 -- 09:40 -- OP -- 2,7 12 -- Germany -- AA --3/1/20 -- 02:40 -- VW -- 2,0 *This is the data I want: ID -- Location -- Section -- Date -- Time -- Type -- Value 01 -- Germany -- BB --1/1/20 -- 10:10 -- VW -- 9,0 02 -- Germany -- AA --1/1/20 -- 11:20 -- AU -- 7,0 06 -- Germany -- BB --2/1/20 -- 19:10 -- VW -- 12,0 07 -- Germany -- AA --2/1/20 -- 15:20 -- OP -- 6,7 10 -- Germany -- BB --3/1/20 -- 11:45 -- MC -- 5,8 11 -- Germany -- AA --3/1/20 -- 09:40 -- OP -- 2,7 I appreciate your help all 🙂 Thank you in advance!

AK100 · ‎03-31-2020

thx.

AK100 · ‎03-31-2020

That was a good one @art297.

AK100 · ‎03-30-2020

Hello all, I'am quite new to SAS EG and I want to get the following: I want to select all the measurements who have the highest percentage (from high to low per month AND section) till I reach a cumulative total percentage of minimal 75%. . So (see screenshot) from the month July and section 2632CT I want to select just the percentage 53% + 28% in a cumulative column. For the month July and section 2646BT I want to select just 49% and 26% in cumulative etc. So I just want to select the highest percentages in a cumulative form until I reach a minimal of 75%. The count has to start from 0 again at the beginning of every new section (so actually 2x per month) I hope its all clear, I appreciate your help.

AK100 · ‎03-25-2020

Hi Kurt, I would love to learn that of course on your way, and I will code it in the coming days and let you know how it looks. However, I though maybe someone had a short solution for now because I need the output for work.

AK100 · ‎03-25-2020

hi Paige Miller, Right now I'am joining the 2 tables together and make 1 table out of it, but that gives me the wrong totals. Which means the percentages are wrong to. After the join there is no distinction There is no distiction between SECTIE anymore so all the totals of JULY turn out to be 112, august turn out to be 161. This, while every month has 2 totals (because of 2 different SECTIE's) Dbout the red part: 21 is DDM (subtotal, SECTIE 2632CT) from the second table that has to be dived by 112 from the first table (the total). 6 is DDZ (subtotal, SECTIE 2646BT) from the second table which has to be dived by 52 from the first table (the total). This has to be done for all of them of course, i just picked 2 random. Hope it clear like this?

AK100 · ‎03-25-2020

Morning Lads, I wanted to ask an urgent question about calculating percentages from 2 different tables. In the first picture you see the total measurements per month/section. In the second picture you see a the total measurements per MatType per month per section. Now I want to calculate the percentages of subtotal/total in a new table but if I join the tables i get the wrong totals. So I actually want 21 (from second table) / 112 (from first table) and 6 (from second table) / 52 (from first table). Please note that I use the query builders most of the time instead of coding (also note that these are just screenshots, the tables are much much bigger.

AK100 · ‎03-24-2020

Okay Patrick, thank you.

AK100 · ‎03-24-2020

It represents one measurement, so that means one vehicle type and vehicle can drive past a specific location more that once.

AK100 · ‎03-24-2020

@Patrick @Kurt_Bremser Okay guy's that makes sense, its seems clear. However, I forgot to tell 1 thing. My Totalvehicle column is actually a COUNT of the VehicleType column. My first intention was to SUM the VehicleType, but thats not possible ofcourse as those are not numbers but just letters. Does the COUNT VehicleType I'am using give me the same result as the SUM vehicletype you are using @Patrick ? The final step is to calculate percentages so I can say for example: Okay vehicletype X drove past that location 560 times in the month X, that is a percentage of 21% of all the types that drove there that month.

AK100 · ‎03-24-2020

This looks okay, but I dont get your last part of the computed month value. Could you show that? Why do you add ,0.'b' after t.1.date?

AK100 · ‎03-24-2020

I did not understand this method, the method of Kurt seemed a bit more easier. But thank you anyway, appreciate your help.

Problems when registering tables in the SAS Management Console

Re: How to get the folder tree of the SASFolders?

Re: How to get the folder tree of the SASFolders?

Re: How to get the folder tree of the SASFolders?

Re: How to get the folder tree of the SASFolders?

Re: How to get the folder tree of the SASFolders?

How to get the folder tree of the SASFolders?

Re: How to concatenate Year, Month, Day, Hour, Minute, Second in SAS?

Re: How to concatenate Year, Month, Day, Hour, Minute, Second in SAS?

How to concatenate Year, Month, Day, Hour, Minute, Second in SAS?

Re: SAS VA Graph's resolution

Re: How to remove the first 3 seconds and last 3 seconds of a measurem...

Re: How to remove the first 3 seconds and last 3 seconds of a measurem...

Re: How to remove the first 3 seconds and last 3 seconds of a measurem...

Re: How to remove the first 3 seconds and last 3 seconds of a measurem...

Re: Rank until it reaches a specific percentage.

Re: Select top 1 (highest value )per section and day in SAS EG

Re: Select top 1 (highest value )per section and day in SAS EG

Re: Select top 1 (highest value )per section and day in SAS EG

Re: Select top 1 (highest value )per section and day in SAS EG

Select top 1 (highest value )per section and day in SAS EG

Re: Selecting the cumulative till I reach 75%

Re: Selecting the cumulative till I reach 75%

Selecting the cumulative till I reach 75%

Re: Calculating percentages from 2 different tables SAS EG

Re: Calculating percentages from 2 different tables SAS EG

Calculating percentages from 2 different tables SAS EG

Re: Total per month SAS EG

Re: Total per month SAS EG

Re: Total per month SAS EG

Re: Total per month SAS EG

Re: Total per month SAS EG