I am trying to learn the SAS %MACRO procedure but something is not working correctly. I am using the SasHelp.PriceData data set and am trying to write some simply code to calculate the median and coefficient of variation for each price feature (preice1-price17). I am running the below code. When I invoke my %DO_Median macro I expect there to be 17 Median_&I table, however the macro does not seem to be generating any output as currently written. What am i missing or not understanding about the %MACRO syntax?   %MACRO DO_MEDIAN; %DO I=1 %TO I=17; PROC MEANS DATA=SasHelp.PriceData NOPRINT; VAR price&I; OUTPUT OUT=work.Medians_&I Median=Med_&I CV=CV_&I; RUN; %END; %MEND DO_MEDIAN; %DO_MEDIAN; ... View more

I am trying to map data that falls into two categories. I have the ability to structure the data such that I can have the records for each category in one table with a response variable identifying the category, or i could keep the records in separate tables for each category. My goal is to map these records and assign a different scatter plot color to each category. Is this possible with the SGMAP procedure? ... View more

I am new to the PROC SGMAP procedure and after reviewing the documentation and online examples I have a question regarding the transparency of the polygons created in the Choromap statement. Currently the only outputs I can produce displays these polygons as opaque which prevents me from viewing information on the openstreet or esri background map. I have experimented with the NOOPAQUE option in the SGMAP statement but it does not seem to effect the opacity of the choromap polygons.   Does the GMAP procedure have the functionality to control the opacity of the choromap polygons? Is this a feature i need to control using a graph style template rather than in the SGMAP proc itself? ... View more

I am new to the PROC SGMAP procedure and after reviewing the documentation and online examples I have a question regarding the transparency of the polygons created in the Choromap statement. Currently the only outputs I can produce displays these polygons as opaque which prevents me from viewing information on the openstreet or esri background map. I have experimented with the NOOPAQUE option in the SGMAP statement but it does not seem to effect the opacity of the choromap polygons.   Does the GMAP procedure have the functionality to control the opacity of the choromap polygons? Is this a feature i need to control using a graph style template rather than in the SGMAP proc itself? ... View more

I am working through an problem where I have merged together numerous data sets and am trying to efficiently have SAS select which dataset to assign to a final set of variables. An example of the variables in the data set would be:   CoV1 Level1 Light1 Cov2 Level2 Light2 Cov3 Level3 Light3   Currently i am working through the data in a long form way with examples such as   IF CoV1 < Cov2 AND CoV1 < CoV3 THEN      DO;             CoV=CoV1             Level=Level1             Light=Light1      END; ELSE IF  CoV2 < CoV1 AND CoV2 < CoV3 THEN     DO;             CoV=CoV2             Level=Level2             Light=Light2      END; ELSE IF  CoV3 < CoV1 AND CoV3 < CoV2 THEN     DO;             CoV=CoV3             Level=Level3             Light=Light3      END;   Obviously this long form programming poses problems problems when the number of merged files grows, I feel like there is a far more efficient way to program this type of decision in SAS, possibly using an array or other tools in the datastep.   Basically for each record i am trying to determine the minimum of CoV(1-3) variable and assign the CoV, Level and Light from that data set to the new variables CoV, Level and Light. ... View more

Greetings and Thanks in advance for the help. I feel like I am hung up on an issue that will be simple and obvious if someone can explain it to me. I am attempting to produce a simple bar graph from a data field that has been modified using a PROC format statement. However the bar graph is showing incorrectly (the format level range with the "high" designation is repeated numerous times and the frequencies for all ranges are off. Below is the an example of the code I am using with the example sashelp.cars dataset. along with the incorrect graphing output compared to the correct PROC FREQ output. How do I get my PROC GCHART output to match the PROC FREQ output?   PROC FORMAT; VALUE Price low-20000 = '0-20K'             20000<-35000 = '20K-35K'             35000<-50000 = '35K-50k'             50000<-high = '50K+'; RUN;   DATA work.cars;      SET sashelp.cars;      FORMAT MSRP Price.; RUN;   PROC FREQ DATA=work.Cars;      Tables MSRP / NOPERCENT NOCUM; RUN;   PROC GCHART DATA=work.Cars;      VBAR MSRP; RUN; QUIT;     ... View more

I am working on a model that performs regression analysis using the PROC GLMSELECT statement. In order to make my program as dynamic as possible I would like to assign all of the numeric variables from my source table to a macro variable that can be referenced in the model statement, thus allowing the name and number of variables in the input table to change without the need to change the regression code. I would also like to create a macro variable for the categorical variables to be referenced in the Class statement. Please help! ... View more