topic Re: how to keep multiple variables? in New SAS User

how to keep multiple variables?

srikanthyadav44 — Thu, 04 Jul 2019 09:15:13 GMT

Hi all,

my data set has N variables with are repeated for K number of times.

Out of them, i have to select only one type of variable which is repeated for K number of times. and also the company name.( please note that first array of variables are not suffixed with serial number, only from second array, the serial number is suffixed like varA1, varB1 etc., )

the format of my data file is as follows

company

varA

varB

………..

varN

varA1

varB1

………..

varN1

varAK

varBK

………..

varNK

thanks in advance

Re: how to keep multiple variables?

KachiM — Thu, 04 Jul 2019 09:25:29 GMT

company	varA	varB	………..	varN	varA1	varB1	………..	varN1	varAK	varBK	………..	varNK

Do you want this?

company	varA1	varB1	………..	varN1	varAK	varBK	………..	varNK

Re: how to keep multiple variables?

srikanthyadav44 — Thu, 04 Jul 2019 09:31:12 GMT

No. i want the like as follows

company varA varA1 varA2 varA3.................................. varAk var

I want only variable array of variable A from A to AK

thanks in advance

Re: how to keep multiple variables?

srikanthyadav44 — Thu, 04 Jul 2019 10:05:41 GMT

and company name also

Re: how to keep multiple variables?

andreas_lds — Thu, 04 Jul 2019 11:02:04 GMT

Please describe the problem you have and what you want to achieve.

The array statement is simple:

array arrayName List_The_Variables_Separated_By_Blank;

Note, that all variables in an array need to be of same type.

Re: how to keep multiple variables?

KachiM — Thu, 04 Jul 2019 12:00:23 GMT

Here is an illustration. Extend it to your needs.

data _null_;
   set have;
   array v varA -- varB3;
   do i = 1 to dim(v);
      if substr(vname(v[i]),4,1) = 'A' then put v[i]=;
   end;
run;

This writes to the log.

Another way is to catch the values of the selected values of variables into a space separated List as:

data want;
   set have;
   array v varA -- varB3;
   length str $32767;
   call missing(str);
   do i = 1 to dim(v);
      if substr(vname(v[i]),4,1) = 'A' then str = catx(' ',str, v[i]);
   end;
keep company str;  
run;

Re: how to keep multiple variables?

Astounding — Thu, 04 Jul 2019 14:10:51 GMT

How about an easy way?

data want;
   set have;
   keep company varA: ;
run;

Re: how to keep multiple variables?

KachiM — Thu, 04 Jul 2019 14:25:15 GMT

I missed to show the 'HAVE' data set that was used in my previous posting. It is used again here.

An improved solution can be obtained by following the steps:

[1] Collect the variable names that match the pattern (varA) into a List.

[2] The List be sent as a macro variable in [1] itself.

[3] Declare an array with elements of &List.

[4] Automatically the selected variables are filled with their corresponding values.

Here is the program with input data set and the Output:

data have;
input company  varA varB varA1 varB1 varA2 varB2 varA3 varB3;
datalines;
10 1 2 3 11 21 12 22 31 32
20 2 3 4 22 23 24 25 26 27
;
run;

data _null_;
   length List $ 32767;
   set have;
   array v varA -- varB3;
   if _N_ = 1 then do;
      do i = 1 to dim(v);
         if substr(vname(v[i]),4,1) = 'A' then List = catx(' ',List, vname(v[i]));
      end;
      call symputx('List', List);
   end;
stop;   
run;

%put &List;



data want;
   set have;
   array vn &List;
keep company &List;   
run;


Obs company  varA varA1 varA2 varA3
1      10      1     3    21    22
2      20      2     4    23    25

Re: how to keep multiple variables?

Reeza — Thu, 04 Jul 2019 15:07:17 GMT

If the variables are in order, list the CompanyID, the first variable in the series and last variable in the series.

data want;
set have;

keep companyID varAK -- VarNK;

run;

https://blogs.sas.com/content/iml/2018/05/29/6-easy-ways-to-specify-a-list-of-variables-in-sas.html

See this link for more options on how to list variables in an easier way.

@srikanthyadav44 wrote:

Hi all,

my data set has N variables with are repeated for K number of times.

Out of them, i have to select only one type of variable which is repeated for K number of times. and also the company name.( please note that first array of variables are not suffixed with serial number, only from second array, the serial number is suffixed like varA1, varB1 etc., )

the format of my data file is as follows

company varA varB ……….. varN varA1 varB1 ……….. varN1 varAK varBK ……….. varNK

1

2

3

4

.

.

.

M

thanks in advance