Hello, I created two macro variables using proc sql select into. My expectation is that I will get two numbers and then continue to next step. The part of my is below: proc sql noprint;   select min(mean),max(mean)   INTO :mini,   :maxes   from plot1; quit; %LET low=%eval(&mini-10); %LET upper=%eval(&maxes+10); The error messages are: ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric        operand is required. The condition was: 290.6-10 ERROR: The macro PLOT will stop executing. I know one way to use input function in data step but not sure how to achieve my goal in this situation. Any suggestions are welcome and thanks for all. ... View more

Hello, I have a csv format data file that I'd like to read into SAS. Variables vary different length in the original data file. For example, "parfteoy","MAT04C2","MA","01010000","01010032","102309025","","00068023639805201406","MP09","1" "parfteoy","MAT07C2","MA","01010000","01010310","102436546","Mozilla/5.0 (X11; CrOS x86_64 5500.130.0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/34.0.1847.134 Safari/537.36","AAAKK14142P000206919","MC01","A" "parfteoy","MAT07C2","MA","01010000","01010310","102436546","Mozilla/5.0 (X11; CrOS x86_64 5500.130.0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/34.0.1847.134 Safari/537.36","AAAKK14142P000206919","MC18","Some of the questions I just didn't understand what it was asking me to do." I used data step to read in the file, and here is my codes. data EOY_survey1;   infile '....EOY_AL.txt'  dsd missover lrecl=600;   input Test_Admin_Code $ Test_Code $ State $ District $ School $ PA_Unique_ID $ Operating_System $ Clip_UIN $ Survey_Item_UIN $ Survey_Response $; run; No error messages but variables were truncated in Operating_System and Survey_Response. I have tried to set up the length but it worked only for Survey_Response, not for Operating_System. Could someone give me suggestions? Thanks a lot! ... View more

Hi, I have two vectors like A = {6,4,3,2,5,1}; B = {2,3}; I want to get another vector which contains the different elements comparing A and B. So I tried using SETDIF function. C = setdif(A,B); which returns the vector C is {1 4 5 6}. But, what I want is the not-sorted vector {6 4 5 1}. Does anyone know how I could get the vector I want? Thanks very much! ... View more