topic How to extract a value of variable and create another variable in SAS Programming

How to extract a value of variable and create another variable

knveraraju91 — Thu, 30 Jan 2020 17:41:23 GMT

Dear,

I need help in which function i can in this situation.

my data has values SS-S1 SSS >= 1 and SS-S1 SSS < 1.

I need to create another variable with values SSS >= 1 and SSS < 1.

input data;

SS-S1 SSS >= 1

SS-S2 SSS < 1

output needed

SSS >= 1

SSS < 1

Please suggest. Thank you

Re: How to extract a value of variable and create another variable

PaigeMiller — Thu, 30 Jan 2020 18:17:17 GMT

As always, when such small and limited examples are presented, they are hard to generalize.

Is the rule that we are supposed to follow that SSS >=1 and SSS < 1 always begin in the 7th column? Or can the SSS >= 1 and SSS < 1 be anywhere in the text string? Do spaces matter — is it always SSS >= 1 or can it be SSS>=1 with no spaces? Does SS-SS1 and SS-SS2 matter at all?

What is the rule that you want programmed here?

Re: How to extract a value of variable and create another variable

knveraraju91 — Thu, 30 Jan 2020 19:07:03 GMT

Thank you for reply. I need second part of the value including spaces. I just need to remove first part of the value ' SS-S1'. Thank you

Vikram.V

Re: How to extract a value of variable and create another variable

PaigeMiller — Thu, 30 Jan 2020 19:19:19 GMT

What about when it is SS-S2? Are there other possible values?

You didn't really explain the rule you want programmed ... do we always start in column 7? Or can these codes that you are looking for be anywhere?

Re: How to extract a value of variable and create another variable

knveraraju91 — Thu, 30 Jan 2020 19:36:52 GMT

Thank you very much

There are only two values for the variable. I need value from column 7. If i use want=substr(a,7); i am getting the output i need. Is there other option. Thank you

output needed;

SSS >= 1

SSS < 1

data one;
input a $1-14 ;
datalines;
SS-S1 SSS >= 1 
SS-S1 SSS < 1  
;

Re: How to extract a value of variable and create another variable

PaigeMiller — Thu, 30 Jan 2020 19:55:13 GMT

Yes, there are probably other ways to extract a string beginning in column 7, but I would stick with the SUBSTR() function.

Re: How to extract a value of variable and create another variable

ballardw — Fri, 31 Jan 2020 22:43:24 GMT

@knveraraju91 wrote:

Hi

Thank you very much

There are only two values for the variable. I need value from column 7. If i use want=substr(a,7); i am getting the output i need. Is there other option. Thank you

output needed;

SSS >= 1

SSS < 1
data one;
input a $1-14 ;
datalines;
SS-S1 SSS >= 1 
SS-S1 SSS < 1  
;

I agree with @PaigeMiller that if substr is working for you then that may be best.

This depends on how you are getting the data into SAS in the first place but you may be able to READ that value with an input statement. Actual content and structure of your source may allow use of @"value" column input:

data one;
input @"SS-S1 " a $8. ;
datalines;
SS-S1 SSS >= 1 
SS-S1 SSS < 1  
;

On the input statement an option like @"SS-S1 " tells SAS to advance the read point to the column after the end of the value in quotes and then read the variable.

Concerns: The entire structure of the data and options use. If you are using list input then you need something that reads the spaces if the delimiter is not something other than that a space if the data is delimited. The approach I show will include any character immediately after the 1 in the "SSS < 1" case because we are forcing a read of 8 characters.

Another approach could be to use a custom Informat that would read SS-S1 SSS >= 1 into a value of "SSS >= 1". But again we have to either know the file contents when read or use a more complex method than substring:

proc format library=work;
invalue $sss
"SS-S1 SSS >= 1" = "SSS >= 1"
"SS-S1 SSS < 1"  = "SSS < 1"
;

data one;
input a $1-14 ;
datalines;
SS-S1 SSS >= 1 
SS-S1 SSS < 1  
;

data two;
   set one;
   newvar = input(a,$sss.);
run;

This approach might be preferred over SUBSTR if you have many values that need many different places to parse from.

Or just create a format and use the format without actually changing the value. This of course depends on what you are doing with the variable. If it is used for grouping in reports, analysis or graphs that should suffice.

proc format library=work;
value $sss
"SS-S1 SSS >= 1" = "SSS >= 1"
"SS-S1 SSS < 1"  = "SSS < 1"
;
run;

proc print data=one;
   format a $sss.;
run;

Re: How to extract a value of variable and create another variable

PaigeMiller — Sun, 02 Feb 2020 19:11:15 GMT

@ballardw wrote:
@knveraraju91 wrote:

Hi

Thank you very much

There are only two values for the variable. I need value from column 7. If i use want=substr(a,7); i am getting the output i need. Is there other option. Thank you

output needed;

SSS >= 1

SSS < 1
data one;
input a $1-14 ;
datalines;
SS-S1 SSS >= 1 
SS-S1 SSS < 1  
;
I agree with @PaigeMiller that if substr is working for you then that may be best.

This depends on how you are getting the data into SAS in the first place but you may be able to READ that value with an input statement. Actual content and structure of your source may allow use of @"value" column input:
data one;
input @"SS-S1 " a $8. ;
datalines;
SS-S1 SSS >= 1 
SS-S1 SSS < 1  
;
On the input statement an option like @"SS-S1 " tells SAS to advance the read point to the column after the end of the value in quotes and then read the variable.

Problem: the original data set contained SS-S1 and SS-S2