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
@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.
proc sql; create table have ( var1 num, var2 num, var3 num ); insert into have values(1,1,1) values(2,2,2); quit;
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.
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.