tag:blogger.com,1999:blog-7958828565254404797.post4473293187692112360..comments2024-03-28T07:20:51.037-07:00Comments on ListenData: SAS : First. and Last. VariablesDeepanshu Bhallahttp://www.blogger.com/profile/09802839558125192674noreply@blogger.comBlogger69125tag:blogger.com,1999:blog-7958828565254404797.post-45796054916869251762024-03-26T03:29:45.166-07:002024-03-26T03:29:45.166-07:00data test1;
set readin;
by id;
if last.id=1 ;
run;...data test1;<br />set readin;<br />by id;<br />if last.id=1 ;<br />run;Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-1945953843291666172023-08-30T23:09:45.751-07:002023-08-30T23:09:45.751-07:00
Data t;
Input x$ y;
cards;
A 5
B 3
C 4
A 6
B 9
C...<br />Data t;<br />Input x$ y;<br />cards;<br /><br />A 5<br />B 3<br />C 4<br />A 6<br />B 9<br />C 3<br />;<br />Run;<br /><br />proc sort data = t ;<br />by x;<br />run;<br />data final ;<br />set t;<br />by x;<br />if first.x then sum= y ;<br />else sum +y ;<br />if last.x;<br />keep x sum ;<br />run;gaurav roxxhttps://www.blogger.com/profile/03582202425086028736noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-33954862704617438972023-08-30T22:42:35.162-07:002023-08-30T22:42:35.162-07:00proc sort data = temp;
by EMPID;
run;
data outdata...proc sort data = temp;<br />by EMPID;<br />run;<br />data outdata;<br />set temp;<br />if first.empid= 1 then query = 1 ;<br />else query +1 ;<br />if last.empid ;<br />run;<br />data final ;<br />set outdata ;<br />where query gt 5 ;<br />run;<br /><br /><br />gaurav roxxhttps://www.blogger.com/profile/03582202425086028736noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-26554728126966834132022-04-19T15:26:11.086-07:002022-04-19T15:26:11.086-07:00data avg;
set score;
by ID;
IF first.ID then COUNT...data avg;<br />set score;<br />by ID;<br />IF first.ID then COUNT=1 ELSE COUNT = COUNT+1;<br />IF first.ID then SUM = MARKS ELSE SUM = SUM+MARKS;<br />IF LAST.ID then AVG = SUM/COUNT;<br />RUN;Arsh Rishihttps://www.blogger.com/profile/09759438964051246946noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-64202364522500177082022-04-15T08:37:47.850-07:002022-04-15T08:37:47.850-07:00how to create that ID variable with first. and las...how to create that ID variable with first. and last.?Anonymoushttps://www.blogger.com/profile/05890784458877749951noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-81160080553439438272021-12-11T06:24:36.969-08:002021-12-11T06:24:36.969-08:00Hello all,
Data ADaM;
Input visit$ visitnum param...Hello all,<br /><br />Data ADaM;<br />Input visit$ visitnum paramcd$ aval;<br />cards;<br />v3 3 Hb 9<br />v4 4 HR 67<br />sc1 1 Hb 6<br />sc2 2 Hb 8<br />v2 2 HR 78<br />v3 3 HR 85<br />sr1 0 HR 70<br />sr2 1 HR 69<br />;<br />run;<br />proc sort data=ADaM out=ADaM1;<br />by paramcd visitnum;<br />run;<br /><br />here i need to find the baseline values, baseline is avail first observation+second observation/2 is the baseline for every paramcd,<br /><br />Example: if paramcd Aval baseline<br /> HR 10 <br /> HR 20 15 (10+20/2),<br /> even i have somany HR paramcds it should be baseline 15 for HR,<br /> HB 20<br /> HB 30 25<br /> even i have somany HB paramcds it should be baseline 25 for HR,<br /><br />Please can any one help on it.<br />Anonymoushttps://www.blogger.com/profile/05335182215038841822noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-82331201867490883202021-07-30T13:21:18.858-07:002021-07-30T13:21:18.858-07:00data uniques duplicates;
set readin;
by id;
if fir...data uniques duplicates;<br />set readin;<br />by id;<br />if first.id = 1 and last.id=1 then output uniques;<br />if first.id then n = 1;<br />else n+1;<br />if n = 2 then output duplicates;<br />run;rishiblogshttps://www.blogger.com/profile/04550886166385148428noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-4006314430437187872021-05-26T20:06:58.539-07:002021-05-26T20:06:58.539-07:00Good oneGood oneAnonymoushttps://www.blogger.com/profile/04855725932378304102noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-37785602119543216132021-01-21T12:23:48.553-08:002021-01-21T12:23:48.553-08:00data temp;
input id var1 var2;
cards;
1 20 30
1 40...data temp;<br />input id var1 var2;<br />cards;<br />1 20 30<br />1 40 50<br />1 30 55<br />2 22 45<br />2 37 49<br />3 79 36<br />4 36 49<br />4 68 78<br />;<br />run;<br />proc means data=temp mean ;<br />class id;<br />output out=temp1 (where=(_type_>0 and _stat_="MEAN")) ;<br />run;<br />data temp2;<br />set temp1(keep= id var1 var2);<br />run; Yogendra Neginoreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-89161845078999100422021-01-21T11:43:06.555-08:002021-01-21T11:43:06.555-08:00proc means data=t sum;
class x;
run;proc means data=t sum;<br />class x;<br />run;Anonymoushttps://www.blogger.com/profile/03387847735143906782noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-35608065334746933002021-01-15T06:31:22.449-08:002021-01-15T06:31:22.449-08:00data readin;
input ID Name $ Score;
cards;
1 ...data readin;<br /> input ID Name $ Score;<br /> cards;<br />1 David 45<br />1 David 74<br />2 Sam 45<br />2 Ram 54<br />3 Bane 87<br />3 Mary 92<br />3 Bane 87<br />4 Dane 23<br />5 Jenny 87<br />5 Ken 87<br />6 Simran 63<br />8 Priya 72<br />;<br />run;<br /><br />proc sort data=readin out=sorted;<br /> by id descending score;<br />run;<br /><br />data maxscore;<br /> set sorted;<br /> by id descending score;<br /><br /> if first.id=1 then<br /> output;<br />run;<br /><br />data uniq_secondobs;<br /> set sorted;<br /> by id descending score;<br /> putlog ID first.id=last.id=_n_=;<br /><br /> if _n_ in (2, 4, 6, 8, 10, 11, 12) then<br /> output;<br />run;<br /><br />katehttp://kate1564.blogspot.comnoreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-71037444208391676002020-10-27T01:13:19.325-07:002020-10-27T01:13:19.325-07:00hi,
what if happens if first.id=1 and last.id=0, ...hi,<br /><br />what if happens if first.id=1 and last.id=0, so we can write like this way , i say we could also write like this,<br /> <br />if first.id=0 and last.id=1 or first.id=1 and last.id=0 then status='SCORE';<br /><br />CODE::<br /><br />data T1;<br />set readin;<br />by id;<br />unique=first.id;<br />duplicate=last.id;<br />if first.id=0 and last.id=1 or first.id=1 and last.id=0 then status='SCORE';<br />if first.id=1 and last.id=1 then status='unique';<br />run;<br />proc print data=T1;<br />run;Antohttps://www.blogger.com/profile/10096848276225888261noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-216360937125518302020-08-23T00:26:57.951-07:002020-08-23T00:26:57.951-07:00proc sort data=readin out=r_sorted;
by id descendi...proc sort data=readin out=r_sorted;<br />by id descending score;<br />run;<br />data unique_sec;<br />set r_sorted;<br />by id descending score;<br />if first.id then n=1;<br />else n+1;<br />if first.id and last.id or n=2;<br />drop n;<br />run;alok singhhttps://www.blogger.com/profile/18351835671788632486noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-44496882461480540632020-08-10T20:30:18.913-07:002020-08-10T20:30:18.913-07:00data record;
input id name $ score;
cards;
1 david...data record;<br />input id name $ score;<br />cards;<br />1 david 45<br />1 david 74<br />2 sam 45<br />2 ram 54<br />3 bane 87<br />3 mary 92<br />3 Bane 87<br />4 Dane 23<br />5 Jenny 87<br />5 Ken 87<br />6 Simran 63<br />8 Priya 72<br />;<br />run;<br />/*Select unique observations plus second <br />observation from duplicate observations of<br />variable ID */<br /><br /><br />proc sort data=record;<br />by ID;<br />run;<br /><br />data data2 data3;<br />set record;<br />by id;<br />if (first.ID=1 or last.ID=1) then output data2;<br />else output data3;<br />run;<br /><br /><br /><br /><br /><br /><br /><br /><br />poonamnoreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-67927516269894764832020-07-22T00:48:19.614-07:002020-07-22T00:48:19.614-07:00data akshay;
input
id var1 var2;
cards;
1 20 30
1...data akshay;<br />input <br />id var1 var2;<br />cards;<br />1 20 30<br />1 40 50<br />1 30 55<br />2 22 45<br />2 37 49<br />3 79 36<br />4 36 49<br />4 68 78<br />;<br />run;<br /><br />proc sort data=akshay;by id;run;<br />proc means data=akshay mean;<br />by id;<br />var var1 var2;<br />output out=semifinal <br /> mean(var1)= var1<br />mean(var2)=var2; ;<br />run;<br />data final;<br />set semifinal;<br />drop _TYPE_ _FREQ_;<br />run;Akshaynoreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-75293492894122478152020-07-22T00:00:56.430-07:002020-07-22T00:00:56.430-07:00data akshay;
input
id date:anydtdte10. day$ &...data akshay;<br />input <br />id date:anydtdte10. day$ &;<br />format date:mmddyy8.;<br />cards;<br />43 10/09/2018 DAY 1 <br />43 10/10/2018 DAY 2 <br />43 10/11/2018 DAY 3 <br />43 10/12/2018 DAY 4 <br />43 10/13/2018 DAY 5 <br />43 10/15/2018 DAY 7 <br />44 10/9/2018 DAY 1 <br />44 10/11/2018 DAY 3 <br />45 10/9/2018 DAY 1 <br />45 10/10/2018 DAY 2 <br />45 10/12/2018 DAY 4 <br />;run;<br /><br />proc sort data=akshay;by id;run;<br /><br />data final;<br />set akshay;<br />by id;<br />if first.id=1 then serial_no=1;<br />else serial_no+1;<br />run;Anonymoushttps://www.blogger.com/profile/12664079669219732959noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-72224589729055801682020-07-21T23:32:48.535-07:002020-07-21T23:32:48.535-07:00data temp;
input EMPID Expenses;
CARDS;
101 200
10...data temp;<br />input EMPID Expenses;<br />CARDS;<br />101 200<br />102 300<br />103 200<br />104 500<br />105 600<br />101 450<br />102 600<br />101 400<br />101 200<br />101 700<br />102 600<br />101 800<br />101 500<br />102 900<br />101 500<br />102 600<br />102 800<br />102 600<br />102 900<br />102 700<br />102 600<br />102 600<br />103 800<br />;run;<br />proc sort data=temp out=ani;by EMPID;run;<br />data akshay;<br />set ani;<br />by EMPID;<br />if first.EMPID=1 then Transactions=1;<br />else Transactions+1;<br />if Transactions gt 5;<br />if last.EMPID;<br />run;Anonymoushttps://www.blogger.com/profile/12664079669219732959noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-28357645538425400882020-05-31T15:12:30.332-07:002020-05-31T15:12:30.332-07:00proc sort data =readin out=test;
by id Score;
run;...proc sort data =readin out=test;<br />by id Score;<br />run;<br /><br />data test1 ;<br />set test;<br />by id ;<br />if first.id then N=1;<br />else N+1;<br />if first.ID=1 and last.id=1 or N=2;<br />drop N;<br />run;Anonymoushttps://www.blogger.com/profile/15898040989099682318noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-62243674339356031202020-05-31T15:11:08.437-07:002020-05-31T15:11:08.437-07:00proc sort data =readin out=test;
by id Score;
run;...proc sort data =readin out=test;<br />by id Score;<br />run;<br /><br />data test1 ;<br />set test;<br />by id ;<br />if first.id then N=1;<br />else N+1;<br />if first.ID=1 and last.id=1 or N=2;<br />drop N;<br />run;Anonymoushttps://www.blogger.com/profile/15898040989099682318noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-9323465576925068242020-05-31T14:42:28.972-07:002020-05-31T14:42:28.972-07:00proc sort data =temp;
by EMPID;
data test;
set tem...proc sort data =temp;<br />by EMPID;<br />data test;<br />set temp;<br />by EMPID ;<br />if first.EMPID=1 then N=1;<br />else N+1;<br />run;<br /><br />Data Final(Keep=EMPID);<br />set test;<br />where N>=5;<br />run;Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-40752087590417217792020-03-08T10:27:01.025-07:002020-03-08T10:27:01.025-07:00PROC SORT DATA=temp;
BY EMPID;
RUN;
DATA TEST;
SE...PROC SORT DATA=temp;<br />BY EMPID;<br />RUN;<br /><br />DATA TEST;<br />SET TEMP;<br />BY EMPID;<br />IF FIRST.EMPID THEN COUNT=0;<br />COUNT+1;<br />IF COUNT GT 5;<br />IF LAST.EMPID;<br />RUN;<br />Anonymoushttps://www.blogger.com/profile/18125156539043507454noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-18863933286023458222020-03-08T10:19:09.751-07:002020-03-08T10:19:09.751-07:00SOLUTION OF 2ND QUERY:
PROC SORT DATA =READIN;
BY...SOLUTION OF 2ND QUERY:<br /><br />PROC SORT DATA =READIN;<br />BY ID;<br />RUN;<br /><br />DATA T1;<br />SET READIN;<br />BY ID;<br />IF FIRST.ID = 1 AND LAST.ID =1 THEN STATUS='UNIQUE';<br />IF FIRST.ID =0 AND LAST.ID =1 THEN STATUS= SCORE;<br />RUN;<br /><br /><br /><br /><br /><br /><br /><br />Anonymoushttps://www.blogger.com/profile/18125156539043507454noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-15593834817504578932019-09-10T05:41:10.809-07:002019-09-10T05:41:10.809-07:00Hi All, With refer to below dataset, Can anyone pl...Hi All, With refer to below dataset, Can anyone please assist me I want to have all those Empid's who have done more then 5 Transactions<br /><br />data temp;<br />input EMPID Expenses;<br />CARDS;<br />101 200<br />102 300<br />103 200<br />104 500<br />105 600<br />101 450<br />102 600<br />101 400<br />101 200<br />101 700<br />102 600<br />101 800<br />101 500<br />102 900<br />101 500<br />102 600<br />102 800<br />102 600<br />102 900<br />102 700<br />102 600<br />102 600<br />103 800<br />;binduhttps://www.blogger.com/profile/09389364650117573895noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-33666062544508778602019-08-03T00:02:37.728-07:002019-08-03T00:02:37.728-07:00someone please try to give solution for this query...someone please try to give solution for this query.Pankajhttps://www.blogger.com/profile/10208906845851433227noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-74613831078358415772019-06-26T04:37:52.244-07:002019-06-26T04:37:52.244-07:00Data t;
Input x$ y;
A 5
B 3
C 4
A 6
B 9
C 3
;
Run;...Data t;<br />Input x$ y;<br />A 5<br />B 3<br />C 4<br />A 6<br />B 9<br />C 3<br />;<br />Run; <br /><br />How to get out put<br />Sum of <br />A=<br />B=<br />C=Anonymoushttps://www.blogger.com/profile/01149765503246866406noreply@blogger.com