Search results for query: *

I got it. Thanks so much for your help. This site is a god sent. Steve

Thank for the run info. I'm still learning, self taught. The problem is that there is now no output, it run without errors but shouldn't it be doing the proc print each time? Because I was going to take each output from the macros and merge then into one large file. Thanks for the help

Ok I have set a Macro Dpull and It works fine. Now I'm setting up a macro Drun. Drum is supposed to take a list of file names from a txt document and then use that list in place of fname in the Dpull macro. But I cant seem to get it to work. Hopefully you can help thank you all. Here is the...

I'm getting an error at the end of the code. There is no matching %DO statement for the %END. This statement will be ignored

I tried to modify the code but I'm not that experienced and could use some help. Do I just place this code after my code? Do I replace FOLDER= with the folder that contains the files? Do I have to change anything about "dir &folder /b"?

As a side note while I have you I need to get a bit of info from data that is very messy. But the information I need always comes before .avi in the text file. I know the column pointer can read after a "character" but can it read before the "character". Exp C:\Documents and Settings\All...

Well here is my macro, What I would like to do is take all the file in a folder and run them though this macro and the concatenate them all into a large file with all the data. But I don't want to have to invoke Dpull for each file by typing it out, there has to be a way of pulling the names...

Hi all, I'm kind of new to using macros, mostly us SAS for data analysis. I have setup a macro to do what I want but the problem is that it must be run on about 600 small files in a folder. There has got to be a better way then invoking a macro for each of the files by hand. Is there a way to...

Wicked cool. The reason I need to this is that I'm working with a longitudinal research database and there is the same variables for many years or waves (W1 W2 ...). So in need to change the names to put it into SPSS. Thanx

May problem is that I need to change the variable names in an excel sheet so that all the names have _W1 on them. I found a macro that can do this put I'm unsure of how to use it. I used proc contents to pull the names and symput to make then into a macro variable but I cant seem to get it to...

Sorry I was not clear. Maybe this can help you help me. Again code has 6 types but in the output I would like to be able to use each of the six standard deviation and means in a merged data set with arrowsort2. I tried this but it didn't work. Does this help thanks Steve proc means...

Here is my question can you label types within a variable in the by statement. (code) has 6 types (artr, antr, altr, altl, artl, antl) how can I label the mean and std for those types. I know how it can be done for variables. But I can't figure it out for types within a variable. Except for...

Thanks for the help. I'm still learning and I didn't know about || and the put statement. Steve

Thanx for your help this worked great. I didn't know about the last* statement Steve

data arrow4; set arrow3 (keep = RTc1 outlier accuracy code); length lastcode $4; retain lastCode; if lastcode = 'altl' then Tcount = 1; Tsum + Tcount; if (RTc1^=.) then do; if lastcode = 'altl' then Ttype = "AVL"_Tsum; end; I'm trying to label reactions times (RTc1) that met a criteria...

I have fix some stuff but im still having trouble with counting a iterations of the data. I would like _N_ to increase each time the if statement is met. data arrow4; set arrow3 (keep = RTc1 outlier accuracy code); length lastcode $4; retain lastCode; if lastcode = 'altl' and RTc1^='.' then...

Hi, Here is my code: data arrow4; set arrow3 (keep = RTc1 outlier accuracy code); length lastcode $4; retain lastCode; if (RTc1^=.) and lastcode = 'altl' then do; Do i = 1 to *; Ttype = "AVl(i)"; end; lastCode = Code; run; I'm trying to have Ttype = AVl1, AVl2, so no when the if statement is...

I have a data set in SAS and would like to compare variables from the same column. Obs Subject Type Code Time 1 1001.01 Picture al 1409567 2 1001.01 Picture altl...