topic Re: How to select variables beginning with "A"? in SAS Programming

How to select variables beginning with "A"?

supersasnewbie — Fri, 02 Sep 2022 16:21:32 GMT

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?

Re: How to select variables beginning with "A"?

Quentin — Fri, 02 Sep 2022 16:29:37 GMT

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.

Re: How to select variables beginning with "A"?

ballardw — Fri, 02 Sep 2022 16:48:34 GMT

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;