<?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.post1026034564205665718..comments</id><updated>2024-12-13T03:11:35.450-08:00</updated><title type='text'>Comments on ListenData: SAS : PROC TRANSPOSE with Examples</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/1026034564205665718/comments/default'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/08/sas-proc-transpose-explained.html'/><link rel="hub" href="http://pubsubhubbub.appspot.com/"/><link rel='next' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/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>56</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-7274060744234737163</id><published>2024-02-24T12:56:23.722-08:00</published><updated>2024-02-24T12:56:23.722-08:00</updated><title type='text'>DATA INCOME_DATA;
INPUT ID SEX$ INCOME;
CARDS;
101...</title><content type='html'>DATA INCOME_DATA;<br />INPUT ID SEX$ INCOME;<br />CARDS;<br />101 M 20000<br />102 F 20000<br />103 F 50000<br />101 M 10000<br />103 F 18000<br />102 F 21000<br />102 F 11000<br />103 F 49000<br />101 M 20000<br />;<br />RUN;<br /><br /><br />PROC SORT DATA=INCOME_DATA;<br />BY ID SEX;<br />RUN;<br /><br />PROC TRANSPOSE DATA=INCOME_DATA OUT=T_DATA(DROP=_NAME_) PREFIX=INCOME;<br />BY ID SEX;<br />VAR INCOME;<br />RUN;<br /></content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/7274060744234737163'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/7274060744234737163'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/08/sas-proc-transpose-explained.html?showComment=1708808183722#c7274060744234737163' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/1892303019740904568'/><author><name>Shubham Goyal</name><uri>https://www.blogger.com/profile/09979143197889832873</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/2015/08/sas-proc-transpose-explained.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-1026034564205665718' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/1026034564205665718' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-347601094"/><gd:extendedProperty name="blogger.displayTime" value="February 24, 2024 at 12:56 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-3736655848764773272</id><published>2024-02-24T12:56:10.262-08:00</published><updated>2024-02-24T12:56:10.262-08:00</updated><title type='text'>DATA INCOME_DATA;
INPUT ID SEX$ INCOME;
CARDS;
101...</title><content type='html'>DATA INCOME_DATA;<br />INPUT ID SEX$ INCOME;<br />CARDS;<br />101 M 20000<br />102 F 20000<br />103 F 50000<br />101 M 10000<br />103 F 18000<br />102 F 21000<br />102 F 11000<br />103 F 49000<br />101 M 20000<br />;<br />RUN;<br /><br /><br />PROC SORT DATA=INCOME_DATA;<br />BY ID SEX;<br />RUN;<br /><br />PROC TRANSPOSE DATA=INCOME_DATA OUT=T_DATA(DROP=_NAME_) PREFIX=INCOME;<br />BY ID SEX;<br />VAR INCOME;<br />RUN;<br /></content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/3736655848764773272'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/3736655848764773272'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/08/sas-proc-transpose-explained.html?showComment=1708808170262#c3736655848764773272' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/1892303019740904568'/><author><name>Shubham Goyal</name><uri>https://www.blogger.com/profile/09979143197889832873</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/2015/08/sas-proc-transpose-explained.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-1026034564205665718' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/1026034564205665718' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-347601094"/><gd:extendedProperty name="blogger.displayTime" value="February 24, 2024 at 12:56 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-5722205246428038749</id><published>2024-02-02T05:45:45.168-08:00</published><updated>2024-02-02T05:45:45.168-08:00</updated><title type='text'>BY statement would show output for each level of t...</title><content type='html'>BY statement would show output for each level of the BY variable on a separate row</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/5722205246428038749'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/5722205246428038749'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/08/sas-proc-transpose-explained.html?showComment=1706881545168#c5722205246428038749' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/8172440052202439083'/><author><name>Deepanshu Bhalla</name><uri>https://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><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2015/08/sas-proc-transpose-explained.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-1026034564205665718' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/1026034564205665718' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-966036103"/><gd:extendedProperty name="blogger.displayTime" value="February 2, 2024 at 5:45 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-8172440052202439083</id><published>2024-02-01T10:09:03.801-08:00</published><updated>2024-02-01T10:09:03.801-08:00</updated><title type='text'>Hi all,
I want to know what if I don&#39;t use by ...</title><content type='html'>Hi all,<br />I want to know what if I don&#39;t use by statement in proc statement and only use id and var statement, what will happen? Please help!</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/8172440052202439083'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/8172440052202439083'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/08/sas-proc-transpose-explained.html?showComment=1706810943801#c8172440052202439083' title=''/><author><name>SRI</name><uri>https://www.blogger.com/profile/06189857166387281757</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/2015/08/sas-proc-transpose-explained.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-1026034564205665718' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/1026034564205665718' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-493546222"/><gd:extendedProperty name="blogger.displayTime" value="February 1, 2024 at 10:09 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-6163176096227290262</id><published>2024-02-01T10:07:36.419-08:00</published><updated>2024-02-01T10:07:36.419-08:00</updated><title type='text'>Hi all,
Want to know that if I don&#39;t wanna use...</title><content type='html'>Hi all,<br />Want to know that if I don&#39;t wanna use by statement in proc transpose, what will happen? </content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/6163176096227290262'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/6163176096227290262'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/08/sas-proc-transpose-explained.html?showComment=1706810856419#c6163176096227290262' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/2232414296186870292'/><author><name>SRI</name><uri>https://www.blogger.com/profile/06189857166387281757</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/2015/08/sas-proc-transpose-explained.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-1026034564205665718' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/1026034564205665718' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-493546222"/><gd:extendedProperty name="blogger.displayTime" value="February 1, 2024 at 10:07 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-1252183976752451410</id><published>2023-12-26T18:10:23.904-08:00</published><updated>2023-12-26T18:10:23.904-08:00</updated><title type='text'>I don&#39;t see any difference using with or witho...</title><content type='html'>I don&#39;t see any difference using with or without delimiter, please explain the purpose of delimiter option here.</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/1252183976752451410'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/1252183976752451410'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/08/sas-proc-transpose-explained.html?showComment=1703643023904#c1252183976752451410' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/3934238943157515064'/><author><name>Laxmi</name><uri>https://www.blogger.com/profile/17736773980790614357</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/2015/08/sas-proc-transpose-explained.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-1026034564205665718' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/1026034564205665718' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1737515761"/><gd:extendedProperty name="blogger.displayTime" value="December 26, 2023 at 6:10 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-1855897057599454598</id><published>2023-06-14T06:15:10.636-07:00</published><updated>2023-06-14T06:15:10.636-07:00</updated><title type='text'>PROC TRANSPOSE DATA = readin OUT = READIN1;
	BY ID...</title><content type='html'>PROC TRANSPOSE DATA = readin OUT = READIN1;<br /> BY ID;<br /> ID DATE;<br /> VAR FLAG;<br /> <br />RUN;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/1855897057599454598'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/1855897057599454598'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/08/sas-proc-transpose-explained.html?showComment=1686748510636#c1855897057599454598' title=''/><author><name>Shiva Upadhyay</name><uri>https://www.blogger.com/profile/13081535722241674080</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/2015/08/sas-proc-transpose-explained.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-1026034564205665718' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/1026034564205665718' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1996613775"/><gd:extendedProperty name="blogger.displayTime" value="June 14, 2023 at 6:15 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-272600571845485384</id><published>2023-02-08T10:44:56.121-08:00</published><updated>2023-02-08T10:44:56.121-08:00</updated><title type='text'>proc transpose data=readin2 out=readin3(rename=(_3...</title><content type='html'>proc transpose data=readin2 out=readin3(rename=(_30_12_16=y2016_12_30 _30_08_17=y2017_08_30 <br />_31_08_18=y2018_08_31 _30_06_16=y2016_06_30 _31_12_18=y2018_12_31)drop=_name_);<br />by id;<br />id date; <br />var flag; <br />run; </content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/272600571845485384'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/272600571845485384'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/08/sas-proc-transpose-explained.html?showComment=1675881896121#c272600571845485384' title=''/><author><name>Sasi</name><uri>https://www.blogger.com/profile/07049832837203675881</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/2015/08/sas-proc-transpose-explained.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-1026034564205665718' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/1026034564205665718' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-975170853"/><gd:extendedProperty name="blogger.displayTime" value="February 8, 2023 at 10:44 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-6122687275804683257</id><published>2022-04-05T03:17:28.976-07:00</published><updated>2022-04-05T03:17:28.976-07:00</updated><title type='text'>it works..</title><content type='html'>it works..</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/6122687275804683257'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/6122687275804683257'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/08/sas-proc-transpose-explained.html?showComment=1649153848976#c6122687275804683257' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/1892303019740904568'/><author><name>Pate Shital Subhash</name><uri>https://www.blogger.com/profile/08554879423463718523</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/2015/08/sas-proc-transpose-explained.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-1026034564205665718' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/1026034564205665718' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1220034045"/><gd:extendedProperty name="blogger.displayTime" value="April 5, 2022 at 3:17 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-7181068371961938053</id><published>2021-12-04T01:35:44.537-08:00</published><updated>2021-12-04T01:35:44.537-08:00</updated><title type='text'>proc transpose data=readin out=outdata(drop=_NAME_...</title><content type='html'>proc transpose data=readin out=outdata(drop=_NAME_) prefix=Y; <br />id date;<br />format date yymmdd10.;<br />var flag; <br />by id; <br />run;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/7181068371961938053'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/7181068371961938053'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/08/sas-proc-transpose-explained.html?showComment=1638610544537#c7181068371961938053' title=''/><author><name>Shakila Radhakrishnan</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/2015/08/sas-proc-transpose-explained.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-1026034564205665718' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/1026034564205665718' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-6939909"/><gd:extendedProperty name="blogger.displayTime" value="December 4, 2021 at 1:35 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-1667532812641242499</id><published>2021-11-30T12:39:21.405-08:00</published><updated>2021-11-30T12:39:21.405-08:00</updated><title type='text'>proc transpose data = readin out= readin2 (DROP=_...</title><content type='html'>proc transpose data = readin out= readin2 (DROP=_NAME_) prefix=Y;<br />format date yymmdd10.;<br />by ID;<br />ID date;<br />VAR FLAG;<br />run;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/1667532812641242499'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/1667532812641242499'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/08/sas-proc-transpose-explained.html?showComment=1638304761405#c1667532812641242499' title=''/><author><name>Karimulla</name><uri>https://www.blogger.com/profile/15955770408894675118</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/2015/08/sas-proc-transpose-explained.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-1026034564205665718' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/1026034564205665718' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-553664470"/><gd:extendedProperty name="blogger.displayTime" value="November 30, 2021 at 12:39 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-5970010447312099819</id><published>2021-10-20T00:02:50.703-07:00</published><updated>2021-10-20T00:02:50.703-07:00</updated><title type='text'>proc transpose data=readin name=id prefix=Y out=ou...</title><content type='html'>proc transpose data=readin name=id prefix=Y out=out2 (DROP= id);<br />format date yymmddb10.;<br />by id;<br />id date;<br />var flag;<br />run;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/5970010447312099819'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/5970010447312099819'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/08/sas-proc-transpose-explained.html?showComment=1634713370703#c5970010447312099819' title=''/><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/2015/08/sas-proc-transpose-explained.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-1026034564205665718' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/1026034564205665718' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-6939909"/><gd:extendedProperty name="blogger.displayTime" value="October 20, 2021 at 12:02 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-5867482589047897183</id><published>2021-10-08T10:09:33.882-07:00</published><updated>2021-10-08T10:09:33.882-07:00</updated><title type='text'>data readin;
 input ID date ddmmyy8. Flag$;
 f...</title><content type='html'>data readin;<br /> input ID date ddmmyy8. Flag$;<br /> format date yymmdd10.;<br /> cards;<br />1 30-12-16 Y<br />1 30-08-17 N<br />1 31-08-18 N<br />2 30-06-16 Y<br />2 31-12-18 N<br />;<br />run;<br />proc print;<br />run;<br />proc sort data=example;<br />by id;<br />run;<br />proc transpose data=readin out=dad (drop=_name_) prefix=y ;<br />id date;<br />var flag;<br />by id;<br />run;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/5867482589047897183'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/5867482589047897183'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/08/sas-proc-transpose-explained.html?showComment=1633712973882#c5867482589047897183' title=''/><author><name>santosh</name><uri>https://www.blogger.com/profile/13318624073391619889</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/2015/08/sas-proc-transpose-explained.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-1026034564205665718' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/1026034564205665718' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1090252185"/><gd:extendedProperty name="blogger.displayTime" value="October 8, 2021 at 10:09 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-1064953360586919491</id><published>2021-10-07T03:35:58.612-07:00</published><updated>2021-10-07T03:35:58.612-07:00</updated><title type='text'>data readin;
 input ID date ddmmyy8. Flag$;
 f...</title><content type='html'>data readin;<br /> input ID date ddmmyy8. Flag$;<br /> format date ddmmyy8.;<br /> cards;<br />1 30-12-16 Y<br />1 30-08-17 N<br />1 31-08-18 N<br />2 30-06-16 Y<br />2 31-12-18 N<br />;<br />run;<br />proc sort data=readin;<br />by ID; run;<br />proc transpose data=readin out=readin1(drop=_name_) prefix=y;<br />id date;<br />var Flag;<br />by ID;<br />run;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/1064953360586919491'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/1064953360586919491'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/08/sas-proc-transpose-explained.html?showComment=1633602958612#c1064953360586919491' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/00871814568797014536</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/2015/08/sas-proc-transpose-explained.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-1026034564205665718' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/1026034564205665718' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-557916361"/><gd:extendedProperty name="blogger.displayTime" value="October 7, 2021 at 3:35 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-3735574023461700230</id><published>2021-09-14T11:16:48.600-07:00</published><updated>2021-09-14T11:16:48.600-07:00</updated><title type='text'>LET will keep duplicate values of an ID Variable</title><content type='html'>LET will keep duplicate values of an ID Variable</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/3735574023461700230'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/3735574023461700230'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/08/sas-proc-transpose-explained.html?showComment=1631643408600#c3735574023461700230' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/3302458975845195718'/><author><name>chandu</name><uri>https://www.blogger.com/profile/16369510788702707873</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/2015/08/sas-proc-transpose-explained.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-1026034564205665718' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/1026034564205665718' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1841276769"/><gd:extendedProperty name="blogger.displayTime" value="September 14, 2021 at 11:16 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-1043282671576504438</id><published>2021-09-14T11:07:15.543-07:00</published><updated>2021-09-14T11:07:15.543-07:00</updated><title type='text'>data readin;
input ID date ddmmyy8. Flag$;
format ...</title><content type='html'>data readin;<br />input ID date ddmmyy8. Flag$;<br />format date ddmmyy8.;<br />cards;<br />1 30-12-16 Y<br />1 30-08-17 N<br />1 31-08-18 N<br />2 30-06-16 Y<br />2 31-12-18 N<br />;<br />run;<br /><br />proc transpose data=readin out=read(drop=_name_) prefix=Y20;<br />format date yymmdd8.;<br />var flag;<br />by id;<br />id date;<br />run;<br /></content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/1043282671576504438'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/1043282671576504438'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/08/sas-proc-transpose-explained.html?showComment=1631642835543#c1043282671576504438' title=''/><author><name>chandu</name><uri>https://www.blogger.com/profile/16369510788702707873</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/2015/08/sas-proc-transpose-explained.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-1026034564205665718' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/1026034564205665718' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1841276769"/><gd:extendedProperty name="blogger.displayTime" value="September 14, 2021 at 11:07 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-237082876305973149</id><published>2021-08-18T20:47:22.841-07:00</published><updated>2021-08-18T20:47:22.841-07:00</updated><title type='text'>data readin;
 input ID date ddmmyy8. Flag$;
 f...</title><content type='html'>data readin;<br /> input ID date ddmmyy8. Flag$;<br /> format date ddmmyy8.;<br /> cards;<br />1 30-12-16 Y<br />1 30-08-17 N<br />1 31-08-18 N<br />2 30-06-16 Y<br />2 31-12-18 N<br />;<br /><br /><br />data new;<br />set readin;<br />day=day(date);<br />month=month(date);<br />yr=year(date);<br />date1=catx(&#39;_&#39;,day,month,yr);<br />drop day month yr date;<br />run;<br /><br /><br />proc transpose data=new out=readin_t(drop=_name_) prefix=Y20;<br />var flag;<br />by id;<br />id date1;<br />run;<br /></content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/237082876305973149'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/237082876305973149'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/08/sas-proc-transpose-explained.html?showComment=1629344842841#c237082876305973149' title=''/><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/2015/08/sas-proc-transpose-explained.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-1026034564205665718' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/1026034564205665718' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-6939909"/><gd:extendedProperty name="blogger.displayTime" value="August 18, 2021 at 8:47 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-3978351382516934431</id><published>2021-06-21T07:57:52.373-07:00</published><updated>2021-06-21T07:57:52.373-07:00</updated><title type='text'>proc transpose
 data = readin
 prefix = Y20...</title><content type='html'>proc transpose<br /> data = readin<br /> prefix = Y20<br /> out = out(drop = _name_);<br /> by id;<br /> var flag;<br /> id date<br />;run;<br /> <br /> <br />proc sql ;<br /> select cats(&quot;&#39;&quot;, name, &quot;&#39;n&quot;, &#39;=&#39;, tranwrd(name, &#39;/&#39;, &#39;_&#39;))<br /> into :new_names separated by &quot; &quot;<br /> from dictionary.columns<br /> where libname eq &#39;WORK&#39;<br /> and memname eq &#39;OUT&#39;<br /> and name like &#39;Y%&#39;<br />;quit;<br /> <br /> <br />data work.out;<br /> set work.out<br />(rename = (&amp;new_names.))<br />;run;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/3978351382516934431'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/3978351382516934431'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/08/sas-proc-transpose-explained.html?showComment=1624287472373#c3978351382516934431' title=''/><author><name>makey</name><uri>https://www.blogger.com/profile/08400030735043472622</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/2015/08/sas-proc-transpose-explained.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-1026034564205665718' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/1026034564205665718' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-187669949"/><gd:extendedProperty name="blogger.displayTime" value="June 21, 2021 at 7:57 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-4266164565926890974</id><published>2021-05-31T18:49:04.465-07:00</published><updated>2021-05-31T18:49:04.465-07:00</updated><title type='text'>proc transpose data=readin out=trans_readin (drop=...</title><content type='html'>proc transpose data=readin out=trans_readin (drop=_name_) prefix=y;<br />id date;<br />var Flag;<br />by ID;<br />run;<br />proc print;<br />run;<br /></content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/4266164565926890974'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/4266164565926890974'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/08/sas-proc-transpose-explained.html?showComment=1622512144465#c4266164565926890974' title=''/><author><name>Sas Scoop</name><uri>https://www.blogger.com/profile/04332591558569794088</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/2015/08/sas-proc-transpose-explained.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-1026034564205665718' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/1026034564205665718' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1274626366"/><gd:extendedProperty name="blogger.displayTime" value="May 31, 2021 at 6:49 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-2914043729666181165</id><published>2021-04-26T08:41:55.479-07:00</published><updated>2021-04-26T08:41:55.479-07:00</updated><title type='text'>Proc transpose doesnt work on duplicate values.</title><content type='html'>Proc transpose doesnt work on duplicate values.</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/2914043729666181165'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/2914043729666181165'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/08/sas-proc-transpose-explained.html?showComment=1619451715479#c2914043729666181165' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/4129420285296061628'/><author><name>zubair</name><uri>https://www.blogger.com/profile/12956336936504782865</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/2015/08/sas-proc-transpose-explained.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-1026034564205665718' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/1026034564205665718' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1694732448"/><gd:extendedProperty name="blogger.displayTime" value="April 26, 2021 at 8:41 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-1329381370741876845</id><published>2021-03-10T13:51:24.768-08:00</published><updated>2021-03-10T13:51:24.768-08:00</updated><title type='text'>DATA readin2(drop=year month month1 day date);
set...</title><content type='html'><br />DATA readin2(drop=year month month1 day date);<br />set readin;<br />format date ddmmyy10.;<br />year=year(date);<br />month=month(date);<br />IF month &lt;10 then month1=(&#39;0&#39;||strip(month));<br />else month1=month;<br />day =day(date);<br />date1 =(STRIP(YEAR)||&quot;_&quot;||STRIP(MONTH1)||&quot;_&quot;||STRIP(DAY));<br />run;<br /><br />proc transpose data=readin2 prefix=Y out=outdata(drop=_Name_);<br />id date1;<br />BY ID;<br />var Flag;<br />run;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/1329381370741876845'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/1329381370741876845'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/08/sas-proc-transpose-explained.html?showComment=1615413084768#c1329381370741876845' title=''/><author><name>Soumyadeep</name><uri>https://www.blogger.com/profile/08788688128986551858</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/2015/08/sas-proc-transpose-explained.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-1026034564205665718' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/1026034564205665718' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-40415357"/><gd:extendedProperty name="blogger.displayTime" value="March 10, 2021 at 1:51 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-6412712893765541577</id><published>2021-01-29T23:18:15.912-08:00</published><updated>2021-01-29T23:18:15.912-08:00</updated><title type='text'>data akshay;
set readin;
format date yymmdd10.;
ru...</title><content type='html'>data akshay;<br />set readin;<br />format date yymmdd10.;<br />run;<br /><br />It will give you date format 2016-12-30<br /><br />Then you run this code:<br /><br />proc transpose data= readin1 out= Output1 delimiter= _ prefix=Y Name= date ;<br />id Date;<br />var flag;<br />by ID;<br />run;<br /></content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/6412712893765541577'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/6412712893765541577'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/08/sas-proc-transpose-explained.html?showComment=1611991095912#c6412712893765541577' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/6970522220115709230'/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/15837901144983864759</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/2015/08/sas-proc-transpose-explained.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-1026034564205665718' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/1026034564205665718' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-2097189476"/><gd:extendedProperty name="blogger.displayTime" value="January 29, 2021 at 11:18 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-8932663286345932952</id><published>2021-01-22T02:59:03.128-08:00</published><updated>2021-01-22T02:59:03.128-08:00</updated><title type='text'>proc transpose data = one out = two(drop=_name_);...</title><content type='html'>proc transpose data = one out = two(drop=_name_);<br />id cust account;<br />run;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/8932663286345932952'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/8932663286345932952'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/08/sas-proc-transpose-explained.html?showComment=1611313143128#c8932663286345932952' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/4129420285296061628'/><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/2015/08/sas-proc-transpose-explained.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-1026034564205665718' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/1026034564205665718' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-6939909"/><gd:extendedProperty name="blogger.displayTime" value="January 22, 2021 at 2:59 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-6750490211829568253</id><published>2021-01-14T13:19:00.218-08:00</published><updated>2021-01-14T13:19:00.218-08:00</updated><title type='text'>thanks a lot!! </title><content type='html'>thanks a lot!! </content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/6750490211829568253'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/6750490211829568253'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/08/sas-proc-transpose-explained.html?showComment=1610659140218#c6750490211829568253' title=''/><author><name>kate</name><uri>https://www.blogger.com/profile/14234847808779710242</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/AVvXsEh7KnGn9QLsMfim2frdOfC3cY_5Zqo_Gm7xOSQB4jfYwNXq7Xfto2G3tdZweX98LgGt4rWRj4XRm7nHLgNi1zUV4Knw155D32BmVZntzgd0gnPE_KE1cWlz_eu8mWb-7jM/s220/IMG_8573.JPG'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2015/08/sas-proc-transpose-explained.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-1026034564205665718' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/1026034564205665718' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-2070290085"/><gd:extendedProperty name="blogger.displayTime" value="January 14, 2021 at 1:19 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-8543873129737234075</id><published>2020-11-16T01:10:45.228-08:00</published><updated>2020-11-16T01:10:45.228-08:00</updated><title type='text'>data readin;
 input ID date ddmmyy8. Flag$;
 forma...</title><content type='html'>data readin;<br /> input ID date ddmmyy8. Flag$;<br /> format date ddmmyy8.;<br /> cards;<br />1 30-12-16 Y<br />1 30-08-17 N<br />1 31-08-18 N<br />2 30-06-16 Y<br />2 31-12-18 N<br />;<br />run;<br /><br />data read;<br /> set readin;<br /> year=year(date);<br /> month=month(date);<br /> day=day(date);<br />run;<br /><br />proc transpose data=read out=read_transposed (drop=_name_) prefix=Y delimiter=_;<br /> id year month day;<br /> var flag;<br /> by id;<br />run;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/8543873129737234075'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1026034564205665718/comments/default/8543873129737234075'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/08/sas-proc-transpose-explained.html?showComment=1605517845228#c8543873129737234075' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/14018317564671310887</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/2015/08/sas-proc-transpose-explained.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-1026034564205665718' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/1026034564205665718' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-946419772"/><gd:extendedProperty name="blogger.displayTime" value="November 16, 2020 at 1:10 AM"/></entry></feed>