This question is Not Answered.(Mark as assumed answered)    Goli Magoli Oct 10, 2012 12:59 PM    I have a SAS program that uses the micro and at the end is generating the following tables that I want to export it to SQL: NCxC1993 NCxC1994 NCxC1995 NCxC1996 NCxC1997 I can use the following commands to create a table in SQL but I would like to use a loop: /*proc sql;     create table sqldb.cxcuse_dense_1993 as      select * from NCxC1993;      create table sqldb.cxcuse_dense_1994 as      select * from NCxC1994;      create table sqldb.cxcuse_dense_1995 as      select * from NCxC1995;      create table sqldb.cxcuse_dense_1996 as      select * from NCxC1996;      create table sqldb.cxcuse_dense_1997 as      select * from NCxC1997;  quit; run;*/ I am using the following loop but for some reason without any error does not create the tables in SQL (but the above command does) %macro sqlloop(start=,end=);      %do year = &start %to &end;      create table sqldb.cxcuse_dense_&year as      select * from NCxC&year;        %end %mend; proc sql; %sqlloop(start=1994,end=1995) quit; run; /*-----------------------------------------------------------------------*/ quit; run; is there any thoughts on why the sqlloop does not work. Thank you ... View more

I have a SAS program that uses the micro and at the end is generating the following tables that I want to export it to SQL: NCxC1993 NCxC1994 NCxC1995 NCxC1996 NCxC1997 I can use the following commands to create a table in SQL but I would like to use a loop: /*proc sql;     create table sqldb.cxcuse_dense_1993 as      select * from NCxC1993;      create table sqldb.cxcuse_dense_1994 as      select * from NCxC1994;      create table sqldb.cxcuse_dense_1995 as      select * from NCxC1995;      create table sqldb.cxcuse_dense_1996 as      select * from NCxC1996;      create table sqldb.cxcuse_dense_1997 as      select * from NCxC1997;  quit; run;*/ I am using the following loop but for some reason without any error does not create the tables in SQL (but the above command does) %macro sqlloop(start=,end=);      %do year = &start %to &end;      create table sqldb.cxcuse_dense_&year as      select * from NCxC&year;        %end %mend; proc sql; %sqlloop(start=1994,end=1995) quit; run; /*-----------------------------------------------------------------------*/ quit; run; is there any thoughts on why the sqlloop does not work. Thank you ... View more

I have a table wchich looks like below: year    elec    ngas    petro    transp 1993    0.328962596541413    0.0333333333333333    0.0294741106255071    0.0312981997615055 1994    0.32131918710743    0.0357852882703777    0.0280891133921987    0.0296270473156796 1995    0.312689346078104    0.0301204819277108    0.0299476941480979    0.0307595385921147 1996    0.302492954358166    0.0296846011131725    0.0306720643123235    0.0315941372524655 1997    0.297555088719812    0.037109375    0.0313930047898444    0.0324508531293975 1998    0.279078628962933    0.0390455531453362    0.0324409310705472    0.0333306670536662 1999    0.269449037043657    0.0390946502057613    0.0338084853707251    0.0342346177942214 2000    0.268587236213135    0.0389105058365759    0.0354842304721889    0.0367621612481076 2001    0.267152131952974    0.0426829268292683    0.0346861443472607    0.036119401007415 2002    0.25010602338106    0.041501976284585    0.0347417788989821    0.0361976486955247 2003    0.249007386555198    0.04    0.034782939573557    0.0362781339184914 I want to automatically generate the following vectors: hhd_nrg_coeff_order = {'elec', 'ngas', 'petro', 'transp'}; hhd_nrg_coeffs_93 = {0.328962596541413 ,   0.0333333333333333,   0.0294741106255071 ,   0.0312981997615055}; hhd_nrg_coeffs_94 = {0.32131918710743 ,   0.0357852882703777,    0.0280891133921987,    0.0296270473156796}; .... hhd_nrg_coeffs_03 = {0.249007386555198    0.04    0.034782939573557    0.0362781339184914} is there any way to generate it automatically in SAS. because I have more data till 2010 so it is gana be nasty in the code. Thanks ... View more

I have the FV_sectors (It has values as I have printed it), and the data in CONVENTION has icom and ccom where in some places I have icom which is including numbers in FV_sectors. I do not want to include them in SECTOR_LIST. but it is giving me the following error:     print FV_sectors;     use CONVENTIONAL;     /* list of all commodities */     read all var{cCom iCom} into SECTOR_LIST where ((iCom ^= FV_sectors)&(cCom ^= FV_sectors));     num_sectors = sqrt(nrow(SECTOR_LIST)); error: 431  print FV_sectors; 432      use CONVENTIONAL; 433 434      /* list of all commodities */ 435      read all var{cCom iCom} into SECTOR_LIST where ((iCom ^= FV_sectors)&(cCom ^= 435! FV_sectors)); ERROR: Type mismatch in WHERE clause for variable iCom. statement : READ at line 435 column 5 436      num_sectors = sqrt(nrow(SECTOR_LIST)); Thank you ... View more

I am receiving the following error message: 1610      read all var{fuel_r_&Yr} into fuel_r; ERROR: FUEL_R_ is not in the scope of variables for the data set. statement : READ at line 1610 column 5 for running the following command: use UTIL_RETAIL; read all var{elec_r_&Yr} into elec_r; read all var{fuel_r_&Yr} into fuel_r; any comments? ... View more

Hi, I am getting this error message in IML when I am ready to use the data: data UTIL_WHOLESALE; set sqldb3.utilshare_wholesale_02; proc sort; by cCom; run; proc iml; /* GET DATA */     use UTIL_WHOLESALE;     read all var{elec_w} into elec_w;     read all var{fuel_w} into fuel_w; Error is in using the UTIL_WHOLESALE; 1199  /* GET DATA */ 1200 1201      use UTIL_WHOLESALE;           ---           180 ERROR 180-322: Statement is not valid or it is used out of proper order. Any thoughts! ... View more