About yotsuba88

yotsuba88 · ‎10-17-2019

Hi novinosrin, I really appreciate your help. It seems working for me now and I have to format the date manually on my excel to run this. I need to double check and accept as solution.

yotsuba88 · ‎10-16-2019

Hi Shmuel, Thank you so much, your code makes sense to me but I have thousand of columns so I dont think it is an efficient way.

yotsuba88 · ‎10-16-2019

Yes, I import from Excel to SAS. Thank you, I am checking the code now

yotsuba88 · ‎10-16-2019

THank you so much, I checking on it now.

yotsuba88 · ‎10-16-2019

Yes, I changed my previous msg, but I dont know how to write to output. And I have thousands columns of a, a1, b,b2, when I add them up in one column, it has 1,5 million rows. So I cannot export to excel and do manually.

yotsuba88 · ‎10-16-2019

a a 1 b b1 c c1 1/01/2019 4 3/01/2018 12 10/05/2000 111 2/01/2019 8 4/01/2018 13 11/05/2000 112 3/01/2019 9 5/01/2018 14 12/05/2000 113 a 1/01/2019 4 a 2/01/2019 8 a 3/01/2019 9 b 3/01/2018 12 b 4/01/2018 13 b 5/01/2018 14 b 10/05/2000 111 b 11/05/2000 112 b 12/05/2000 113 Hi, Thank you so much for your reply. Sorry Now I copy and paste here and else attach file in case.

yotsuba88 · ‎10-16-2019

Hi guys, I want the data like below and want to move to same columns ( a, a) to one column name and 2 columns of data and number. I tried to add them into one column and extract later but the order is not correct. Please help and advise. Thank you so much, Ha

yotsuba88 · ‎07-31-2019

Hi Paige, Thank you for your question. I want to compare with the previous non-deleted date.

yotsuba88 · ‎07-30-2019

Hi admin and others, I have the data: ID EventDate Value 1 17/07/1999 a 1 08/8/1999 b 1 20/11/1999 c 1 04/06/2003 d 1 11/05/2005 e 1 08/09/2005 .. 1 02/11/2005 -- 1 17/2/2006 -- 1 28/09/2006-- I want to delete for the same id during the three months before or after Eventdate. So if the 17/07/1999 then next date is 20/11/1999, delete 08/10/1999 because intck ("month", 17/07/1999, 08/08/1999)< 3 months. But if 08/08/1999 deleted, then I will check 17/07/1999 and 20/11/199, the distance is more than 3 months then I keep it. The I tried to combine all data by itself by id, then if intck >3 then delete then I have two (17/7/1999 and 20/11/1999) ( 08/08/1999 and 20/11/1999) and I have no idea to delete 08/08. If first.date ... cannot work for this case and I cannot keep the last date if use intck. Please help and advise. Thank you so much, Ha

yotsuba88 · ‎01-19-2018

Thank you for your feedback and sorry for my short question. I have 2 datasets and other guys solve my question very well. Anw, I will give more details for next time. Thanks.

yotsuba88 · ‎01-19-2018

Thank you so much. I am trying to test it. Thank you.

yotsuba88 · ‎01-19-2018

Thank you so much, it seems work well in my data. I need to double check before make as a solution. Thank you again

yotsuba88 · ‎01-17-2018

Hi everyone, I want to merge yearly data (end of fiscal year) and monthly data (next year), could you please help me? For example. I have yearly data (ends of fiscal year)_ JUNE OF YEAR t June 2000 June 2001 June 2002 I want to merge with next year monthly data, so I will have (from JULY of year t to MAY of year t+1) June 2000 July 2000 June 2000 Aug 2000 June 2000 Sep 2000 ... June 2000 Jan 2001 June 2000 Feb 2001 June 2000 Mar 2001 June 2000 Apr 2001 June 2000 May 2001 June 2000 June 2001 June 2001 July 2001 Thank you very much. Ha

yotsuba88 · ‎09-19-2017

Hi, I have this table momr std_res sta_res _rsq id skewret 2.493 0.000 3.098 -0.085 0.478 1 5.324 -0.140 2.111 -0.041 0.283 2 4.694 -0.153 2.189 -0.053 0.317 3 5.122 -0.116 2.443 -0.062 0.429 4 5.763 -0.029 2.764 -0.058 0.444 5 6.116 -0.007 3.292 -0.057 0.352 I want to proc transpose to this: 1 2 3 4 5 (5)-(1) std_des 5.324 4.694 5.122 5.763 6.116 0.792 (49.55) sta_des -0.140 -0.153 -0.116 -0.029 -0.007 0.133 (9.55) _rsq 2.111 2.189 2.443 2.764 3.292 1.181 (3.55) ID -0.041 -0.053 -0.062 -0.058 -0.057 -0.015 (6.55) skewret 0.283 0.317 0.429 0.444 0.352 0.069 I run: proc transpose data=data out=want; var std_des sta_des _rsq id skewret;run; The result with proc tranpose has only COL1, I have no idea to fix it and I want to make a new Column = Column 5 - Column1 and have t-stat in (). Thank you so much for your help.

yotsuba88 · ‎07-03-2017

The name of table is the name of file. So I am not sure if I can insert one variable (column) and observation inside. ##- Please type your reply above this line. Simple formatting, no attachments. -##

Online Status	Offline
Date Last Visited	‎10-22-2019 05:17 AM

Re: How to change many columns to two columns

Re: How to change many columns to two columns

Re: How to change many columns to two columns

Re: How to change many columns to two columns

Re: How to change many columns to two columns

Re: How to change many columns to two columns

How to change many columns to two columns

Re: Nonoverlapping 3 months window

Nonoverlapping 3 months window

Re: How to merge fiscal year with month(s) of next year

Re: Nonoverlapping 3 months window

Re: Nonoverlapping 3 months window

Re: Nonoverlapping 3 months window

Re: How to merge fiscal year with month(s) of next year

Re: How to merge fiscal year with month(s) of next year

Re: How to change many columns to two columns

Re: How to change many columns to two columns

Re: How to change many columns to two columns

Re: How to change many columns to two columns

Re: How to change many columns to two columns

Re: How to change many columns to two columns

How to change many columns to two columns

Re: Nonoverlapping 3 months window

Nonoverlapping 3 months window

Re: How to merge fiscal year with month(s) of next year

Re: How to merge fiscal year with month(s) of next year

Re: How to merge fiscal year with month(s) of next year

How to merge fiscal year with month(s) of next year

How to use proc transpose

Re: Table Combination