topic Re: multiple firs.var not working in SAS Programming

multiple firs.var not working

Rahul_SAS — Tue, 02 Oct 2018 18:51:13 GMT

Hi Experts,

I am using below code but its not giving both by group value.

data list;
input Name$1-10 Class$ List_price ;
datalines;
Black Bora Track 796
Black Bora Road 399
Black Bora Track 1130
Black Bora Road 1995
Scirocco Mountain 899
Scirocco Mountain 459
Scirocco Road 2256
Scirocco Road 559
;
run;

proc sort data = list out=list1;
by Name Class;
run;

proc print data = list1;
run;

data final;
set list1;
by name class;
if first.name and first.class then List_price1=List_price;
else List_price1=0;
run;

Getting attached result. I simply need the List_price for both by group (name and class).

HAVE
Name	Class	List_Price
Black Bora	Track	796
Black Bora	Track	399
Black Bora	road	1130
Black Bora	Road	1995
Scirocco	Mountain	899
Scirocco	Mountain	459
Scirocco	Road	2256
Scirocco	Road	559

WANT
Name	Class	List_Price
Black Bora	Track	796
Black Bora	Track	0
Black Bora	road	1130
Black Bora	Road	0
Scirocco	Mountain	899
Scirocco	Mountain	0
Scirocco	Road	2256
Scirocco	Road	0

thanks

Re: multiple firs.var not working

bobpep212 — Tue, 02 Oct 2018 18:57:06 GMT

Try first.class only:

data final;
set list1;
by name class;
if first.class then List_price1=List_price;
else List_price1=0;
run;

Re: multiple firs.var not working

novinosrin — Tue, 02 Oct 2018 19:01:02 GMT

assuming sets of 2

data HAVE;
input Name & $10.	Class $	List_Price;
cards;
Black Bora 	Track     	796
Black Bora 	Track	399
Black Bora 	Road	1130
Black Bora 	Road      	1995
Scirocco   	Mountain  	899
Scirocco   	Mountain  	459
Scirocco   	Road     	2256
Scirocco  	 Road      	559
;

data want;
set have;
by name class notsorted;
if last.class then list_price=0;
run;

Re: multiple firs.var not working

Reeza — Tue, 02 Oct 2018 19:02:36 GMT

First, clean your data since road does not equal Road.

Then sort

Then use BY grroup to set to missing/0.

How is road 1130? See red section below. And with two prices which do you want to keep?

proc sort data=list;
by name class descending list_price;
run;

data want;
set list;
if not first.class then list_price=0;
run;

@Rahul_SAS wrote:

Hi Experts,

I am using below code but its not giving both by group value.

data list;
input Name$1-10 Class$ List_price ;
datalines;
Black Bora Track 796
Black Bora Road 399
Black Bora Track 1130
Black Bora Road 1995
Scirocco Mountain 899
Scirocco Mountain 459
Scirocco Road 2256
Scirocco Road 559
;
run;

proc sort data = list out=list1;
by Name Class;
run;

proc print data = list1;
run;

data final;
set list1;
by name class;
if first.name and first.class then List_price1=List_price;
else List_price1=0;
run;

Getting attached result. I simply need the List_price for both by group (name and class).

HAVE

Name Class List_Price

Black Bora Track      796

Black Bora Track 399

Black Bora road 1130

Black Bora Road       1995

Scirocco    Mountain   899

Scirocco    Mountain   459

Scirocco    Road      2256

Scirocco   Road       559

WANT

Name Class List_Price

Black Bora Track      796

Black Bora Track 0

Black Bora road 1130

Black Bora Road       0

Scirocco    Mountain   899

Scirocco    Mountain   0

Scirocco    Road      2256

Scirocco   Road       0

thanks

Re: multiple firs.var not working

Rahul_SAS — Tue, 02 Oct 2018 19:07:32 GMT

Hi bobpep212,

this doesn't solve the problem. Need all list prices for all Class within a Name like mentioned the WANT result.

Re: multiple firs.var not working

bobpep212 — Tue, 02 Oct 2018 19:19:13 GMT

I'm confused then. My output looks like your want below. It shows the list price for the first instance of that class for each Name group. All others list prices would be 0 as List_price1. (With the exception of the point Reeza makes about the road=1130, since 1130 is with the class 'Track' in your have dataset). It doesn't show all the list prices for all the class within a name because your program says not to do that with the else statement.

Re: multiple firs.var not working

Rahul_SAS — Tue, 02 Oct 2018 19:19:59 GMT

lets keep it simple.

HAVE

Name	Class	List_Price
Black Bora	Track	796
Black Bora	Track	796
Black Bora	road	796
Black Bora	Road	796
Scirocco	Mountain	899
Scirocco	Mountain	899
Scirocco	Road	899
Scirocco	Road	899

WANT

Name	Class	List_Price
Black Bora	Track	796
Black Bora	Track	0
Black Bora	road	796
Black Bora	Road	0
Scirocco	Mountain	899
Scirocco	Mountain	0
Scirocco	Road	899
Scirocco	Road	0

Need value for first row of all class subgroup within name.

Re: multiple firs.var not working

novinosrin — Tue, 02 Oct 2018 19:22:02 GMT

HI @Rahul_SAS Reeza was referring to perhaps the typo

Black Bora	road	796
Black Bora	Road	0

Also, it seems you apparently didn't test my code. May i request you to test plz

Re: multiple firs.var not working

bobpep212 — Tue, 02 Oct 2018 19:27:49 GMT

data have;
input Name$1-10 Class$ List_price ;
datalines;
Black Bora Track 796 
Black Bora Track 796 
Black Bora Road 796
Black Bora Road 796 
Scirocco  Mountain 899 
Scirocco  Mountain 899 
Scirocco  Road 899
Scirocco  Road 899 
;
run;
proc sort data = have;
by Name Class;
run;
data want;
set have;
by name class;
if first.class then List_price1=List_price;
else List_price1=0;
run;

This isn't exactly what you want?

Re: multiple firs.var not working

Rahul_SAS — Tue, 02 Oct 2018 19:44:25 GMT

Actually this code is not working for my original dev code.

Re: multiple firs.var not working

Reeza — Tue, 02 Oct 2018 20:34:38 GMT

Please define what not working means. Is it giving you an error?

@Rahul_SAS wrote:

Actually this code is not working for my original dev code.