Hi all, my second question... I use the query wizard to query data rather then command line type programming. I'm afraid I don't know what SAS EG version it is... it's not on my PC, it is a remote instance that I access via an online method. It is quite a restrictive set up, but it's the only way I can access this data. One of the fields I want to include in my query is populated with a 5 char string (for example AA123, AA124, AA125 etc). However, if I pull it in as is, the query result is way too big, and all I actually need is the first two characters of the code. In sql it would be select substring(Hcode,1,2) as H_summary... if that clarifies? I can't work out how to do it though. Any help gratefully received.
... View more