topic Re: Do loop / iterative do statement in New SAS User

Do loop / iterative do statement

veebee1 — Mon, 01 Oct 2018 13:17:52 GMT

data _null_;
set ave.emp;
NEWSAL=sal;
put ' ';
put 'CURRENT SALARY FOR ' ename ' IS ' sal;
do lily = 1 to 15;
newsal=newsal+newsal*.20;
put ' AND HIS EXPECTED SALARY FOR THE ' lily ' YEAR IS ' newsal;
end;
run;

/*TASK - 1*/

/*hike the sal for all with 20% but only on alternate years till crossing 10 years*/

/*TASK - 2*/

/*hike the sal for dept 10 with 10%, for 20 with 20% and for the rest with 30% for 3 years*/

/*TASK - 3*/

/*debug the above code and check the results*/

Re: Do loop / iterative do statement

Kurt_Bremser — Mon, 01 Oct 2018 13:24:44 GMT

@veebee1 wrote:

data _null_;
set ave.emp;
NEWSAL=sal;
put ' ';
put 'CURRENT SALARY FOR ' ename ' IS ' sal;
do lily = 1 to 15;
newsal=newsal+newsal*.20;
put ' AND HIS EXPECTED SALARY FOR THE ' lily ' YEAR IS ' newsal;
end;
run;

/*TASK - 1*/

/*hike the sal for all with 20% but only on alternate years till crossing 10 years*/

/*TASK - 2*/

/*hike the sal for dept 10 with 10%, for 20 with 20% and for the rest with 30% for 3 years*/

/*TASK - 3*/

/*debug the above code and check the results*/

And what is your question?

Re: Do loop / iterative do statement

veebee1 — Mon, 01 Oct 2018 13:31:07 GMT

There are 3 tasks listed to create from the data set.

Re: Do loop / iterative do statement

RW9 — Mon, 01 Oct 2018 13:42:01 GMT

Yes, but these are Your tasks for some sort of course. What is your question bearing in mind we are not here to do your course for you.

Re: Do loop / iterative do statement

Astounding — Mon, 01 Oct 2018 13:47:10 GMT

Not too many posters will just do your homework for you. Here is a tip to get you started.

do lily = 1 to 15;
newsal=newsal+newsal*.20;
put ' AND HIS EXPECTED SALARY FOR THE ' lily ' YEAR IS ' newsal;
end;

Since you are only expected to go through 10 years, and only expected to report every other year, a couple of changes would be in order. Depending on whether question 1 wants you to report years 2, 4, 6, 8, 10 (as opposed to years 1, 3, 5, 7, 9):

do lily = 2 to 10 by 2;
newsal=newsal * 1.2 * 1.2;
put ' AND HIS EXPECTED SALARY FOR THE ' lily ' YEAR IS ' newsal;
end;

Re: Do loop / iterative do statement

veebee1 — Mon, 01 Oct 2018 13:56:55 GMT

how do YOU know this is for some kind of course, did I ask YOU to do it for me?

Re: Do loop / iterative do statement

RW9 — Mon, 01 Oct 2018 13:59:33 GMT

Yes, you posted a question on the forum with the idea to get a response.

Re: Do loop / iterative do statement

veebee1 — Mon, 01 Oct 2018 14:01:56 GMT

"with the idea to get a response" - only to get an idea to complete the task because I am either stuck or not sure of my answer. If you have no contribution or can't solve it, please do not respond. Thank You.

Re: Do loop / iterative do statement

veebee1 — Mon, 01 Oct 2018 14:03:42 GMT

can you help me with the procedure to debug, or it there a code to debug?

Re: Do loop / iterative do statement

VDD — Mon, 01 Oct 2018 14:05:00 GMT

data have / debug;

… stuff you want to do...

run;

Re: Do loop / iterative do statement

Kurt_Bremser — Mon, 01 Oct 2018 14:06:49 GMT

@veebee1 wrote:

can you help me with the procedure to debug, or it there a code to debug?

Run it, read the log, and inspect the resulting dataset (if the code doesn't conk out with ERROR(s)).

If you want us to test your code, we need the data you run it on. Post example data (ave.emp) in a data step with datalines, so it is easy for us to recreate it.

Re: Do loop / iterative do statement

veebee1 — Mon, 01 Oct 2018 14:09:20 GMT

data _null_;
set ave.emp;
NEWSAL=sal;
put ' ';
put 'CURRENT SALARY FOR ' ename ' IS ' sal;
do lily = 2 to 10 by 2;
newsal=newsal * 1.2 * 1.2;
put ' AND HIS EXPECTED SALARY FOR THE ' lily ' YEAR IS ' newsal;
end;
run;

data _null_;
set ave.emp;
NEWSAL=sal;
put ' ';
put 'CURRENT SALARY FOR ' dept=10 ' IS ' sal;
newsal=newsal+newsal*.10;
put 'CURRENT SALARY FOR ' dept=20 ' IS ' sal;
newsal=newsal+newsal*.20;
put 'CURRENT SALARY FOR ' dept=30 ' IS ' sal;
newsal=newsal+newsal*.30;
do lily = 1 to 3;
put ' AND HIS EXPECTED SALARY FOR THE ' lily ' YEAR IS ' newsal;
end;
run;

Re: Do loop / iterative do statement

veebee1 — Mon, 01 Oct 2018 14:10:26 GMT

For Task 2 is this correct?

Re: Do loop / iterative do statement

VDD — Mon, 01 Oct 2018 14:12:28 GMT

did you post data for testing and debugging?

Did you test your code yourself?

I and others would test for you if you included data.

Re: Do loop / iterative do statement

Kurt_Bremser — Mon, 01 Oct 2018 14:12:40 GMT

@veebee1 wrote:

data _null_;
set ave.emp;
NEWSAL=sal;
put ' ';
put 'CURRENT SALARY FOR ' ename ' IS ' sal;
do lily = 2 to 10 by 2;
newsal=newsal * 1.2 * 1.2;
put ' AND HIS EXPECTED SALARY FOR THE ' lily ' YEAR IS ' newsal;
end;
run;

data _null_;
set ave.emp;
NEWSAL=sal;
put ' ';
put 'CURRENT SALARY FOR ' dept=10 ' IS ' sal;
newsal=newsal+newsal*.10;
put 'CURRENT SALARY FOR ' dept=20 ' IS ' sal;
newsal=newsal+newsal*.20;
put 'CURRENT SALARY FOR ' dept=30 ' IS ' sal;
newsal=newsal+newsal*.30;
do lily = 1 to 3;
put ' AND HIS EXPECTED SALARY FOR THE ' lily ' YEAR IS ' newsal;
end;
run;

Nice. You're using ave.emp. Where's the example data for that?

Without knowing what is in that dataset, there's no way to verify your code (reliably).

Re: Do loop / iterative do statement

veebee1 — Mon, 01 Oct 2018 14:12:43 GMT

Thank you.

Re: Do loop / iterative do statement

veebee1 — Mon, 01 Oct 2018 14:16:29 GMT

libname _all_ clear;

libname ave 'c:\sample';

data e;
set ave.emp;
NEWSAL=sal;
do lily = 1 to 5;
newsal=newsal+newsal*.20;
end;
run;

data _null_;
set ave.emp;
NEWSAL=sal;
put ' ';
put 'CURRENT SALARY FOR ' ename ' IS ' sal;
do lily = 1 to 5;
newsal=newsal+newsal*.20;
put ' AND HIS EXPECTED SALARY FOR THE ' lily ' YEAR IS ' newsal;
end;
run;

Re: Do loop / iterative do statement

Astounding — Mon, 01 Oct 2018 14:23:12 GMT

Tip #2:

You will need to learn how to determine which data is for department 10, which is for department 20, etc. That depends on what exactly is in your data, so we can only guess until we see some data.

Re: Do loop / iterative do statement

veebee1 — Mon, 01 Oct 2018 14:30:35 GMT

Re: Do loop / iterative do statement

Astounding — Mon, 01 Oct 2018 14:38:38 GMT

OK, so you have DEPTNO that tells you what the department number is. Do you know how to use it in an IF THEN statement to process only the department 10 observations?