Hello Experts,   I am trying to create a weight matrix for my economic model. I have a  shapefile of the census tracts for the state of missouri. When I open the shapefile or dbf file on any other application, it contains 1393 observations which is the total number of census tracts in the state but when I import into SAS, I have 974962 observations with multiple xy coordinates of the same geoid. Any idea why and how to resolve this. Thank you. /*Import shapefile*/ proc mapimport out=me.mo_shp datafile="C:\tracts\mo_new.shp"; id geoid; run; ... View more

Hello experts,   I need to use the XY_CORD table to complete the DATA table with w & h  XY values. I used proc sql (see code) to look up the values for w and h separately, then merged both files but I would appreciate a more efficient way to look up both values simultaneously. Thank you DATA     XY_CORD w_id h_id S000 w_x w_y h_x h_     ID POINT_X POINT_Y 295101011001003 290997014041047 1             295101011001003 737017.835 4270859.993 295101011001025 295101011001025 1             295101011001025 737539.960 4270379.588 295101011001026 291879507003038 1             295101011001026 737669.594 4270307.737 295101011001029 291892199006006 1             295101011001029 736570.054 4270925.217 295101011002007 295101011002015 1             295101011002007 737935.107 4271151.965 295101011002014 295101011001003 1             295101011002014 738029.091 4270895.108 295101011002016 295101011001007 1             295101011002016 738184.039 4271047.110 295101011002030 295101255001008 1             295101011002030 738075.570 4270987.989 295101012001003 295101165005004 1             295101012001003 737738.987 4271653.824 295101012001013 291892213322009 1             295101012001013 737987.607 4271525.811 295101012001015 291892119004002 1             295101012001015 737720.016 4271341.538 295101012001017 295101013003032 1             295101012001017 737390.287 4271360.476 295101012001019 171194028024003 1             295101012001019 737593.186 4271268.272 295101012002009 291833103011001 1             295101012002009 737080.947 4271826.731 295101012002013 295101012001002 1             295101012002013 737253.329 4271491.580 295101012003000 171194019032183 1             295101012003000 737584.582 4272481.255 295101012003002 290997001132021 1             295101012003002 737443.189 4272411.160 295101012003004 295101012002010 1             295101012003004 737515.429 4272332.304   /*For w locations*/ proc sql; create table coord as select * from me.data, me.xy_cord where data.w_id=xy_cord.id order by data.w_id; quit;   ... View more

Hello experts,   I am trying to measure the distance between locations but it returns null values, no error message. The  XY coordinates were generated using ARCGIS  projected coordinate system. I am using SAS 9.4. See below my codes and table. Thank you /*Calculate the distance*/ data state.c000dist; set state.c000_odxy; format distance best12.; distance=geodist(h_y, h_x, w_y, w_x); run; data state.c000dist; set state.c000_odxy; format distance best12.; distance=geodist(h_y, h_x, dest_y, dest_x, 'M'); run;     w_1 h_1 h_x h_y w_x w_y distance 295101011001003 291892204451015 1549820 3396739 737017.8 4270860   295101011001003 295101011001003 1704594 3199620 737017.8 4270860   295101011001003 291892202003011 1606500 3013045 737017.8 4270860   295101011001003 290997002112025 1590932 3380332 737017.8 4270860   295101011001003 290997001091013 1591513 3388368 737017.8 4270860   295101011001003 295101063002004 1586158 3403888 737017.8 4270860   295101011001003 290997014041047 1597463 3395733 737017.8 4270860   295101011001003 171635040011097 1057384 3381480 737017.8 4270860   295101011001025 295101021003001 1538631 3137542 737540 4270380   295101011001025 295101011001025 1537792 3138305 737540 4270380   295101011001025 295101021001013 1536083 3135691 737540 4270380   295101011001025 171194034022007 1545883 3145134 737540 4270380   295101011001025 290997014042011 1591510 3221054 737540 4270380   295101011001026 291879507003038 1615559 2994634 737669.6 4270308   295101011001026 190130007001013 1790677 2920093 737669.6 4270308   295101011001026 295101105001027 1790300 2919619 737669.6 4270308   295101011001026 291892126002008 1787475 2915743 737669.6 4270308   295101011001026 291892126001005 1783127 2913354 737669.6 4270308   295101011001029 291892199006006 1783154 2913153 736570.1 4270925   ... View more

Hello experts, I have survey results like the table below. For ease of analysis,  I extracted the 1st character and converted to numeric cause of the missing values, the first time I ran the code the complete table was created, the second  time there are lots of observations missing, cant seem to find out why, the log does not have an error statement. Thanks;   /*Sample code*/ data sample; set have; new_var=substr(old_var,1,1); run;   If device=  ' ' then A001=0; else If device= 'b' then A001=1; else If device='c' then A001=2; label A001="device"; run;   Device active social media Age Gender satisfied with CSR preferred time to call Location   b=No 22 a=1   e= Anytime b=instate b=iphone a=Yes 28 b=2 a=Yes a=Morning a=outstate b=iphone   35   a=Yes e= Anytime a=outstate b=iphone a=Yes 35 b=2 a=Yes e= Anytime b=instate a=samsung a=Yes 27   a=Yes e= Anytime b=instate a=samsung a=Yes 32   a=Yes a=Morning b=instate     37 b=2     b=instate b=iphone b=No 28 a=1 a=Yes   b=instate   b=No 25       a=outstate   b=No   a=1   a=Morning a=outstate     30yrs       b=instate c=a & b       a=Yes e= Anytime     b=No               23 b=2   c=Afternoon b=instate     30 b=2     b=instate a=samsung b=No     a=Yes e= Anytime                 I  ... View more

Hi experts,   I made a simple line graph using proc sgplot; however, I believe that combining the summary statistics table generated using the proc means command in the same plot may be more intuitive.Can anyone help with this. Attached: graph and table   Thank you,    ... View more