topic Re: Proc sql in SAS Programming

Create column names w/ seq no in Proc sql

Sabharish — Tue, 01 Nov 2016 12:12:51 GMT

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

Reeza — Tue, 01 Nov 2016 05:45:42 GMT

@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 — Tue, 01 Nov 2016 07:27:40 GMT


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

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

quit;