Styjun

Why did Europeans not widely domesticate foxes?

What is a 'Key' in computer science?

How would it unbalance gameplay to rule that Weapon Master allows for picking a fighting style?

What is the ongoing value of the Kanban board to the developers as opposed to management

Writing a T-SQL stored procedure to receive 4 numbers and insert them into a table

My admission is revoked after accepting the admission offer

Co-worker works way more than he should

What is the evidence that custom checks in Northern Ireland are going to result in violence?

Is it OK if I do not take the receipt in Germany?

Is there a possibility to generate a list dynamically in Latex?

What is /etc/mtab in Linux?

Why did Israel vote against lifting the American embargo on Cuba?

Why aren't road bicycle wheels tiny?

How did Elite on the NES work?

Processing ADC conversion result: DMA vs Processor Registers

When does Bran Stark remember Jamie pushing him?

What is the numbering system used for the DSN dishes?

Raising a bilingual kid. When should we introduce the majority language?

What is ls Largest Number Formed by only moving two sticks in 508?

Will temporary Dex penalties prevent you from getting the benefits of the "Two Weapon Fighting" feat if your Dex score falls below the prerequisite?

Why does the Cisco show run command not show the full version, while the show version command does?

Where/What are Arya's scars from?

Stretch a Tikz tree

RIP Packet Format

SAS insert to ARRAY only (example) first row from dataset

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

0

I have bit a problem. I need insert to Array only (example) first array, best field by field.
How Can I do it? I will be grateful if also you point how insert column by column (I will be able to load chosen columns in the future).

data have;
infile DATALINES dsd missover;
input varr1 varr2 varr3;
CARDS;
1, 2, 3
2, 3, 4 
5, 4
4, 3
9, 4, 1
6,
;run;

data want;
 set have;
 array L[3] _temporary_ ;

if _n_ = 1 then 
 do;
 do i = 1 to 3;
 %LET j = i;
 L[i] = varr&i; /*in this place I have problem*/
 put L[i];
 end;
 end;
run;

arrays sas

share|improve this question

asked Mar 22 at 14:49

DarkousPlDarkousPl

548

add a comment | 

0

I have bit a problem. I need insert to Array only (example) first array, best field by field.
How Can I do it? I will be grateful if also you point how insert column by column (I will be able to load chosen columns in the future).

data have;
infile DATALINES dsd missover;
input varr1 varr2 varr3;
CARDS;
1, 2, 3
2, 3, 4 
5, 4
4, 3
9, 4, 1
6,
;run;

data want;
 set have;
 array L[3] _temporary_ ;

if _n_ = 1 then 
 do;
 do i = 1 to 3;
 %LET j = i;
 L[i] = varr&i; /*in this place I have problem*/
 put L[i];
 end;
 end;
run;

arrays sas

share|improve this question

asked Mar 22 at 14:49

DarkousPlDarkousPl

548

add a comment | 

I have bit a problem. I need insert to Array only (example) first array, best field by field.
How Can I do it? I will be grateful if also you point how insert column by column (I will be able to load chosen columns in the future).

data have;
infile DATALINES dsd missover;
input varr1 varr2 varr3;
CARDS;
1, 2, 3
2, 3, 4 
5, 4
4, 3
9, 4, 1
6,
;run;

data want;
 set have;
 array L[3] _temporary_ ;

if _n_ = 1 then 
 do;
 do i = 1 to 3;
 %LET j = i;
 L[i] = varr&i; /*in this place I have problem*/
 put L[i];
 end;
 end;
run;

arrays sas

share|improve this question

asked Mar 22 at 14:49

DarkousPlDarkousPl

548

data have;
infile DATALINES dsd missover;
input varr1 varr2 varr3;
CARDS;
1, 2, 3
2, 3, 4 
5, 4
4, 3
9, 4, 1
6,
;run;

data want;
 set have;
 array L[3] _temporary_ ;

if _n_ = 1 then 
 do;
 do i = 1 to 3;
 %LET j = i;
 L[i] = varr&i; /*in this place I have problem*/
 put L[i];
 end;
 end;
run;

share|improve this question

asked Mar 22 at 14:49

DarkousPlDarkousPl

548

share|improve this question

asked Mar 22 at 14:49

DarkousPlDarkousPl

548

asked Mar 22 at 14:49

DarkousPlDarkousPl

548

asked Mar 22 at 14:49

DarkousPlDarkousPl

548

1 Answer
1

active

oldest

votes

1

You don't need macro, and not sure why you need temporary array L.

The array statement can be used to organize variables so they can be accessed in an array manner. Loop over the variable array in order to copy the values into the temporary array.

The elements of a temporary array are not available for output, and not part of normal implicit program data vector (PDV) behaviors that would reset variables to missing.

data want;
 set have;
 array V varr1-varr3;
 array L[3] _temporary_;

 * save first rows values in temporary array for use in other rows;
 if _n_ = 1 then 
 do index = 1 to dim(V);
 L[index] = V[index];
 end;

 * … for example … ;

 array delta_from_1st [3]; * array statement implicitly creates three new variables that become part of PDV and get output;
 do index = 1 to dim(V);
 delta_from_1st[index] = V[index] - L[index];
 end; 
run;

share|improve this answer

answered Mar 22 at 17:17

RichardRichard

10.3k21329

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Works great! Thank you, and I have one additionaly question - how put column name in fragment: delta_from_1st[index] = V[index] - L[index] I tried use vname but doesn't work. I need example delta_[column name that calculated] Thanks!
  
  – DarkousPl
  Mar 25 at 11:20
  
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  The data step can not dynamically create the variable names of it's output. You can define the delta array as a grouping a data step variables (that would be added to the PDV). array delta delta_var1-deltavar3; The array construct in the example creates new variables based on the array name. SAS can not process accessors of the form array[<char-value>], you would have to use HASH object for that. Finally, sometimes it is far easier to use a reporting procedure to get a look at data in a special way, instead of manually reorganizing the data into a new layout
  
  – Richard
  Mar 25 at 13:25
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Richard, thank for explanation. I see more and more often that SAS has a lot limitations.
  
  – DarkousPl
  Mar 25 at 16:52
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55302251%2fsas-insert-to-array-only-example-first-row-from-dataset%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

1

You don't need macro, and not sure why you need temporary array L.

The array statement can be used to organize variables so they can be accessed in an array manner. Loop over the variable array in order to copy the values into the temporary array.

The elements of a temporary array are not available for output, and not part of normal implicit program data vector (PDV) behaviors that would reset variables to missing.

data want;
 set have;
 array V varr1-varr3;
 array L[3] _temporary_;

 * save first rows values in temporary array for use in other rows;
 if _n_ = 1 then 
 do index = 1 to dim(V);
 L[index] = V[index];
 end;

 * … for example … ;

 array delta_from_1st [3]; * array statement implicitly creates three new variables that become part of PDV and get output;
 do index = 1 to dim(V);
 delta_from_1st[index] = V[index] - L[index];
 end; 
run;

share|improve this answer

answered Mar 22 at 17:17

RichardRichard

10.3k21329

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Works great! Thank you, and I have one additionaly question - how put column name in fragment: delta_from_1st[index] = V[index] - L[index] I tried use vname but doesn't work. I need example delta_[column name that calculated] Thanks!
  
  – DarkousPl
  Mar 25 at 11:20
  
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  The data step can not dynamically create the variable names of it's output. You can define the delta array as a grouping a data step variables (that would be added to the PDV). array delta delta_var1-deltavar3; The array construct in the example creates new variables based on the array name. SAS can not process accessors of the form array[<char-value>], you would have to use HASH object for that. Finally, sometimes it is far easier to use a reporting procedure to get a look at data in a special way, instead of manually reorganizing the data into a new layout
  
  – Richard
  Mar 25 at 13:25
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Richard, thank for explanation. I see more and more often that SAS has a lot limitations.
  
  – DarkousPl
  Mar 25 at 16:52
  

  
  
  
  

add a comment | 

1

You don't need macro, and not sure why you need temporary array L.

The array statement can be used to organize variables so they can be accessed in an array manner. Loop over the variable array in order to copy the values into the temporary array.

The elements of a temporary array are not available for output, and not part of normal implicit program data vector (PDV) behaviors that would reset variables to missing.

data want;
 set have;
 array V varr1-varr3;
 array L[3] _temporary_;

 * save first rows values in temporary array for use in other rows;
 if _n_ = 1 then 
 do index = 1 to dim(V);
 L[index] = V[index];
 end;

 * … for example … ;

 array delta_from_1st [3]; * array statement implicitly creates three new variables that become part of PDV and get output;
 do index = 1 to dim(V);
 delta_from_1st[index] = V[index] - L[index];
 end; 
run;

share|improve this answer

answered Mar 22 at 17:17

RichardRichard

10.3k21329

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Works great! Thank you, and I have one additionaly question - how put column name in fragment: delta_from_1st[index] = V[index] - L[index] I tried use vname but doesn't work. I need example delta_[column name that calculated] Thanks!
  
  – DarkousPl
  Mar 25 at 11:20
  
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  The data step can not dynamically create the variable names of it's output. You can define the delta array as a grouping a data step variables (that would be added to the PDV). array delta delta_var1-deltavar3; The array construct in the example creates new variables based on the array name. SAS can not process accessors of the form array[<char-value>], you would have to use HASH object for that. Finally, sometimes it is far easier to use a reporting procedure to get a look at data in a special way, instead of manually reorganizing the data into a new layout
  
  – Richard
  Mar 25 at 13:25
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Richard, thank for explanation. I see more and more often that SAS has a lot limitations.
  
  – DarkousPl
  Mar 25 at 16:52
  

  
  
  
  

add a comment | 

You don't need macro, and not sure why you need temporary array L.

The array statement can be used to organize variables so they can be accessed in an array manner. Loop over the variable array in order to copy the values into the temporary array.

The elements of a temporary array are not available for output, and not part of normal implicit program data vector (PDV) behaviors that would reset variables to missing.

data want;
 set have;
 array V varr1-varr3;
 array L[3] _temporary_;

 * save first rows values in temporary array for use in other rows;
 if _n_ = 1 then 
 do index = 1 to dim(V);
 L[index] = V[index];
 end;

 * … for example … ;

 array delta_from_1st [3]; * array statement implicitly creates three new variables that become part of PDV and get output;
 do index = 1 to dim(V);
 delta_from_1st[index] = V[index] - L[index];
 end; 
run;

share|improve this answer

answered Mar 22 at 17:17

RichardRichard

10.3k21329

data want;
 set have;
 array V varr1-varr3;
 array L[3] _temporary_;

 * save first rows values in temporary array for use in other rows;
 if _n_ = 1 then 
 do index = 1 to dim(V);
 L[index] = V[index];
 end;

 * … for example … ;

 array delta_from_1st [3]; * array statement implicitly creates three new variables that become part of PDV and get output;
 do index = 1 to dim(V);
 delta_from_1st[index] = V[index] - L[index];
 end; 
run;

share|improve this answer

answered Mar 22 at 17:17

RichardRichard

10.3k21329

answered Mar 22 at 17:17

RichardRichard

10.3k21329

answered Mar 22 at 17:17

RichardRichard

10.3k21329