BookmarkSubscribeRSS Feed
sam369
Obsidian | Level 7

Hi All,

 

I have longitudnal data and grp variable and fl variable, values of grp as 1 2 3 4 5 6... and values for fl as 1 2 3... need to create variable net.

Is there any dynamic way to get the grp and fl values

 

if grp=1 then do; if fl=1 then net=1; if fl=2 then net=2;end;
if grp=2 then do; if fl=1 then net=3; if fl=2 then net=4;end;
if grp=3 then do; if fl=1 then net=5; if fl=2 then net=6;end;
if grp=4 then do; if fl=1 then net=7; if fl=2 then net=8;end;

 

 

my try :

%let maxgrp=4;%let fl=2;

proc sql;

 select *,

%do i=1 %to &maxgrp;  j=1 %to &fl;

     case when grp=&i and fl eq &j then &i*&j;

    end as trt

from ids;

quit;

 

 

Thanks

Sam

3 REPLIES 3
Reeza
Super User
You can simplify it to a formula:

net=(2*(grp-1))+fl;
sam369
Obsidian | Level 7

Thank you Reeza!!!

can we adopt this formula under the sql? if i used in data step i got the output , but if i want to adopt for sql, getting warning on log,

"net variable already exit in XXXX dataset"

 

 

 

Thanks

Sam

Reeza
Super User
In SQL it would work as well but it would be
(2*(grp-1))+fl as net

If the NET variable already exists in the dataset, as your warning indicates that something to be cautious of, do you really want to overwrite the other variable called net. In a data step it would overwrite it without any warning.

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 983 views
  • 2 likes
  • 2 in conversation