That said, I wouldn't rely on the editor syntax highlighitng to tell you if it's correct code. Are you getting an error when you run what you? What are the issues? ... View more

You can use one filename that refers to multiple files. If they are all the same structure, and in your example it looks like they are, this would be much easier.   filename all_files ('file1.txt' file2.txt' etc...); ... View more

In your actual data, if there are a lot of variables you'll want to make sure that you only keep the "value2" that's used for the calculation. If you have a lot of other variables, it will not only mess up the other variables, but will slow processing. Other solutions that are less processing intensive? I don't know. There's a lot of way smarter people on here, so maybe they'll chime in. ... View more

You need to specify that your array is character with a "$"   You also will probably want to assign some appropriate length to the variables you created or you might see truncation. ... View more

Is there a direct function that does a look-ahead like the lag does a look-behind? Not that I know of. But you can find plenty of examples here of how to do this kind of a look-ahead calculation if that would suffice. ... View more

You should not have any issues just because it's xls. What products do you have for SAS/ACCESS? Try running "proc setinit; run;" to see what you have licensed. ... View more

I'm not sure I follow. What I think you have is the following:   data_no_labels data_yes_labels   Where the variables are the same (or at least many are, but the code can be adapted to account for only common variables).   You want to use the sql code to pull the label information from "data_yes_labels" and then apply it to data_no_labels using the proc data sets.   Is that not correct?   As Peter said, if you have do this with a lot, you can generate some kind of a loop or possible write a macro. But without more details, it's hard to say. But first, is my description not correct? ... View more

Agree with @Peter_C ... View more

What does the log say? If none of these match you should be getting zero obs due to the "if a and b;" Have you compared the values for bene_id in both data sets to make sure they have any overlap at all? ... View more