If I have 2 data sets: data investment;      begin='01JAN1990'd;    end='31DEC2009'd;   run;     data investment_2;      begin='01JAN1990'd;      run;  I wish to write a program that will give me list of all columns that are in investment but not in investment_2. So in this case, the variable 'end'. How to do this? I dont want to list out the column names using proc contents on eaqch dataset and then manually eyeball it and check for differences. ... View more

I have this code inside a macro: %if &macro_var =%str() %then                        %do;       %put ERROR: The macro_var is not set.;          %return;    %end; I am getting error: WARNING: Apparent symbolic reference macro_var  not resolved. ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand is required. The condition was: &macro_var= The WARNING is ok..because the macro_var has not been set. But Why is it throwing an error? Why is it looking for a numeric operand? How to resolve this? Basically I am trying to check if a macro variable is null or has been set with a proper value. ... View more

I have this data in an excel: 2 rows and 2 columns... Name  abc Age   14 Name abc Age 14 I want to represent it like this:  Name Age abc  14 Name Age abc 14 How can i use proc transpose to do this? I am looking for a method that would work even if Name / Age variables are null in the input ... View more

Is there a way to access machine learning algorithms like random forests, support vector machines using bases sas and enterprise guide only? Or do we need to have SAS enterprise miner installed? ... View more

I have a date that is coming in from an excel like this:2014Q3. How to convert this to the last day of the quarter and store in date9. format like 30SEP2014.t ... View more

I have a table like this: col1 col2    col3      col4 A    B      alpha      0.5 A    B      beta       1.00 col4 is numeric. Now I want the row corresponding to the max value of col4, so I just want to select the second row. How to do this? ... View more

I have a left join like this: proc sql; select * from a left join b on          (             case when a.code <> "" then a.code = b.code              else a.code2 =  b.code2             end          ) ; quit; Basically join a to b on code if it is non null in A else join A to B on code2. Problem is that A has 100 rows but output has 90 rows only. Why is this? ... View more

I came across a data step like this in my program: data test  ;    infile '/sasdata/REF.txt'           lrecl = 256           delimiter = '    '           dsd           missover           firstobs = 2;    ;    attrib MODEL_NM length = $11       format = $11.       informat = $11.;              input MODEL_NM;   attrib GRADE_ID length = $3       format = $3.       informat = $3.; input MODEL_NM GRADE_ID run; My questions are: 1. Why we need to specify length explicitly, when it is already specified in the format and informat? 2. The delimiter '  '---> if the column model_nm has a value like 'ABC  123' will it read correctly as one column...or as separate columns because of the space? ... View more