How to select variables beginning with "A"?

[supersasnewbie]

Hello,

I have a table of codes that I'm trying to select a subset from. However, I can't seem to be able to pull this correctly. Any help will be greatly appreciated!

The table, named tbl_CODES, only has one field, named PROC_CD. However, there is a mix of codes, such as: A1000, A1001, B1000, B2000, 00005, 00003. How do I create a table based on tbl_CODES where PROC_CDs begin with the character "A" only?

[Quentin]

Please show the code you have tried, and also any errors you see in the log.  If you have no errors but your code is not working, please describe how the results you are getting differ from what you want.

[ballardw · Accepted solution]

It sounds like you want the value of a specific variable, not "variables beginning with 'A' ".

The =: operator is a "begins with.

So an example with a data set you should have available:

proc print data=sashelp.class noobs;
   where name=:'A';
run;

Prints just the records where the Name variable starts with 'A'.

Or use in a data set option when indicating which data set you are using.

proc print data=sashelp.class(where=( name=:'A')) noobs;
;
run;