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!!
Please show the code you are using.
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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: