About moumes

moumes · ‎02-12-2017

Thank you for your reply, those are the databases i am using : as you see in the first database i have the Global Company Key which is a variable that identifies the company and values for other variables for each quarter from 2002 to 2013. In the second database i have the Global Company Key and a specific date in this format YYYYMMDD, i need to convert this format to quarters and then extract the value of the variables included in the first database based on the dated specified in the second one. Thank you a lot for your hep.

moumes · ‎02-11-2017

Hi i am a begginer on SAS and i need some help: My first problem is converting the date, i have the following format : 20020331 so YYYYMMDD and i would like to have the year and the quarter so this format 2002Q1 (YYYYQQ ). My second problem is about merging two databases based on mutual information included on both of them: my first database is a large database containing the date, the ID number and other variables for example: Global Company Key Fiscal Data Year and Quarter Current Assets - Total Assets - Total Cash and Short-Term Investments Long-Term Debt - Total Current Liabilities - Total Liabilities - Total Net Income (Loss) 1034 2002Q1 639,409 2367,051 9,689 880,936 368,339 1373,972 -31,94 1034 2002Q2 695,609 2448,679 12,884 899,789 381,368 1384,204 10,159 1034 2002Q3 700,596 2416,691 41,2 907,505 345,285 1357,847 -5,946 And my second database contains the date and the ID number for example: RankDate RankdateQ targetGkey 20091102 2009Q4 1034 I would like to extract the variables included in the first database based on specific date included in the second one. It would be really helpfull if someone can help, i am struggling with this for quiet a while. Thank you in advance.

Online Status	Offline
Date Last Visited	‎02-12-2017 08:45 PM

Re: Convert Date and sort out data

Convert Date and sort out data

Re: Convert Date and sort out data

Convert Date and sort out data