tag:blogger.com,1999:blog-7958828565254404797.post1026034564205665718..comments2024-03-28T07:44:59.527-07:00Comments on ListenData: SAS : PROC TRANSPOSE with ExamplesDeepanshu Bhallahttp://www.blogger.com/profile/09802839558125192674noreply@blogger.comBlogger62125tag:blogger.com,1999:blog-7958828565254404797.post-72740607442347371632024-02-24T12:56:23.722-08:002024-02-24T12:56:23.722-08:00DATA INCOME_DATA;
INPUT ID SEX$ INCOME;
CARDS;
101...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 />Shubham Goyalhttps://www.blogger.com/profile/09979143197889832873noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-37366558487647732722024-02-24T12:56:10.262-08:002024-02-24T12:56:10.262-08:00DATA INCOME_DATA;
INPUT ID SEX$ INCOME;
CARDS;
101...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 />Shubham Goyalhttps://www.blogger.com/profile/09979143197889832873noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-57222052464280387492024-02-02T05:45:45.168-08:002024-02-02T05:45:45.168-08:00BY statement would show output for each level of t...BY statement would show output for each level of the BY variable on a separate rowDeepanshu Bhallahttps://www.blogger.com/profile/09802839558125192674noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-81724400522024390832024-02-01T10:09:03.801-08:002024-02-01T10:09:03.801-08:00Hi all,
I want to know what if I don't use by ...Hi all,<br />I want to know what if I don't use by statement in proc statement and only use id and var statement, what will happen? Please help!SRIhttps://www.blogger.com/profile/06189857166387281757noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-61631760962272902622024-02-01T10:07:36.419-08:002024-02-01T10:07:36.419-08:00Hi all,
Want to know that if I don't wanna use...Hi all,<br />Want to know that if I don't wanna use by statement in proc transpose, what will happen? SRIhttps://www.blogger.com/profile/06189857166387281757noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-12521839767524514102023-12-26T18:10:23.904-08:002023-12-26T18:10:23.904-08:00I don't see any difference using with or witho...I don't see any difference using with or without delimiter, please explain the purpose of delimiter option here.Laxmihttps://www.blogger.com/profile/17736773980790614357noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-18558970575994545982023-06-14T06:15:10.636-07:002023-06-14T06:15:10.636-07:00PROC TRANSPOSE DATA = readin OUT = READIN1;
BY ID...PROC TRANSPOSE DATA = readin OUT = READIN1;<br /> BY ID;<br /> ID DATE;<br /> VAR FLAG;<br /> <br />RUN;Shiva Upadhyayhttps://www.blogger.com/profile/13081535722241674080noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-2726005718454853842023-02-08T10:44:56.121-08:002023-02-08T10:44:56.121-08:00proc transpose data=readin2 out=readin3(rename=(_3...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; Sasihttps://www.blogger.com/profile/07049832837203675881noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-61226872758046832572022-04-05T03:17:28.976-07:002022-04-05T03:17:28.976-07:00it works..it works..Pate Shital Subhashhttps://www.blogger.com/profile/08554879423463718523noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-71810683719619380532021-12-04T01:35:44.537-08:002021-12-04T01:35:44.537-08:00proc transpose data=readin out=outdata(drop=_NAME_...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;Shakila Radhakrishnannoreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-16675328126412424992021-11-30T12:39:21.405-08:002021-11-30T12:39:21.405-08:00proc transpose data = readin out= readin2 (DROP=_...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;Karimullahttps://www.blogger.com/profile/15955770408894675118noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-59700104473120998192021-10-20T00:02:50.703-07:002021-10-20T00:02:50.703-07:00proc transpose data=readin name=id prefix=Y out=ou...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;Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-58674825890478971832021-10-08T10:09:33.882-07:002021-10-08T10:09:33.882-07:00data readin;
input ID date ddmmyy8. Flag$;
f...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;santoshhttps://www.blogger.com/profile/13318624073391619889noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-10649533605869194912021-10-07T03:35:58.612-07:002021-10-07T03:35:58.612-07:00data readin;
input ID date ddmmyy8. Flag$;
f...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;Anonymoushttps://www.blogger.com/profile/00871814568797014536noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-37355740234617002302021-09-14T11:16:48.600-07:002021-09-14T11:16:48.600-07:00LET will keep duplicate values of an ID VariableLET will keep duplicate values of an ID Variablechanduhttps://www.blogger.com/profile/16369510788702707873noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-10432826715765044382021-09-14T11:07:15.543-07:002021-09-14T11:07:15.543-07:00data readin;
input ID date ddmmyy8. Flag$;
format ...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 />chanduhttps://www.blogger.com/profile/16369510788702707873noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-2370828763059731492021-08-18T20:47:22.841-07:002021-08-18T20:47:22.841-07:00data readin;
input ID date ddmmyy8. Flag$;
f...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('_',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 />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-39783513825169344312021-06-21T07:57:52.373-07:002021-06-21T07:57:52.373-07:00proc transpose
data = readin
prefix = Y20...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("'", name, "'n", '=', tranwrd(name, '/', '_'))<br /> into :new_names separated by " "<br /> from dictionary.columns<br /> where libname eq 'WORK'<br /> and memname eq 'OUT'<br /> and name like 'Y%'<br />;quit;<br /> <br /> <br />data work.out;<br /> set work.out<br />(rename = (&new_names.))<br />;run;makeyhttps://www.blogger.com/profile/08400030735043472622noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-42661645659268909742021-05-31T18:49:04.465-07:002021-05-31T18:49:04.465-07:00proc transpose data=readin out=trans_readin (drop=...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 />Sas Scoophttps://www.blogger.com/profile/04332591558569794088noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-29140437296661811652021-04-26T08:41:55.479-07:002021-04-26T08:41:55.479-07:00Proc transpose doesnt work on duplicate values.Proc transpose doesnt work on duplicate values.zubairhttps://www.blogger.com/profile/12956336936504782865noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-13293813707418768452021-03-10T13:51:24.768-08:002021-03-10T13:51:24.768-08:00DATA readin2(drop=year month month1 day date);
set...<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 <10 then month1=('0'||strip(month));<br />else month1=month;<br />day =day(date);<br />date1 =(STRIP(YEAR)||"_"||STRIP(MONTH1)||"_"||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;Soumyadeephttps://www.blogger.com/profile/08788688128986551858noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-64127128937655415772021-01-29T23:18:15.912-08:002021-01-29T23:18:15.912-08:00data akshay;
set readin;
format date yymmdd10.;
ru...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 />Anonymoushttps://www.blogger.com/profile/15837901144983864759noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-89326632863459329522021-01-22T02:59:03.128-08:002021-01-22T02:59:03.128-08:00proc transpose data = one out = two(drop=_name_);...proc transpose data = one out = two(drop=_name_);<br />id cust account;<br />run;Yogendra Neginoreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-67504902118295682532021-01-14T13:19:00.218-08:002021-01-14T13:19:00.218-08:00thanks a lot!! thanks a lot!! katehttps://www.blogger.com/profile/14234847808779710242noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-74627840566686184092021-01-14T13:17:47.900-08:002021-01-14T13:17:47.900-08:00data new;
set readin;
year=year(date);
month=mo...data new;<br /> set readin;<br /> year=year(date);<br /> month=month(date);<br /> day=day(date);<br />run;<br /><br />proc transpose data=new out=readin_transp(drop=_name_) prefix=Y_ delimiter=_;<br /> by id;<br /> var flag;<br /> id year month day;<br />run;<br /><br />proc print data=readin_transp;<br />run;katehttp://kate1564.blogspot.comnoreply@blogger.com