Thanks @Kurt_Bremser for your help. I am now able to run the program.
proc transpose
data=mydata.return
out=mydata.long (
drop=_name_
rename=(col1=y)
where=(y ne .)
)
;
by id;
var _:;
run;
Regards, Sara
... View more
Thanks for the information and code. I am now able to run both program successfully. Here is the model part which I added to pull all variables. Regards, Sara /* Regression Part*/
proc reg data=myfiles.&file noprint outest=myfiles.myest&file;
model F: = EPU;
... View more
Why bother to use proc import on a csv file, anyway? In the time it takes to clean the data of one file after the import, one can write several data steps to read several external files without all the hassle.
... View more
I'm afraid that SAS is going to give you all that information in the output data set. But if you just need the intercept, you can simply ignore the rest of the variables, or even drop the columns you don't need.
... View more
