I have my variable names in line 8, and my data starts at line 14. I'm not able to figure out how to import the data while skipping those other lines. Currently I am importing line 8 exclusively, using getnames, creating an empty table with variable names (over 120). Then importing all the data to a temporary table. Then adding the data from the temporary table to the empty table that has the variable names. It seems like there should be a way to designate the header row and designate a different starting row.   *Update: the variable names are important. I have about 20 different excel files, all with the same format, and each file has different variable names (all 120+) that are important for the task at hand. Editing the file isn't an option at the moment. ... View more

The following code stores the number 30 into macro variable x, but it stores it as a character value, correct? Given that, how does the following where clause work? If age is stored as numeric and the macro variable x as character, the where clause is conditioning on numeric variable greater than character variable. Why does this work?   %let x=30; proc sql; select * from table where age>&x; quit;   ... View more

Is there a way to create a syntax help box for a user defined function in SAS EG? Normally when you hover over a function, a box pops up stating the arguments, context, syntax, and definition. Is there anyway to create this for a user defined function? So when I use the function, it pops up showing the different arguments with a description of what types of inputs are accepted.   ... View more