Hello everybody, I have a simple code that is not doing what is supposed to and I am baffled...!  Here is the simplified version of the  code - I am explaining immediately after data coun1; set temp05; if exporter="SAU" or exporter="BHR" or exporter="QAT" or exporter="KWT" or exporter="OMN" or exporter="ARE" then EGCC=1; else EGCC=0; if importer="SAU" or importer="BHR" or importer="QAT" or importer="KWT" or importer="OMN" or exporter="ARE" then IGCC=1; else IGCC=0; run; data coun2; set coun1; if year=2015 or year =2005; proc sort ;by year; run; data igcc2; set coun2; if egcc=1 and igcc=1; run; _____________________ The problem is that the final file (igcc2) looks as follows which means that it is coding importers such as "ABW" and "AFG" with an IGCC=1. Could someone explain what is going on here? Thank you.     ... View more

Hello, I am trying to estimate:   proc glm data=pros3; class tickers; model clear=&va1 &va2 &va3 &va4/solution; output out=pros5 p=pred; run;   where the "va" variables are macro variables (characters) defined in a previous step (for example &va1 may insert the string "height*weight"  so that an interaction variable is included as an independent variable that estimates the product of variable height times weight - and includes it in the regression)    although this is working fine I need to repeat this numerous times and I need to repeat this with with more variables.  I was trying to use "model clear =&va1-&va4.......... but it does not allow me to.  Is there a different way to write consecutive, previously defined, macro-variables lists?  I know it would accept a list of variables that would read "ago1-ago10"  to include all variables from ago1 to ago10.  Can I do the same thing with my macro variables that are defined from &va1 to approximately &va100 ? Thank you Dimitrios   ... View more

Hello Everybody, got stuck again on the GMAP statement.  I was wondering if there is a pattern definition that will allow a gray filled color area with black lines for a pattern.  Following is my code where I have added some patterns experimenting on the four levels I have- but I could not find anything on the internet on how to solve my problem.  I am also attaching a jpg (inserted in a word file) of what I get and what I want in a screen shot of a small area of the map. Appreciate any help, best Dimitrios   /** code starts here***/ goptions reset=all cback=white border htitle=12pt htext=10pt display; footnote3 height=5 angle=90' '; pattern1 c=LIGGR ; pattern2 c=brgr; pattern3 v=m2n45 c=brgr ; pattern4 v=m2n45 c=LIGGR ; legend1 label=none shape=bar(4,2) value=(height=2) across=3 mode=share origin=(45,0); run;   proc gmap data=ma8 map=mapsgfk.world gout=gseg ; id idname; choro potential/ levels=4 coutline=black name='map1a' ; run;   /** code ends here***/ ... View more

Hello Everybody,   I need to figure out how to create a world map where two dummy variables (1-0) are plotted on one world map.  I need either:   1.  color variation for one variable and pattern variation for the second or 2.  pattern variation for one variable and country "perimeter" bolding for the other.   My current code to plot the first variable named potential1 is:   proc gmap data=ma3 map=mapsgfk.world gout=gseg ; id idname; choro potential1 / levels=2 coutline=black name='map1a' ; pattern1 v=solid repeat=48; run;   Thanks eveybody ... View more