topic Re: HOW TO USE SECOND ARGUMENT IN THIS PROGRAM in SAS Programming

HOW TO USE SECOND ARGUMENT IN THIS PROGRAM

thanikondharish — Thu, 23 Aug 2018 10:12:11 GMT

DATA S ;
NAME='ROITNCV42365672-908$#&^*(#$' ;
NEW=COMPRESS(NAME,'24' ,'KD') ;
RUN;

I WANT TO KEEP ONLY DIGITS AND WITH IN DIGITS I DON'T NEED 2,4 NUMBERS .

IS ABOVE PROGRAM CORRECT ?

USE OF SECOND ARGUMENT?

Re: HOW TO USE SECOND ARGUMENT IN THIS PROGRAM

RW9 — Thu, 23 Aug 2018 10:17:14 GMT

TRY PRESSING THE CAPS LOCK BUTTON, ITS OFFENSIVE TO BE SHOUTED AT!!

You need two compress statements, inner to keep digits, outer to remove 2 and 4:

data s;
  name='ROITNCV42365672-908$#&^*(#$';
  new=compress(compress(name," ","kd"),'24');
run;

Re: HOW TO USE SECOND ARGUMENT IN THIS PROGRAM

thanikondharish — Thu, 23 Aug 2018 10:21:22 GMT

USE OF " " AFTER THE VARIABLE NAME

Re: HOW TO USE SECOND ARGUMENT IN THIS PROGRAM

VDD — Thu, 23 Aug 2018 12:12:37 GMT

You do not read others replies completely. STOP using all UPPERCASE. YOU are shouting at us.

Re: HOW TO USE SECOND ARGUMENT IN THIS PROGRAM

Reeza — Thu, 23 Aug 2018 15:21:59 GMT

@thanikondharish you're probably aware but this is a community forum, everyone answering your questions is likely exactly like you either studying at school or working a full time job. There are some SAS employee's on here, but they're identified as such as well. Please take the time to properly format your questions and to mark them solved when someone has taken the time to answer it.

@VDD This is an entirely optional activity, so my solution is to not engage/respond further 😉

Re: HOW TO USE SECOND ARGUMENT IN THIS PROGRAM

Tom — Thu, 23 Aug 2018 15:29:17 GMT

Probably easier to just list the digits you want to keep.

compress(xxx,'01356789','k')