I have the following Proc Sql to create sql tables, Instead of reapeating the commands I would like to know if I can use DO loop in proc SQL (all data in different years are available in the library) proc sql;      create table sqldb.ACxC_1993 as      select * from CxC1993;      create table sqldb.AValuAdded_1993 as      select * from ValuAdded1993;       create table sqldb.AFinalDemand_1993 as      select * from FinalDemand1993;      create table sqldb.ACxC_1994 as      select * from CxC1994;      create table sqldb.AValuAdded_1994 as      select * from ValuAdded1994;       create table sqldb.AFinalDemand_1994 as      select * from FinalDemand1994;      create table sqldb.ACxC_1995 as      select * from CxC1995;      create table sqldb.AValuAdded_1995 as      select * from ValuAdded1995;       create table sqldb.AFinalDemand_1995 as      select * from FinalDemand1995; quit; run; Thank you ... View more

I have the following Proc Sql to create sql tables, Instead of reapeating the commands I would like to know if I can use DO loop in proc SQL proc sql;      create table sqldb.ACxC_1993 as      select * from CxC1993;      create table sqldb.AValuAdded_1993 as      select * from ValuAdded1993;       create table sqldb.AFinalDemand_1993 as      select * from FinalDemand1993;      create table sqldb.ACxC_1994 as      select * from CxC1994;      create table sqldb.AValuAdded_1994 as      select * from ValuAdded1994;       create table sqldb.AFinalDemand_1994 as      select * from FinalDemand1994;      create table sqldb.ACxC_1995 as      select * from CxC1995;      create table sqldb.AValuAdded_1995 as      select * from ValuAdded1995;       create table sqldb.AFinalDemand_1995 as      select * from FinalDemand1995; quit; run; Thank you ... View more

Hi, If I have a vector v = [i j k] I want to repeat a vector in a vector format couple of times: v=[i j k i j k i j k ] Actually I would like to use this in reshaping a matrix to a vector. but I want to add a column by the variable name as the first two columns: z = [ 1 2 3 4 5 6 7 8 9] rowname = [ a b c] calname = [i j k] I am using Z = shape(Z, ncol*nrow, 1); I want to create a table looks like: a i 1 a j 2 a k 3 b i 4 b j 5 b k 6 c i 7 c j 8 c k 9 Thank you ... View more

Hi, I would like to know if anyone knows how to export data from SAS to SQL Server? Thank you. ... View more

NOTE: Writing HTML Body file: sashtml1.htm ERROR: (execution) Matrices do not conform to the operation. operation : * at line 6872 column 1 operands  : _TEM1001, Z_wst _TEM1001    175 rows    175 cols    (numeric) Z_WST    176 rows    179 cols    (numeric) statement : ASSIGN at line 6872 column 1 ERROR: (execution) Matrices do not conform to the operation. operation : * at line 6872 column 1 operands  : _TEM1001, Z_rtt _TEM1001    175 rows    175 cols    (numeric) Z_RTT    176 rows    179 cols    (numeric) statement : ASSIGN at line 6872 column 1 ERROR: (execution) Matrices do not conform to the operation. operation : * at line 6872 column 1 operands  : _TEM1001, Z_wst _TEM1001    175 rows    175 cols    (numeric) Z_WST    176 rows    179 cols    (numeric) statement : ASSIGN at line 6872 column 1 ERROR: (execution) Matrices do not conform to the operation. operation : * at line 6872 column 1 operands  : _TEM1001, Z_rtt _TEM1001    175 rows    175 cols    (numeric) Z_RTT    176 rows    179 cols    (numeric) statement : ASSIGN at line 6872 column 1 ERROR: (execution) Matrices do not conform to the operation. operation : `* at line 6872 column 1 operands  : wseshr, fdwst wseshr    175 rows      1 col     (numeric) fdwst    176 rows      1 col     (numeric) statement : ASSIGN at line 6872 column 1 ERROR: (execution) Matrices do not conform to the operation. operation : `* at line 6872 column 1 operands  : rteshr, fdrtt rteshr    175 rows      1 col     (numeric) fdrtt    176 rows      1 col     (numeric) statement : ASSIGN at line 6872 column 1 ERROR: (execution) Matrices do not conform to the operation. operation : `* at line 6872 column 1 operands  : wsgshr, fdwst wsgshr    175 rows      1 col     (numeric) fdwst    176 rows      1 col     (numeric) statement : ASSIGN at line 6872 column 1 ERROR: (execution) Matrices do not conform to the operation. operation : `* at line 6872 column 1 operands  : rtgshr, fdrtt rtgshr    175 rows      1 col     (numeric) fdrtt    176 rows      1 col     (numeric) statement : ASSIGN at line 6872 column 1 ERROR: (execution) Matrix has not been set to a value. operation : [ at line 6872 column 1 operands  : ZuerowW, $SUB0001 ZuerowW      0 row       0 col     (type ?, size 0) statement : ASSIGN at line 6872 column 1 ERROR: (execution) Matrix has not been set to a value. operation : [ at line 6872 column 1 operands  : ZuerowR, $SUB0001 ZuerowR      0 row       0 col     (type ?, size 0) statement : ASSIGN at line 6872 column 1 ERROR: (execution) Matrix has not been set to a value. operation : * at line 6872 column 1 operands  : ueratioW, zuerowW ueratioW      0 row       0 col     (type ?, size 0) ZuerowW      0 row       0 col     (type ?, size 0) statement : ASSIGN at line 6872 column 1 ERROR: (execution) Matrix has not been set to a value. operation : [ at line 6872 column 1 operands  : ZugrowW, $SUB0001 ZugrowW      0 row       0 col     (type ?, size 0) statement : ASSIGN at line 6872 column 1 ERROR: (execution) Matrix has not been set to a value. operation : [ at line 6872 column 1 operands  : ZugrowR, $SUB0001 ZugrowR      0 row       0 col     (type ?, size 0) statement : ASSIGN at line 6872 column 1 ERROR: (execution) Matrix has not been set to a value. . . . . ... View more

Hi, I would like my data to be stored in an imlstore that I have provided the link for: libname sqldb ODBC dsn='sqlBLS' schema=IO2012; libname imlstore 'C:\Users\hze1\Desktop\SAS\BLSData'; /*Read in 177x177 transaction matrix and 1x177 value added row*/ data Zmatrix;set sqldb.nominaluse_FMB_2012; if FMBcom ne 196;/*FMBcom 196 is value added*/ drop c196;/*c196 is final demand*/ proc sort;by stat_year FMBcom; run; data Zcom; set Zmatrix ; keep stat_year fmbcom; run; ======================= data Zmatrix and Zcom are storing in work directory which is different from the imlstore directory. I realized that if I use imlstore.Zmatrix will go to my imlstore directory, is there any way to skip the imlstore.Zmatrix and jsut use the Zmatrix and have the data at imlstore. Thank you ... View more

Hello. round(Z[,+]+ y - t(Z[+,]+v+m),.1) I am not familiar with SAS, what [,+], and [+,] will do on Z matrix and what is their difference. Thank you ... View more

round(Z[,+]+ y - t(Z[+,]+v+m),.1) I am not familiar with SAS, what [,+], and [+,] will do on Z matrix and what is their difference. Thank you ... View more