topic Re: how to make sas read 3 last digit in a csv column in SAS Programming

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

Meeru — Thu, 03 Mar 2022 07:11:04 GMT

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

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

Kurt_Bremser — Thu, 03 Mar 2022 07:19:35 GMT

Use

substr(string,length(string)-2)

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

japelin — Thu, 03 Mar 2022 07:24:16 GMT

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;

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

Astounding — Thu, 03 Mar 2022 09:07:58 GMT

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.

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

Meeru — Fri, 18 Mar 2022 06:57:38 GMT

Thank you everyone!