Hello, I want to perform locational attainment model, which takes the form: Yj  = a + b1X1ij+ b2X2ij + ..... + eij  where Y is a neighbourhood characteristic (such proportion of Black) and the Xs are individual characteristics (such as Black or White among others). Since, I estimate aggregate-level outcomes as a function of individual characteristics, this will generate autocorrelation and underestimation of standard errors. To solve that problem, I thus need to estimate the parameters using the generalized least squares method. My question is: how using that method with SAS? Thanks ... View more

Hello, I have a dataset which is a crossbat between age group (in row, 16 categories) and municipality (in line, 79 categories): 1 2 3 4 … 16 1 245 285 335 340 320 290 2 250 255 305 300 240 320 3 1470 1560 2020 1600 1255 1570 4 520 535 580 475 375 365 5 1190 1125 1280 1040 770 1065 … 79 1395 1695 2130 2150 1870 1265 I would like to transpose it in a data set of 3 rows and 79*16 lines: Municipality Age Group Population 1 1 245 1 2 285 ,, ,, … 1 79 290 ,,, ,,, … 79 14 1687 79 15 1543 79 16 1265 I'm sure it's easy, but I just don't know how. ... View more

Hello, I have a dataset ("population") consisting of about 10 000 observations. This dataset contains a variable "CITY", ranged 1 to 79 and a variable "AGE", ranged 0 to 75. In an Excel file, I have a value for each possibilites of these two variables (i.e. 79*76 lines). This variable is in fact a corrected ponderation that I need to assign to the observations of the dataset "population". I suppose I could a large number of "if then" commands like this: if city=1 then do; if age=0 then pond=1.2; if age=1 then pond=0.9; ... end; if city=79 then do; if age=75 then pond=1.3; end; But I guess it's not the more efficient way. Thanks ... View more

Hi, I have a dataset in which each line is a person with variables such as age, sex, language, etc. There is also a variable that links people living in a same household (HHNUM). With those data, I want to create a new dataset that keep all women aged between 15 and 49 years old, with a new variable that indicates if there is a child aged between 0 and 1 in her household. I guess it's a routine step, but I don't know what to do for this purpose. Thanks, PS. This board is really awesome. Thank for all. I hope I will be able to help other users when I'll be more familiar with SAS. ... View more