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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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: