how to make sas read 3 last digit in a csv column

[Meeru]

Hi All! I have a CSV table and one of them contains 4 digit numbers. However, in that column, I just need the 3 last digits for analysis. How do I make SAS read-only the 3 last digits?

Thank you in advance for your answer

[Kurt_Bremser]

Use

substr(string,length(string)-2)

[japelin]

If it is sure of 4 digits, I think you can use the substr function to get the second and subsequent characters.

filename txt temp;
data _null_;
  file txt;
  put '1234';
  put '5678';
  put '9012';
run;

data want;
  infile txt dsd;
  length num 8 lastdgt $3;
  input num;
  lastdgt=substr(strip(put(num,best.)),2);
run;

[Astounding]

You can't. However you can read all 4 digits and then calculate the contents of the last 3. Assuming you are dealing with integers only, and assuming you read the value into a numeric variable, you could use

last3 = mod(var, 1000);

If those assumptions are wrong, the solution would change.

[Meeru]

Thank you everyone!