I am trying to merge a few datasets I have. I get the following error:   ERROR: Variable year1 has been defined as both character and numeric.   I understand what it means and how it works, however, I am wondering if there is a simple line to convert all observations in the data to numeric (or character for that matter) at once. ... View more

I have a column full of dates in the following format "04JAN2010" and would like to have it reformatted to just so the year ("2010"). I saw on a previous post about using the length function, however I got an error because its a "numeric variable"  ... View more

This may be a simple answer but I'm not quite sure how to do it. I am running proc reg on my data set using by variable called "Deal_id" there are about 640 deal_id points and 200 points for each deal id.  I've been using proc reg and running it no problem to find the different slopes and intercepts using the code below:   proc reg data =temp1; model ret = mret; by deal_id; run;   What I'm trying to do after to have a table created that will show deal_id then each respect slope and intercept and standard error for the 640 cases from the regression run. I can't figure out how to pull out these three variables into a new table. Maybe there is another PROC that makes this simpler? ... View more

I have a sas file with 6210 rows with a column "date" formated as mm/dd/yyy (06/30/2002 for example) and I would like to convert it to a string that would read the date as yyyymmdd (20020630 for the date above).  ... View more

I have been trying to run the following code to import an excel data set.   libname fin617 '/folders/myshortcuts/fin617'; data fin617.week1and2; set import; run; I return the following log with this error and warnings:   1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 libname fin617 '/folders/myshortcuts/fin617'; NOTE: Libref FIN617 was successfully assigned as follows: Engine: V9 Physical Name: /folders/myshortcuts/fin617 74 75 data fin617.week1and2; 76 set import; ERROR: File WORK.IMPORT.DATA does not exist. 77 run;   NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set FIN617.WEEK1AND2 may be incomplete. When this step was stopped there were 0 observations and 0 variables. WARNING: Data set FIN617.WEEK1AND2 was not replaced because this step was stopped. NOTE: DATA statement used (Total process time): real time 0.09 seconds cpu time 0.02 seconds     78 79 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 91   I am not sure of how to fix this or even what this error means. I have tried restarting the SAS program, my computer, and double checking the file name. ... View more