topic Re: First. Last. Using Proc Sql in New SAS User

First. Last. Using Proc Sql

Nehemiah — Wed, 11 Sep 2019 06:48:26 GMT

Dear All

bellow is the code i run :

Data SAm;
input Name $ Item $ Value ;
cards;
nehemiah ball 20
nehemiah bat 100
nehemiah glouse 50
naari battary 14
naari remote 40
naari cover 120
;
Run;

I want output like this

output:

naari battary 14

nehemiah ball 20

please help me with the code Proc Sql

Re: First. Last. Using Proc Sql

PeterClemmensen — Wed, 11 Sep 2019 06:56:47 GMT

I assume that what you want is to take the obs with the minimum value for each name? If you want to do so with PROC SQL, this has nothing to do with first./last. logic, which is a SAS Data Step concept.

proc sql;
    create table want as
    select * from sam
    group by name
    having value=min(value);
quit;

Result:

name      item     value

naari     battary  14   
nehemiah  ball     20

Re: First. Last. Using Proc Sql

Nehemiah — Wed, 11 Sep 2019 07:03:02 GMT

thanks for the Solution.

and wrote a code in data step like this

Proc sort Data =Sam out=Sam_srt ;
By Name ;
Run;

Data Sam_1 ;
Set Sam_srt;
By Name ;
If First.name ;
Run;

Sir

i want output based on Name only.and can you write the code for above data step into Proc SQL.

Re: First. Last. Using Proc Sql

PeterClemmensen — Wed, 11 Sep 2019 07:17:03 GMT

Have you tried my code above?

Re: First. Last. Using Proc Sql

Nehemiah — Wed, 11 Sep 2019 07:24:01 GMT

yeah..its working perfectly..

Re: First. Last. Using Proc Sql

PeterClemmensen — Wed, 11 Sep 2019 07:31:08 GMT

Good. Please mark my answer as an accepted solution to help future users navigate the community