<?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&amp;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;&#xa;INPUT ID SEX$ INCOME;&#xa;CARDS;&#xa;101...</title><content type='html'>DATA INCOME_DATA;&lt;br /&gt;INPUT ID SEX$ INCOME;&lt;br /&gt;CARDS;&lt;br /&gt;101 M 20000&lt;br /&gt;102 F 20000&lt;br /&gt;103 F 50000&lt;br /&gt;101 M 10000&lt;br /&gt;103 F 18000&lt;br /&gt;102 F 21000&lt;br /&gt;102 F 11000&lt;br /&gt;103 F 49000&lt;br /&gt;101 M 20000&lt;br /&gt;;&lt;br /&gt;RUN;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;PROC SORT DATA=INCOME_DATA;&lt;br /&gt;BY ID SEX;&lt;br /&gt;RUN;&lt;br /&gt;&lt;br /&gt;PROC TRANSPOSE DATA=INCOME_DATA OUT=T_DATA(DROP=_NAME_) PREFIX=INCOME;&lt;br /&gt;BY ID SEX;&lt;br /&gt;VAR INCOME;&lt;br /&gt;RUN;&lt;br /&gt;</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;&#xa;INPUT ID SEX$ INCOME;&#xa;CARDS;&#xa;101...</title><content type='html'>DATA INCOME_DATA;&lt;br /&gt;INPUT ID SEX$ INCOME;&lt;br /&gt;CARDS;&lt;br /&gt;101 M 20000&lt;br /&gt;102 F 20000&lt;br /&gt;103 F 50000&lt;br /&gt;101 M 10000&lt;br /&gt;103 F 18000&lt;br /&gt;102 F 21000&lt;br /&gt;102 F 11000&lt;br /&gt;103 F 49000&lt;br /&gt;101 M 20000&lt;br /&gt;;&lt;br /&gt;RUN;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;PROC SORT DATA=INCOME_DATA;&lt;br /&gt;BY ID SEX;&lt;br /&gt;RUN;&lt;br /&gt;&lt;br /&gt;PROC TRANSPOSE DATA=INCOME_DATA OUT=T_DATA(DROP=_NAME_) PREFIX=INCOME;&lt;br /&gt;BY ID SEX;&lt;br /&gt;VAR INCOME;&lt;br /&gt;RUN;&lt;br /&gt;</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,&#xa;I want to know what if I don&amp;#39;t use by ...</title><content type='html'>Hi all,&lt;br /&gt;I want to know what if I don&amp;#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,&#xa;Want to know that if I don&amp;#39;t wanna use...</title><content type='html'>Hi all,&lt;br /&gt;Want to know that if I don&amp;#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&amp;#39;t see any difference using with or witho...</title><content type='html'>I don&amp;#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;&#xa;&#x9;BY ID...</title><content type='html'>PROC TRANSPOSE DATA = readin OUT = READIN1;&lt;br /&gt;	BY ID;&lt;br /&gt;	ID DATE;&lt;br /&gt;	VAR FLAG;&lt;br /&gt;	&lt;br /&gt;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 &lt;br /&gt;_31_08_18=y2018_08_31 _30_06_16=y2016_06_30 _31_12_18=y2018_12_31)drop=_name_);&lt;br /&gt;by id;&lt;br /&gt;id date; &lt;br /&gt;var flag; &lt;br /&gt;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; &lt;br /&gt;id date;&lt;br /&gt;format date yymmdd10.;&lt;br /&gt;var flag; &lt;br /&gt;by id; &lt;br /&gt;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;&lt;br /&gt;format date yymmdd10.;&lt;br /&gt;by ID;&lt;br /&gt;ID date;&lt;br /&gt;VAR FLAG;&lt;br /&gt;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);&lt;br /&gt;format date yymmddb10.;&lt;br /&gt;by id;&lt;br /&gt;id date;&lt;br /&gt;var flag;&lt;br /&gt;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;&#xa;   input ID date ddmmyy8. Flag$;&#xa;   f...</title><content type='html'>data readin;&lt;br /&gt;   input ID date ddmmyy8. Flag$;&lt;br /&gt;   format date yymmdd10.;&lt;br /&gt;   cards;&lt;br /&gt;1 30-12-16 Y&lt;br /&gt;1 30-08-17  N&lt;br /&gt;1 31-08-18  N&lt;br /&gt;2 30-06-16 Y&lt;br /&gt;2 31-12-18 N&lt;br /&gt;;&lt;br /&gt;run;&lt;br /&gt;proc print;&lt;br /&gt;run;&lt;br /&gt;proc sort data=example;&lt;br /&gt;by id;&lt;br /&gt;run;&lt;br /&gt;proc transpose data=readin out=dad (drop=_name_) prefix=y ;&lt;br /&gt;id date;&lt;br /&gt;var flag;&lt;br /&gt;by id;&lt;br /&gt;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;&#xa;   input ID date ddmmyy8. Flag$;&#xa;   f...</title><content type='html'>data readin;&lt;br /&gt;   input ID date ddmmyy8. Flag$;&lt;br /&gt;   format date ddmmyy8.;&lt;br /&gt;   cards;&lt;br /&gt;1 30-12-16 Y&lt;br /&gt;1 30-08-17  N&lt;br /&gt;1 31-08-18  N&lt;br /&gt;2 30-06-16 Y&lt;br /&gt;2 31-12-18 N&lt;br /&gt;;&lt;br /&gt;run;&lt;br /&gt;proc sort data=readin;&lt;br /&gt;by ID; run;&lt;br /&gt;proc transpose data=readin  out=readin1(drop=_name_)  prefix=y;&lt;br /&gt;id date;&lt;br /&gt;var Flag;&lt;br /&gt;by ID;&lt;br /&gt;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;&#xa;input ID date ddmmyy8. Flag$;&#xa;format ...</title><content type='html'>data readin;&lt;br /&gt;input ID date ddmmyy8. Flag$;&lt;br /&gt;format date ddmmyy8.;&lt;br /&gt;cards;&lt;br /&gt;1 30-12-16 Y&lt;br /&gt;1 30-08-17 N&lt;br /&gt;1 31-08-18 N&lt;br /&gt;2 30-06-16 Y&lt;br /&gt;2 31-12-18 N&lt;br /&gt;;&lt;br /&gt;run;&lt;br /&gt;&lt;br /&gt;proc transpose data=readin out=read(drop=_name_) prefix=Y20;&lt;br /&gt;format date yymmdd8.;&lt;br /&gt;var flag;&lt;br /&gt;by id;&lt;br /&gt;id date;&lt;br /&gt;run;&lt;br /&gt;</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;&#xa;   input ID date ddmmyy8. Flag$;&#xa;   f...</title><content type='html'>data readin;&lt;br /&gt;   input ID date ddmmyy8. Flag$;&lt;br /&gt;   format date ddmmyy8.;&lt;br /&gt;   cards;&lt;br /&gt;1 30-12-16 Y&lt;br /&gt;1 30-08-17  N&lt;br /&gt;1 31-08-18  N&lt;br /&gt;2 30-06-16 Y&lt;br /&gt;2 31-12-18 N&lt;br /&gt;;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;data new;&lt;br /&gt;set readin;&lt;br /&gt;day=day(date);&lt;br /&gt;month=month(date);&lt;br /&gt;yr=year(date);&lt;br /&gt;date1=catx(&amp;#39;_&amp;#39;,day,month,yr);&lt;br /&gt;drop day month yr date;&lt;br /&gt;run;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;proc transpose data=new out=readin_t(drop=_name_) prefix=Y20;&lt;br /&gt;var flag;&lt;br /&gt;by id;&lt;br /&gt;id date1;&lt;br /&gt;run;&lt;br /&gt;</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&#xa;      data = readin&#xa;   prefix = Y20...</title><content type='html'>proc transpose&lt;br /&gt;      data = readin&lt;br /&gt;   prefix = Y20&lt;br /&gt;      out = out(drop = _name_);&lt;br /&gt;       by id;&lt;br /&gt;      var flag;&lt;br /&gt;       id date&lt;br /&gt;;run;&lt;br /&gt; &lt;br /&gt; &lt;br /&gt;proc sql ;&lt;br /&gt;     select cats(&amp;quot;&amp;#39;&amp;quot;, name, &amp;quot;&amp;#39;n&amp;quot;, &amp;#39;=&amp;#39;,  tranwrd(name, &amp;#39;/&amp;#39;, &amp;#39;_&amp;#39;))&lt;br /&gt;       into :new_names separated by &amp;quot; &amp;quot;&lt;br /&gt;      from dictionary.columns&lt;br /&gt;     where libname eq &amp;#39;WORK&amp;#39;&lt;br /&gt;        and memname eq &amp;#39;OUT&amp;#39;&lt;br /&gt;        and name like &amp;#39;Y%&amp;#39;&lt;br /&gt;;quit;&lt;br /&gt; &lt;br /&gt; &lt;br /&gt;data work.out;&lt;br /&gt;    set work.out&lt;br /&gt;(rename = (&amp;amp;new_names.))&lt;br /&gt;;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;&lt;br /&gt;id date;&lt;br /&gt;var Flag;&lt;br /&gt;by  ID;&lt;br /&gt;run;&lt;br /&gt;proc print;&lt;br /&gt;run;&lt;br /&gt;</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);&#xa;set...</title><content type='html'>&lt;br /&gt;DATA readin2(drop=year month month1 day date);&lt;br /&gt;set readin;&lt;br /&gt;format date ddmmyy10.;&lt;br /&gt;year=year(date);&lt;br /&gt;month=month(date);&lt;br /&gt;IF month &amp;lt;10 then month1=(&amp;#39;0&amp;#39;||strip(month));&lt;br /&gt;else month1=month;&lt;br /&gt;day =day(date);&lt;br /&gt;date1 =(STRIP(YEAR)||&amp;quot;_&amp;quot;||STRIP(MONTH1)||&amp;quot;_&amp;quot;||STRIP(DAY));&lt;br /&gt;run;&lt;br /&gt;&lt;br /&gt;proc transpose data=readin2 prefix=Y out=outdata(drop=_Name_);&lt;br /&gt;id date1;&lt;br /&gt;BY ID;&lt;br /&gt;var Flag;&lt;br /&gt;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;&#xa;set readin;&#xa;format date yymmdd10.;&#xa;ru...</title><content type='html'>data akshay;&lt;br /&gt;set readin;&lt;br /&gt;format date yymmdd10.;&lt;br /&gt;run;&lt;br /&gt;&lt;br /&gt;It will give you date format 2016-12-30&lt;br /&gt;&lt;br /&gt;Then you run this code:&lt;br /&gt;&lt;br /&gt;proc transpose data= readin1 out= Output1 delimiter= _  prefix=Y Name= date ;&lt;br /&gt;id Date;&lt;br /&gt;var flag;&lt;br /&gt;by ID;&lt;br /&gt;run;&lt;br /&gt;</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_);&lt;br /&gt;id cust account;&lt;br /&gt;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;&#xa; input ID date ddmmyy8. Flag$;&#xa; forma...</title><content type='html'>data readin;&lt;br /&gt; input ID date ddmmyy8. Flag$;&lt;br /&gt; format date ddmmyy8.;&lt;br /&gt; cards;&lt;br /&gt;1 30-12-16 Y&lt;br /&gt;1 30-08-17  N&lt;br /&gt;1 31-08-18  N&lt;br /&gt;2 30-06-16 Y&lt;br /&gt;2 31-12-18 N&lt;br /&gt;;&lt;br /&gt;run;&lt;br /&gt;&lt;br /&gt;data read;&lt;br /&gt; set readin;&lt;br /&gt; year=year(date);&lt;br /&gt; month=month(date);&lt;br /&gt; day=day(date);&lt;br /&gt;run;&lt;br /&gt;&lt;br /&gt;proc transpose data=read out=read_transposed (drop=_name_) prefix=Y delimiter=_;&lt;br /&gt; id year month day;&lt;br /&gt; var flag;&lt;br /&gt; by id;&lt;br /&gt;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>