cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Elaine_S
‎02-25-2019
  • 2 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

To count number of firms given country year in panel data

by Calcite | Level 5 in SAS Programming
‎02-15-2019 12:32 PM
‎02-15-2019 12:32 PM
Hi, I am dealing with international data. I have four variables as follows. I would like to get the following variables and add the new variables at the end of my dataset.   1)  how many firms in each country. 2)  how many firms in each country each year.  2)  the average sale in a given year.  3)  the average sale in each year in each country   I try to do some coding as belows, but it does not work (no error reported, but in the new dataset, there is 0 obs) can anyone help?  Many thanks.   data have; input country $ year firm $ sales; cards; a 2000 a0201 20 a 2001 a0201 32 a 2002 a0201 31 a 2000 a0202 10 a 2001 a0202  9 a 2000 a0203  7.3 a 2001 a0203  4 a 2002 a0203  . a 2003 a0203  2.9 b 2000 a0204  13 b 2001 a0204  13 b 2002 a0204  18 b 2003 a0204  17 b 2004 a0204 15 b 2000 a0205 33 b 2001 a0205  45 b 2002 a0205  32 b 2003 a0205   38 ; run;   proc sort data=have; by country year ;run; data want; set have; by country year; if first.firm then firm=1;else count+1; if last.firm and count>1 then output; proc print; run; ... View more

Given year and month, how to formate a date variable?

by Calcite | Level 5 in SAS Programming
‎02-08-2019 12:49 AM
‎02-08-2019 12:49 AM
In my sample of data, I have firm, year, month and price variables. I would like to create a new variable with year-month-day in any sas format, where day is the last business day (or last day) of the given year month. Can anyone help me on it plz? Thanks   data tmp1; input year firm$ month$ price; datalines; 2004 AE0006 m1 8.2 2004 AE0006 m2 8.5 2004 AE0006 m3 8.2 2004 AE0006 m4 8.3 2004 AE0006 m5 8.4 2004 AE0006 m6 8.5 2004 AE0006 m7 8.6 2004 AE0006 m8 8.7 2004 AE0006 m9 8.8 2004 AE0006 m10 8.9 2004 AE0006 m11 9 2004 AE0006 m12 9.1 2005 AE0006 m1 9.2 2005 AE0006 m2 9.3 2005 AE0006 m3 9.4 2005 AE0006 m4 9.5 2005 AE0006 m5 9.6 2005 AE0006 m6 9.7 2005 AE0006 m7 9.8 2005 AE0006 m8 9.9 2005 AE0006 m9 10 2005 AE0006 m10 10.1 2005 AE0006 m11 10.2 2005 AE0006 m12 10.3 run;     Here is what I expect:   date                     price 31-Jan-2004         8.2 29-Feb-2004         8.5 31-Mar-2004         8.2 30-Apr-2004        8.3 31-May-2004       8.4 30-Jun-2004        8.5 31-Jul-2004         8.6 31-Aug-2004        8.7 30-Sep-2004       8.8 31-Oct-2004        8.9 30-Nov-2004       9 31-Dec-2004       9.1 31-Jan-2005       9.2 28-Feb-2005       9.3 31-Mar-2005       9.4 30-Apr-2005        9.5 31-May-2005       9.6 30-Jun-2005       9.7 31-Jul-2005        9.8 31-Aug-2005      9.9 30-Sep-2005     10 31-Oct-2005     10.1 30-Nov-2005     10.2 31-Dec-2005     10.3 ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎02-25-2019 08:03 PM
Quick links