turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Find a Community

- Home
- /
- SAS Programming
- /
- General Programming
- /
- simple question on subsetting data

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

12-17-2013 10:26 AM

Hi Everyone!

I am **new** to SAS but I am trying to create a program but Im not getting any output, which tells me I'm doing something wrong. I have two data sets and I want to subset the data and find only the transactions that ...for the variable 'X' starts with 4. Here is what I tried...

Data trans_data;

SET fy.13transdata;

WHERE substr (X, **1**,**4**) = '4';

run;

Im confused as to how I should structure my where statement. Can someone help?

Thx!

EP

Accepted Solutions

Solution

12-17-2013
10:31 AM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

Posted in reply to ramfan55

12-17-2013 10:31 AM

WHERE substr (X, **1**,**4**) = '4';

What would you expect the 4 in the substr function to do?

I think it should be 1,

WHERE substr (X, **1**,**1**) = '4';

Try reading the documentation on Substr again:

All Replies

Solution

12-17-2013
10:31 AM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

Posted in reply to ramfan55

12-17-2013 10:31 AM

WHERE substr (X, **1**,**4**) = '4';

What would you expect the 4 in the substr function to do?

I think it should be 1,

WHERE substr (X, **1**,**1**) = '4';

Try reading the documentation on Substr again:

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

Posted in reply to Reeza

12-17-2013 10:35 AM

Thanks I saw that link I thought the 4 represents how many characters? But I believe it means the number of characters Sas should read. Thx agn!