BookmarkSubscribeRSS Feed
sg_kr
Obsidian | Level 7

Hi ,

 

i have a column agt_cde as varchar of length 200 in NZ.

when i imported to sas by set statement, it is having same length ,informat & format.

 

when i try to filter the agt_cde by where condition, its showing 0 records.

 

so,i changed that to length to $7. using input,even though its not filtering.

 

can you please help me out with the reason for this.

 

thanks in advance!!

2 REPLIES 2
andreas_lds
Jade | Level 19

Please show the code you are using.

LinusH
Tourmaline | Level 20

What is "NZ", New Zealand...

If you reading through an SAS/ACCESS libname, add

options msglevel=i sastrace=',,,d' sastraceloc=saslog nostsuffix;

to your program.

try left(trimn()) as well.

Show the log with these options enabled.

Data never sleeps

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 931 views
  • 0 likes
  • 3 in conversation