About trphelps15

Satish_Parida · ‎01-31-2018

proc sql; create table summery_table as select Code, sum(Length) as Length, sum(Length_percentage*at_rur) as at_rur, sum(Length_percentage*at_sub) as at_sub, sum(Length_percentage*postspd) as postspd , sum(delay) as delay from input_dataset group by Code; quit;

art297 · ‎12-28-2017

You could just add the "smallest" function to your code. e.g.: data analysis; set analysis_set; array set(24) Spd_:; do while (StDev>10); call missing (set(whichn(smallest(1, of set(*)),of set(*)))); call missing (set(whichn(largest(1, of set(*)),of set(*)))); StDev=std(of set(*)); Mean=harmean(of set(*)); end; run; Art, CEO, AnalystFinder.com

trphelps15 · ‎10-19-2017

Example 10 was definitely what I was looking for. Now on to creating one more new variable and then transforming the table...thank you very much for your help! (the sql ran btw, but it was nowhere near correct...that'll likely be some training down the road)

Online Status	Offline
Date Last Visited	‎06-09-2021 05:29 PM

Re: How do I collapse variables using multiple methods within a BY Sta...

How do I collapse variables using multiple methods within a BY Stateme...

Re: If-then do Repeat until Condition Met

If-then do Repeat until Condition Met

Re: Dataset Collapse and Sum Calculation by Two Classes

Dataset Collapse and Sum Calculation by Two Classes

If-then do Repeat until Condition Met

Re: How do I collapse variables using multiple methods within a BY Sta...

Re: If-then do Repeat until Condition Met

Re: Dataset Collapse and Sum Calculation by Two Classes