BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
jjjunyi
Calcite | Level 5

Hi every one:)

I have a dataset, with variable v1 v2 and Rev, see below:

V1V2Rev
0.010.01453
0.010.02564
0.010.032354
0.020.01754
0.020.023534
0.020.031213
0.030.01435
0.030.0223
0.030.03543

now I would like to transfer dataset into an array: 

v2
v10.010.020.03
0.014535642354
0.0275435341213
0.0343523543

How could i accomplish that? should I use array? is there any procedure better than array?

Great Thanks,

Jenny


1 ACCEPTED SOLUTION

Accepted Solutions
Tom
Super User Tom
Super User

Not sure what you mean by an array.  You could use PROC TRANSPOSE, but then the numbers that you have in V2 will be turned into variable names.

proc transpose data=have out=want ;

  by v1 ;

  id v2 ;

  var rev ;

run;

View solution in original post

1 REPLY 1
Tom
Super User Tom
Super User

Not sure what you mean by an array.  You could use PROC TRANSPOSE, but then the numbers that you have in V2 will be turned into variable names.

proc transpose data=have out=want ;

  by v1 ;

  id v2 ;

  var rev ;

run;

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 860 views
  • 1 like
  • 2 in conversation