BookmarkSubscribeRSS Feed
Sabharish
Fluorite | Level 6

Hi,

I need to create variables in a sequence like var1,var2,var3... and write the values inside that variables using proc sql.

can anyone help me out with this.

 

Thanks,

sabharish

2 REPLIES 2
Reeza
Super User

@Sabharish wrote:

can anyone help me out with this.

 


Not with the information provided. Please explain your problem in detail. Also, justify the need for SQL. 

SQL doesn't support variable lists so a data step is easier. 

Ksharp
Super User

proc sql;
create table have (
 var1 num,
 var2 num,
 var3 num
);

insert into have
 values(1,1,1)
 values(2,2,2);

quit;

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1349 views
  • 0 likes
  • 3 in conversation