permit is a text field with length 40.
facility is a text field with length 60.
facility_hmbp_3 = scan(facility,3,'') with length 40.
If facility_hmbp_3 is equal to Lewis then the variable find_hmbp should be 6 for permit="OCEH Lewis Sub" where find_hmbp=find(permit,facility_hmbp_3,'i').
However, I'm currently getting 0.
If I change find_hmbp=find(permit,"Lewis",'i') then I do get 6.
Why am I not getting 6 with find_hmbp=find(permit,facility_hmbp_3,'i')?
Thank you.
Likely the trailing spaces that are implicitly present in your strings play a role. You can omit them from the comparison by adding the t modeifier to the third parameter.
find_hmbp=find(permit,facility_hmbp_3,'it')
Hope this helps,
- Jan.
Likely the trailing spaces that are implicitly present in your strings play a role. You can omit them from the comparison by adding the t modeifier to the third parameter.
find_hmbp=find(permit,facility_hmbp_3,'it')
Hope this helps,
- Jan.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.