topic Re: SAS Base Query in SAS Programming

SAS Base Query

scb — Fri, 03 Mar 2017 01:47:36 GMT

The below codes is working fine. Just want to know if there is any way to have to same result without RENAME and DROP variables? Thanks.

DATA A;
INFILE CARDS;
INPUT ID ;
CARDS;
3453
123162
124171
1241761
;
RUN;

DATA A(RENAME=(ID1=ID));
SET A;
ID1 = PUT(ID,z7.);
DROP ID;
RUN;

Re: SAS Base Query

Shmuel — Fri, 03 Mar 2017 01:52:41 GMT

In your output ID1 is numeric while ID is char type.

Your code is the easyiest way to bo done;

Re: SAS Base Query

PGStats — Fri, 03 Mar 2017 04:00:16 GMT

Do it in a single step:

DATA A;
INFILE CARDS;
INPUT ID :$7. ;
id = translate(right(id),"0"," ");
CARDS;
3453
123162
124171
1241761
;

Re: SAS Base Query

Shmuel — Fri, 03 Mar 2017 09:05:57 GMT

@PGStats, you probably know that input a CHAR type is left aligned.

Then

DATA A;
INFILE CARDS;
INPUT ID :$7. ;
id = translate(right(id),"0"," ");
CARDS;
3453
; run;

will create ID='3453000' while the equivalent to the number 3453 is '0003453';

In this case, it can be done by:

DATA A;
INFILE CARDS;
INPUT ID :$7. ;
id = put(input(id,best7.),z7.);
CARDS;
3453
; run;

Re: SAS Base Query

RW9 — Fri, 03 Mar 2017 09:39:04 GMT

Sorry @Shmuel that may not be 100% correct. It depends on what the OP user is expecting from the variable. If they really do want a text field then I have no problem with it. If however they just want that data as z7. then the simplest method is to apply the format to the already existing numeric data:

data a;
  infile cards;
  input id;
  format id z7.;   /* <-- this is the only thing needed to display as z7. */
cards;
3453
123162
124171
1241761
;
run;

OP: Please do not code all in upper case, it really makes code so much harder to look at.

Re: SAS Base Query

Shmuel — Fri, 03 Mar 2017 10:10:00 GMT

@RW9, you are right if the target was just displaying the number with leading zeroes.

The original query included code:

DATA A(RENAME=(ID1=ID));
SET A;
ID1 = PUT(ID,z7.);
DROP ID;
RUN;

Which I understand that the target is changing type of variable in a dataset.

Re: SAS Base Query

PGStats — Fri, 03 Mar 2017 15:42:46 GMT

Hi @Shmuel, you are right in saying that input reads left aligned, which is why I use the right function to make it right aligned before replacing the spaces with leading zeros.

Re: SAS Base Query

Shmuel — Fri, 03 Mar 2017 21:17:28 GMT

Hi @PGStats, you are right, I skiped the right in your code.

Any way, our debate is a good lesson to SAS starting users.