topic Re: Problem usng PDV in SAS Studio

Problem usng PDV

rishabhmehra13 — Thu, 22 Sep 2016 22:10:49 GMT

Hi,

I want a sum of total media value grouped by probability

the data set is already sorted by me

data sas1;

set d.p3;

by Probability____;
if first.Total_Media_Value=1 then tot_budget=0;
tot_budget+Total_Media_Value;
if last.Total_Media_Value then output;
run;

log

NOTE: Variable first.Total_Media_Value is uninitialized.

NOTE: Variable last.Total_Media_Value is uninitialized.

ERROR: BY variables are not properly sorted on data set D.P3.

Reeza — Thu, 22 Sep 2016 22:24:01 GMT

Why not use proc means?

You can only use FIRST/LAST on variables that are included in your BY statement.

rishabhmehra13 — Thu, 22 Sep 2016 22:30:39 GMT

data sas2;
set d.p3;

by Probability____;
if first.Probability____=1 then tot_budget=0;
tot_budget+Total_Media_Value;
if last.Probability____ then output;

if Probability____=0 then delete;

run;

still getting the same error

log

ERROR: BY variables are not properly sorted on data set D.P3.

Reeza — Thu, 22 Sep 2016 22:32:00 GMT

Then you probably haven't sorted your data.

Sort your data.

rishabhmehra13 — Thu, 22 Sep 2016 22:43:52 GMT

its sorted by probabilty

##- Please type your reply above this line. Simple formatting, no
attachments. -##

Reeza — Fri, 23 Sep 2016 02:33:28 GMT

Post the Proc sort and data step and the corresponding log that shows the error. Clearly SAS doesn't think it is.

All values must be ascending for the probability.