<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:gd="http://schemas.google.com/g/2005"><id>tag:blogger.com,1999:blog-7958828565254404797.post4473293187692112360..comments</id><updated>2024-12-13T03:11:35.450-08:00</updated><title type='text'>Comments on ListenData: SAS : First. and Last. Variables</title><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='https://www.listendata.com/feeds/comments/default'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2016/01/first-and-last-variables.html'/><link rel="hub" href="http://pubsubhubbub.appspot.com/"/><link rel='next' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default?start-index=26&max-results=25'/><author><name>Deepanshu Bhalla</name><uri>http://www.blogger.com/profile/09802839558125192674</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiXm_iOrXFR9Ls-mjtOci4qd1m1V1TXkkWJINuMy84-Axo5pNS6CG7oKwR7hfHHI3tB1yuz8W_qo9HK2Cw5fHfe_4cL_2DCf_LyoK9LMLicZojbNYgypIP-RXNsw1GsVhk/s100/pic.jpg'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>66</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-2929231189031481513</id><published>2024-08-11T20:08:32.676-07:00</published><updated>2024-08-11T20:08:32.676-07:00</updated><title type='text'>proc sort data = readin;
by id ;
run;

data unique...</title><content type='html'>proc sort data = readin;<br />by id ;<br />run;<br /><br />data unique second_observation;<br />set readin;<br />by id ;<br />if first.id = 1 and last.id = 1 then output unique;<br />if first.id = 0 and last.id = 1 then output second_observation;<br />run;<br /><br />data mergea;<br />merge unique second_observation;<br />by id;<br />run;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/2929231189031481513'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/2929231189031481513'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2016/01/first-and-last-variables.html?showComment=1723432112676#c2929231189031481513' title=''/><author><name>sahith</name><uri>https://www.blogger.com/profile/10353224462692874711</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2016/01/first-and-last-variables.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-4473293187692112360' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/4473293187692112360' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1698112552"/><gd:extendedProperty name="blogger.displayTime" value="August 11, 2024 at 8:08 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-4579605491686925176</id><published>2024-03-26T03:29:45.166-07:00</published><updated>2024-03-26T03:29:45.166-07:00</updated><title type='text'>data test1;
set readin;
by id;
if last.id=1 ;
run;...</title><content type='html'>data test1;<br />set readin;<br />by id;<br />if last.id=1 ;<br />run;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/4579605491686925176'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/4579605491686925176'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2016/01/first-and-last-variables.html?showComment=1711448985166#c4579605491686925176' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/6565883514981599824'/><author><name>Anonymous</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/blank.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2016/01/first-and-last-variables.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-4473293187692112360' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/4473293187692112360' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-6939909"/><gd:extendedProperty name="blogger.displayTime" value="March 26, 2024 at 3:29 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-194595384329166617</id><published>2023-08-30T23:09:45.751-07:00</published><updated>2023-08-30T23:09:45.751-07:00</updated><title type='text'>
Data t;
Input x$ y;
cards;

A 5
B 3
C 4
A 6
B 9
C...</title><content type='html'><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;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/194595384329166617'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/194595384329166617'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2016/01/first-and-last-variables.html?showComment=1693462185751#c194595384329166617' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/7461383107835841577'/><author><name>gaurav roxx</name><uri>https://www.blogger.com/profile/03582202425086028736</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2016/01/first-and-last-variables.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-4473293187692112360' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/4473293187692112360' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1664922755"/><gd:extendedProperty name="blogger.displayTime" value="August 30, 2023 at 11:09 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-3395486270461743897</id><published>2023-08-30T22:42:35.162-07:00</published><updated>2023-08-30T22:42:35.162-07:00</updated><title type='text'>proc sort data = temp;
by EMPID;
run;
data outdata...</title><content type='html'>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 /></content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/3395486270461743897'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/3395486270461743897'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2016/01/first-and-last-variables.html?showComment=1693460555162#c3395486270461743897' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/3104507505534708191'/><author><name>gaurav roxx</name><uri>https://www.blogger.com/profile/03582202425086028736</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2016/01/first-and-last-variables.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-4473293187692112360' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/4473293187692112360' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1664922755"/><gd:extendedProperty name="blogger.displayTime" value="August 30, 2023 at 10:42 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-2655472812696683413</id><published>2022-04-19T15:26:11.086-07:00</published><updated>2022-04-19T15:26:11.086-07:00</updated><title type='text'>data avg;
set score;
by ID;
IF first.ID then COUNT...</title><content type='html'>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;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/2655472812696683413'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/2655472812696683413'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2016/01/first-and-last-variables.html?showComment=1650407171086#c2655472812696683413' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/5059903379782209679'/><author><name>Arsh Rishi</name><uri>https://www.blogger.com/profile/09759438964051246946</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2016/01/first-and-last-variables.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-4473293187692112360' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/4473293187692112360' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-725401249"/><gd:extendedProperty name="blogger.displayTime" value="April 19, 2022 at 3:26 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-6420236452250017708</id><published>2022-04-15T08:37:47.850-07:00</published><updated>2022-04-15T08:37:47.850-07:00</updated><title type='text'>how to create that ID variable with first. and las...</title><content type='html'>how to create that ID variable with first. and last.?</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/6420236452250017708'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/6420236452250017708'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2016/01/first-and-last-variables.html?showComment=1650037067850#c6420236452250017708' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/05890784458877749951</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2016/01/first-and-last-variables.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-4473293187692112360' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/4473293187692112360' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-768025640"/><gd:extendedProperty name="blogger.displayTime" value="April 15, 2022 at 8:37 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-8116008055343943827</id><published>2021-12-11T06:24:36.969-08:00</published><updated>2021-12-11T06:24:36.969-08:00</updated><title type='text'>Hello all,

Data ADaM;
Input visit$ visitnum param...</title><content type='html'>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 /></content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/8116008055343943827'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/8116008055343943827'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2016/01/first-and-last-variables.html?showComment=1639232676969#c8116008055343943827' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/05335182215038841822</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2016/01/first-and-last-variables.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-4473293187692112360' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/4473293187692112360' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-530086693"/><gd:extendedProperty name="blogger.displayTime" value="December 11, 2021 at 6:24 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-8233120186749088320</id><published>2021-07-30T13:21:18.858-07:00</published><updated>2021-07-30T13:21:18.858-07:00</updated><title type='text'>data uniques duplicates;
set readin;
by id;
if fir...</title><content type='html'>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;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/8233120186749088320'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/8233120186749088320'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2016/01/first-and-last-variables.html?showComment=1627676478858#c8233120186749088320' title=''/><author><name>rishiblogs</name><uri>https://www.blogger.com/profile/04550886166385148428</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2016/01/first-and-last-variables.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-4473293187692112360' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/4473293187692112360' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-941188706"/><gd:extendedProperty name="blogger.displayTime" value="July 30, 2021 at 1:21 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-400631443043718787</id><published>2021-05-26T20:06:58.539-07:00</published><updated>2021-05-26T20:06:58.539-07:00</updated><title type='text'>Good one</title><content type='html'>Good one</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/400631443043718787'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/400631443043718787'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2016/01/first-and-last-variables.html?showComment=1622084818539#c400631443043718787' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/4888224641267405806'/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/04855725932378304102</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2016/01/first-and-last-variables.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-4473293187692112360' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/4473293187692112360' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1523952567"/><gd:extendedProperty name="blogger.displayTime" value="May 26, 2021 at 8:06 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-3778560211954321613</id><published>2021-01-21T12:23:48.553-08:00</published><updated>2021-01-21T12:23:48.553-08:00</updated><title type='text'>data temp;
input id var1 var2;
cards;
1 20 30
1 40...</title><content type='html'>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_&gt;0 and _stat_=&quot;MEAN&quot;)) ;<br />run;<br />data temp2;<br />set temp1(keep= id var1 var2);<br />run; </content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/3778560211954321613'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/3778560211954321613'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2016/01/first-and-last-variables.html?showComment=1611260628553#c3778560211954321613' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/3253344445918035869'/><author><name>Yogendra Negi</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/blank.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2016/01/first-and-last-variables.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-4473293187692112360' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/4473293187692112360' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-6939909"/><gd:extendedProperty name="blogger.displayTime" value="January 21, 2021 at 12:23 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-8916184507899910042</id><published>2021-01-21T11:43:06.555-08:00</published><updated>2021-01-21T11:43:06.555-08:00</updated><title type='text'>proc means data=t sum;
class x;
run;</title><content type='html'>proc means data=t sum;<br />class x;<br />run;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/8916184507899910042'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/8916184507899910042'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2016/01/first-and-last-variables.html?showComment=1611258186555#c8916184507899910042' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/7461383107835841577'/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/03387847735143906782</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2016/01/first-and-last-variables.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-4473293187692112360' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/4473293187692112360' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1591322397"/><gd:extendedProperty name="blogger.displayTime" value="January 21, 2021 at 11:43 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-7103744420839167600</id><published>2020-10-27T01:13:19.325-07:00</published><updated>2020-10-27T01:13:19.325-07:00</updated><title type='text'>hi,

what if happens if first.id=1 and last.id=0, ...</title><content type='html'>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=&#39;SCORE&#39;;<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=&#39;SCORE&#39;;<br />if first.id=1 and last.id=1 then status=&#39;unique&#39;;<br />run;<br />proc print data=T1;<br />run;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/7103744420839167600'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/7103744420839167600'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2016/01/first-and-last-variables.html?showComment=1603786399325#c7103744420839167600' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/1886393328602345822'/><author><name>Anto</name><uri>https://www.blogger.com/profile/10096848276225888261</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2016/01/first-and-last-variables.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-4473293187692112360' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/4473293187692112360' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1767258933"/><gd:extendedProperty name="blogger.displayTime" value="October 27, 2020 at 1:13 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-21636093712551830</id><published>2020-08-23T00:26:57.951-07:00</published><updated>2020-08-23T00:26:57.951-07:00</updated><title type='text'>proc sort data=readin out=r_sorted;
by id descendi...</title><content type='html'>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;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/21636093712551830'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/21636093712551830'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2016/01/first-and-last-variables.html?showComment=1598167617951#c21636093712551830' title=''/><author><name>alok singh</name><uri>https://www.blogger.com/profile/18351835671788632486</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2016/01/first-and-last-variables.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-4473293187692112360' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/4473293187692112360' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-161216113"/><gd:extendedProperty name="blogger.displayTime" value="August 23, 2020 at 12:26 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-4449688246148054063</id><published>2020-08-10T20:30:18.913-07:00</published><updated>2020-08-10T20:30:18.913-07:00</updated><title type='text'>data record;
input id name $ score;
cards;
1 david...</title><content type='html'>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 /></content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/4449688246148054063'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/4449688246148054063'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2016/01/first-and-last-variables.html?showComment=1597116618913#c4449688246148054063' title=''/><author><name>poonam</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/blank.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2016/01/first-and-last-variables.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-4473293187692112360' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/4473293187692112360' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-6939909"/><gd:extendedProperty name="blogger.displayTime" value="August 10, 2020 at 8:30 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-6792751626989476483</id><published>2020-07-22T00:48:19.614-07:00</published><updated>2020-07-22T00:48:19.614-07:00</updated><title type='text'>data akshay;
input 
id var1 var2;
cards;
1 20 30
1...</title><content type='html'>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;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/6792751626989476483'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/6792751626989476483'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2016/01/first-and-last-variables.html?showComment=1595404099614#c6792751626989476483' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/3253344445918035869'/><author><name>Akshay</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/blank.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2016/01/first-and-last-variables.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-4473293187692112360' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/4473293187692112360' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-6939909"/><gd:extendedProperty name="blogger.displayTime" value="July 22, 2020 at 12:48 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-7529349289412247815</id><published>2020-07-22T00:00:56.430-07:00</published><updated>2020-07-22T00:00:56.430-07:00</updated><title type='text'>data akshay;
input 
id date:anydtdte10. day$ &amp;...</title><content type='html'>data akshay;<br />input <br />id date:anydtdte10. day$ &amp;;<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;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/7529349289412247815'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/7529349289412247815'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2016/01/first-and-last-variables.html?showComment=1595401256430#c7529349289412247815' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/8929898464874116831'/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/12664079669219732959</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2016/01/first-and-last-variables.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-4473293187692112360' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/4473293187692112360' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1410066713"/><gd:extendedProperty name="blogger.displayTime" value="July 22, 2020 at 12:00 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-7222458972905580168</id><published>2020-07-21T23:32:48.535-07:00</published><updated>2020-07-21T23:32:48.535-07:00</updated><title type='text'>data temp;
input EMPID Expenses;
CARDS;
101 200
10...</title><content type='html'>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;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/7222458972905580168'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/7222458972905580168'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2016/01/first-and-last-variables.html?showComment=1595399568535#c7222458972905580168' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/3104507505534708191'/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/12664079669219732959</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2016/01/first-and-last-variables.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-4473293187692112360' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/4473293187692112360' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1410066713"/><gd:extendedProperty name="blogger.displayTime" value="July 21, 2020 at 11:32 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-2835764553842540088</id><published>2020-05-31T15:12:30.332-07:00</published><updated>2020-05-31T15:12:30.332-07:00</updated><title type='text'>proc sort data =readin out=test;
by id Score;
run;...</title><content type='html'>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;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/2835764553842540088'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/2835764553842540088'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2016/01/first-and-last-variables.html?showComment=1590963150332#c2835764553842540088' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/6565883514981599824'/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/15898040989099682318</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2016/01/first-and-last-variables.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-4473293187692112360' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/4473293187692112360' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-323575194"/><gd:extendedProperty name="blogger.displayTime" value="May 31, 2020 at 3:12 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-6224367433935603120</id><published>2020-05-31T15:11:08.437-07:00</published><updated>2020-05-31T15:11:08.437-07:00</updated><title type='text'>proc sort data =readin out=test;
by id Score;
run;...</title><content type='html'>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;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/6224367433935603120'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/6224367433935603120'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2016/01/first-and-last-variables.html?showComment=1590963068437#c6224367433935603120' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/15898040989099682318</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2016/01/first-and-last-variables.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-4473293187692112360' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/4473293187692112360' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-323575194"/><gd:extendedProperty name="blogger.displayTime" value="May 31, 2020 at 3:11 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-932346557692506824</id><published>2020-05-31T14:42:28.972-07:00</published><updated>2020-05-31T14:42:28.972-07:00</updated><title type='text'>proc sort data =temp;
by EMPID;
data test;
set tem...</title><content type='html'>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&gt;=5;<br />run;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/932346557692506824'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/932346557692506824'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2016/01/first-and-last-variables.html?showComment=1590961348972#c932346557692506824' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/3104507505534708191'/><author><name>Anonymous</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/blank.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2016/01/first-and-last-variables.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-4473293187692112360' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/4473293187692112360' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-6939909"/><gd:extendedProperty name="blogger.displayTime" value="May 31, 2020 at 2:42 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-4075208759041721779</id><published>2020-03-08T10:27:01.025-07:00</published><updated>2020-03-08T10:27:01.025-07:00</updated><title type='text'>PROC SORT DATA=temp;
BY EMPID;
RUN;

DATA TEST;
SE...</title><content type='html'>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 /></content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/4075208759041721779'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/4075208759041721779'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2016/01/first-and-last-variables.html?showComment=1583688421025#c4075208759041721779' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/1559383481750457893'/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/18125156539043507454</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2016/01/first-and-last-variables.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-4473293187692112360' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/4473293187692112360' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-891630290"/><gd:extendedProperty name="blogger.displayTime" value="March 8, 2020 at 10:27 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-1886393328602345822</id><published>2020-03-08T10:19:09.751-07:00</published><updated>2020-03-08T10:19:09.751-07:00</updated><title type='text'>SOLUTION OF 2ND QUERY:

PROC SORT DATA =READIN;
BY...</title><content type='html'>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=&#39;UNIQUE&#39;;<br />IF FIRST.ID =0 AND LAST.ID =1 THEN STATUS= SCORE;<br />RUN;<br /><br /><br /><br /><br /><br /><br /><br /></content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/1886393328602345822'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/1886393328602345822'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2016/01/first-and-last-variables.html?showComment=1583687949751#c1886393328602345822' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/18125156539043507454</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2016/01/first-and-last-variables.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-4473293187692112360' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/4473293187692112360' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-891630290"/><gd:extendedProperty name="blogger.displayTime" value="March 8, 2020 at 10:19 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-1559383481750457893</id><published>2019-09-10T05:41:10.809-07:00</published><updated>2019-09-10T05:41:10.809-07:00</updated><title type='text'>Hi All, With refer to below dataset, Can anyone pl...</title><content type='html'>Hi All, With refer to below dataset, Can anyone please assist me I want to have all those Empid&#39;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 />;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/1559383481750457893'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/1559383481750457893'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2016/01/first-and-last-variables.html?showComment=1568119270809#c1559383481750457893' title=''/><author><name>bindu</name><uri>https://www.blogger.com/profile/09389364650117573895</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2016/01/first-and-last-variables.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-4473293187692112360' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/4473293187692112360' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-268982334"/><gd:extendedProperty name="blogger.displayTime" value="September 10, 2019 at 5:41 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-3366606254450877860</id><published>2019-08-03T00:02:37.728-07:00</published><updated>2019-08-03T00:02:37.728-07:00</updated><title type='text'>someone please try to give solution for this query...</title><content type='html'>someone please try to give solution for this query.</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/3366606254450877860'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/3366606254450877860'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2016/01/first-and-last-variables.html?showComment=1564815757728#c3366606254450877860' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/3104507505534708191'/><author><name>Pankaj</name><uri>https://www.blogger.com/profile/10208906845851433227</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2016/01/first-and-last-variables.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-4473293187692112360' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/4473293187692112360' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-407237909"/><gd:extendedProperty name="blogger.displayTime" value="August 3, 2019 at 12:02 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-7461383107835841577</id><published>2019-06-26T04:37:52.244-07:00</published><updated>2019-06-26T04:37:52.244-07:00</updated><title type='text'>Data t;
Input x$ y;
A 5
B 3
C 4
A 6
B 9
C 3
;
Run;...</title><content type='html'>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=</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/7461383107835841577'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4473293187692112360/comments/default/7461383107835841577'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2016/01/first-and-last-variables.html?showComment=1561549072244#c7461383107835841577' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/01149765503246866406</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2016/01/first-and-last-variables.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-4473293187692112360' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/4473293187692112360' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1101459675"/><gd:extendedProperty name="blogger.displayTime" value="June 26, 2019 at 4:37 AM"/></entry></feed>