Hi, I have to 2 different SAS programs that generate 2 different SAS tables named table1 and table2. Table1 and table2 codes below: data table1; length state $3 Chevy $7 GMC $7 Honda $7 miles $20; infile datalines dlm=',' dsd; input state Chevy GMC Honda miles; return; datalines; GA,$1200,$4300,$3000,"High Mileage Cars" ; run; proc print data=table1; run; data Table2; length Weeks $7 Prices $7 desc $32; infile datalines dlm=',' dsd; input Weeks Prices desc ; return; datalines; ' ',' ',"Insurance Track" First,Chevy,"Old Cars without Insurance" second,GMC,"Old Cars with Insurance" Third,Honda,"Old Cars with Insurance" ; run; proc print data=table2; run; I want to write a program that would enable me to retrieve the values of the columns Chevy, GMC, Honda, and miles, from table1 and place them at their respective positions in table2. Here is the design below: Data table: Miles _______________________________________________ Weeks Prices desc _______________________________________________ Insurance Track First Chevy OldCars without Insurance second GMC Old Cars with Insurance Third Honda OldCars with Insurance _______________________________________________ But the final output should contain the below data for respectively Chevy, GMC, Honda, miles: Data table: High Mileage Cars _______________________________________________ Weeks Prices desc _______________________________________________ Insurance Track First $1200 Old Cars without Insurance second $4300 Old Cars with Insurance Third $3000 Old Cars with Insurance ______________________________________________ Variable PRICES would be going on the user interface and treated as a global variable. Thanks for help
... View more