Hi,   I have a SAS program. Using the file mod and put statements I can append lines to the end of this program. But say I want to write "hello" to line 1 or line 30 or any specific line of the code. How would I go about doing that?   Thanks. ... View more

Hi, the situation I have is a list of macro variables like follows; var_2030 var_2031 var_2032 etc.   During the data step, which involves a loop, I need to use more than one:   data test; x=2; do i=1 to 3; %let t=2030+i; If x<&&var_&t then put 'success'; %end; run;   Unfortunately, &&var_&t resolves as (var_2030) + i instead of (var_(2030+i)).   I've tried using %let t=%sysevalf(2030+i) but it then complains that there is a character variable instead of numeric. I also understand this may be related to macro values being evaluated before data steps are executed, so is this possible?   Thanks very much.     ... View more

Hi, I have a simple problem (I hope). I am using file and put to write text to a different sas program. For example   data _null_; file "filepath.sas"; put "x=1"; run;   Please  can you tell me how I make it so the code writes the text to the first blank line of "filepath.sas". This is so when I run this again but with different text e.g. put "y=2", it doesn't overwrite the x=1, but adds to it underneath.   Thank you ... View more

Hello,   I have a dataset "data1" & I create a data view "stuff" by: libname s "filepath";   data s.stuff/view=s.stuff; set s.data1; run;   However, now it seems I always need "data1" to be in the folder s in order for SAS to be able read "stuff". If I move it, it won't read the data view.   The point of me creating the view  was to save space by being able to remove the dataset.   Is  there a way of doing this?   Thanks ... View more