Hello, I am using SAS Enterprise Guide. I'd like to do some quick exploratory analysis of a data set that's already loaded in my work library, however when I run the code below I get the error message "Statement is not valid or is used out of proper order".   NROW(dataset); I would also be very interested in learning what people's favorite EDA functions are, wish there was a SAS equivalent of the str() function in R. ... View more

I have a table with the following fields: Happiness Income Happy 4 55000 Yes 7 90000 Yes -3 120000 No 8 42000 Yes -6 17000 No   I am trying to create a scatter plot of the results where all Happy="Yes" points show up as blue and all Happy="Red" points show up as red. Unfortunately, my code produces the inverse (happy folks show up as red). How do I specify that SYMBOL1 should be applied to Happy="No" values and SYMBOL2 to Happy="Yes"?     /*Graph results*/ TITLE 'Happiness vs. Income'; SYMBOL1 VALUE=dot HEIGHT=0.3 CO=RED; SYMBOL2 VALUE=dot HEIGHT=0.3 CO=STEEL; PROC GPLOT DATA=PL_H3_DRC_POLS; PLOT Happiness*Income=Happy ; RUN;   Thanks in advance for the help   ... View more

I am a new SAS user wondering the most efficient way to set up my program. It's made up of about a dozen DATA and PROC SQL steps that do basic transformations to my input data set. The final output is a simple table with summary metrics for that data set. I'd like to run several other data sets through the same script and have the program return summary tables for each one.  In R, I would approach this by creating a vector with all my data set names and then use a FOR LOOP to run the program for each of the data sets in the vector. Would this approach work in SAS and if so, what would the code look like?      Thank you in advance for the help!     ... View more

Hi, I am new to SAS and can't figure out how to create a table with all possible permutations from multiple vectors (I actually don't know how to create the vectors either). Could someone point me in the right direction on how to do this?   Here is an example of what I am trying to do and how it would be done in R using the expand.grid() function:   #Create vectors states <- c("MA", "NY") seasons <- c("Fall", "Winter", "Spring", "Summer") activities <- c("TV", "Board Games") #Create data frame with all permutations permutations <- expand.grid(states, seasons, activities) The resulting "permutations" table would be: Var1 Var2 Var3 1 MA Fall TV 2 NY Fall TV 3 MA Winter TV 4 NY Winter TV 5 MA Spring TV 6 NY Spring TV 7 MA Summer TV 8 NY Summer TV 9 MA Fall Board Games 10 NY Fall Board Games 11 MA Winter Board Games 12 NY Winter Board Games 13 MA Spring Board Games 14 NY Spring Board Games 15 MA Summer Board Games 16 NY Summer Board Games ... View more

I have been working on a SAS project and all of a sudden when I run it the following error message window pops up 10+ times:   "The project log exceeds the maximum size of 5 megabytes.   To clear or turn off the project log, select View > Project Log, and use the Clear Log or Turn Off options."   Can someone explain the issue as well as the best solution for it? I am not sure how to turn off the project log, "Enable project log for new projects" is not checked off in my options. I am using SAS EG 7.11 64 bit.   Thank you ... View more