topic Re: Do Loop for data manulplation in SAS Programming

Do Loop for data manulplation

BrahmanandaRao — Wed, 07 Jul 2021 10:05:35 GMT

Here I am trying to data manipulate using do loop

data dsn;
 do Sex= 1 to nobs ;
 length sex  $ 12 ;
 set sashelp.class nobs=nobs;
 if Sex='F' then Sex='Female';
 output;
 end;
 proc print;
 run;

Re: Do Loop for data manulplation

Astounding — Wed, 07 Jul 2021 10:51:13 GMT

You first need to decide whether sex should be numeric or character. Even in these permissive times, it can't be both.

Re: Do Loop for data manulplation

Tom — Wed, 07 Jul 2021 12:26:22 GMT

I don't understand what the purpose of the DO loop is in that program. If you want to recode the value used for females just do:

data WANT;
  length sex  $12 ;
  set sashelp.class ;
  if Sex='F' then Sex='Female';
run;

Re: Do Loop for data manulplation

Kurt_Bremser — Wed, 07 Jul 2021 12:30:28 GMT

Why do you think you need a DO loop?

Re: Do Loop for data manulplation

BrahmanandaRao — Wed, 07 Jul 2021 13:45:08 GMT

I Know if condition so that I just trying do loops I took small dataset suppose if huge data then

Re: Do Loop for data manulplation

Tom — Wed, 07 Jul 2021 14:03:12 GMT

@BrahmanandaRao wrote:
I Know if condition so that I just trying do loops I took small dataset suppose if huge data then

The number of observations does not impact the code.

Re: Do Loop for data manulplation

Cynthia_sas — Wed, 07 Jul 2021 14:07:48 GMT

Hi:

If all you want to do is change the display of the variable for PROC PRINT, you can use a user-defined format for that. See #1 below. If you want to create a new character variable, then you can also do that with a user-defined format and the PUT function, no DO Loop or IF statement needed. See #2 example below.

Cynthia