topic Re: new variable-data dependent in SAS Programming

new variable-data dependent

Batta — Mon, 17 Jun 2024 20:18:51 GMT

Hi SAS expert,

My apology for not being able to better define the Subject. I’ll appreciate you help regarding the following:

I have a variable named InstanceName, that has the following values
Follow-up 01,
Follow-up 02,
Follow-up 03,
….
so I need to get another variable that will have (numerical) value 1 if InstanceName=Follow-01, value 2 if InstanceName=Follow-up 02, 3 if InastanceName=Follow-up 03 etc, and this is easy to do using proc sql, and conditional statement “case when … then … else…end” or SAS data statement...
The problem is that Folllow-up xx number is changing, and within different data sets might be up 4, while within other data sets might be 15 and up.
So is it possible to make this “case when… then… else end” statement more data dependent, so I don’t always have to check how may Follow-up xx are there for each set of data, and that SAS runs this up the last Follow-up xx available?

Here how the code, in general, look like:

proc sql;
create table Table_1 as
select Var1, Var2, case
when InstanceName="Follow-up 01" then 1
when InstanceName="Follow-up 02" then 2
when InstanceName="Follow-up 03" then 3
….
else ...
end as FUP_NUM
from Data_1;
quit;

Thank you very much for your time,
Batta

Re: new variable-data dependent

ballardw — Mon, 17 Jun 2024 20:29:44 GMT

No Case/when needed:

input(scan(Instance_name,2,' '),f2.) as Fup_num

the Scan gets the part after the space and then Input reads it as a number.

@Batta wrote:

Hi SAS expert,

My apology for not being able to better define the Subject. I’ll appreciate you help regarding the following:

I have a variable named InstanceName, that has the following values
Follow-up 01,
Follow-up 02,
Follow-up 03,
….
so I need to get another variable that will have (numerical) value 1 if InstanceName=Follow-01, value 2 if InstanceName=Follow-up 02, 3 if InastanceName=Follow-up 03 etc, and this is easy to do using proc sql, and conditional statement “case when … then … else…end” or SAS data statement...
The problem is that Folllow-up xx number is changing, and within different data sets might be up 4, while within other data sets might be 15 and up.
So is it possible to make this “case when… then… else end” statement more data dependent, so I don’t always have to check how may Follow-up xx are there for each set of data, and that SAS runs this up the last Follow-up xx available?

Here how the code, in general, look like:

proc sql;
create table Table_1 as
select Var1, Var2, case
when InstanceName="Follow-up 01" then 1
when InstanceName="Follow-up 02" then 2
when InstanceName="Follow-up 03" then 3
….
else ...
end as FUP_NUM
from Data_1;
quit;

Thank you very much for your time,
Batta

Re: new variable-data dependent

Batta — Fri, 26 Jul 2024 17:27:00 GMT

Great, thanks!

My apology for late response, a lot of other things came up to be done in the meantime 🙂

Kind regards,

Batta