How To select All Rows from a SAS data set that Match at least one value in another SAS Data set -


i trying read ticker names of 100 stocks / etfs 1 csv file. have 2 csv files, 1 contains data stocks / etfs on 90 day period. second contains name of 100 stock/etf tickers interested in selecting. below code, work.etfnames 1 column data set contains 100 etf names want select fulldata. how can use list of names correctly select desired data. in work.fulldata names stored in column called "ticker". have sorted data type (either etf or stock) cant figure out how select rows interested in these tables. thank you!

proc import out=work.fulldata    datafile="/folders/myshortcuts/myfolder/q2_2012_all.csv"    dbms=csv replace;    getnames=yes;    datarow=2; run;  proc import out = work.etfnames    datafile = "/folders/myshortcuts/myfolder/etfs.csv"    dbms=csv replace;    getnames=yes;    datarow=2; run;  proc sql;    create table stocks    select *    fulldata    security eq "stock"; quit;  proc sql;    create table etf    select *    fulldata    security eq "etf"  quit;

you might want try merging 2 datasets, , accepting have matching "ticker" values. i'm going assume dataset etfnames has names stored under variable "ticker" too.

  proc import out= work.fulldata             datafile= "/folders/myshortcuts/myfolder/q2_2012_all.csv"             dbms=csv replace;      getnames=yes;      datarow=2;    run;     proc import out= work.etfnames             datafile= "/folders/myshortcuts/myfolder/etfs.csv"             dbms=csv replace;      getnames=yes;      datarow=2;    run;    proc sort data=work.fulldata out=work.fulldatasort;         ticker;   run;    proc sort data=work.eftnames out=work.eftnamessort;         ticker;   run;    data work.partdata;         merge work.fulldatasort work.eftnamessort(in=a);         ticker;         if a;   run;    proc sql;   create table stocks   select *   partdata   security eq "stock";   quit;    proc sql;   create table etf   select *   partdata   security eq "etf"    quit;

as far can tell give desired result. join in proc sql statements instead of merge, merge easier write imo.


-

Comments

Post a Comment

Popular posts from this blog

c# - Binding a comma separated list to a List<int> in asp.net web api -

the default binder in web api expecst http://url.com/webapi/report/?pageids=3243&pageids=2365 to bind public ihttpactionresult report(list<int> pageids){ // exciting webapi code} i wish bind http://url.com/webapi/report/?pageids=3243,2365 as running out of space in url get . i have created class public class commaseparatedmodelbinder : system.web.http.modelbinding.imodelbinder { public bool bindmodel(httpactioncontext actioncontext, modelbindingcontext bindingcontext) { //binding in here } } and registered in webapiconfig.cs var provider = new simplemodelbinderprovider( typeof(list<int>), new commaseparatedmodelbinder()); config.services.insert(typeof(modelbinderprovider), 0, provider); i have altered method signature use model binder so public ihttpactionresult report( [modelbinder] list<int> pageids){ // exciting webapi code} however break point in binder not being
Read more

Delphi 7 and decode UTF-8 base64 -

in delphi 7, have widestring encoded base64(that received web service widestring result) : pd94bwwgdmvyc2lvbj0ims4wij8+dqo8c3ryaw5nptiq2lpyqjwvc3ryaw5npg== when decoded it, result not utf-8: <?xml version="1.0"?> <string>طھط³طھ</string> but when decoded base64decode.org, result true : <?xml version="1.0"?> <string>تست</string> i have use encddecd unit decodestring function. the problem have using decodestring . function, in delphi 7, treats decoded binary data being ansi encoded. , problem text utf-8 encoded. to continue encddecd unit have couple of options. can switch decodestream . instance, code produce utf-8 encoded text file data: {$apptype console} uses classes, encddecd; const data = 'pd94bwwgdmvyc2lvbj0ims4wij8+dqo8c3ryaw5nptiq2lpyqjwvc3ryaw5npg=='; var input: tstringstream; output: tfilestream; begin input := tstringstream.create(data); try output := tfilestream.
Read more

html - Is there any way to exclude a single element from the style? (Bootstrap) -

so, have img logo, overlaid on div styled background-image: url("...") , , both elements inside 2 div classes .to-color , .to-overlay respectively, black transparent overlay. is there way exclude logo style given these 2 classes? here's jsfiddle example: link html , css example: - html - <div class="to-color"> <div class="to-overlay"> <div class="respo"> <div class="row"> <div class="col-xs-4 col-xs-offset-4 text-center"> <img src="http://ansonalex.com/wp-content/uploads/2011/06/google-logo-768x260.png" alt="..." class="img-responsive"> </div> </div> </div> </div> </div> - css - .to-color { background-color: #000; } .to-overlay { opacity : 0.5; } .respo { background-image: url("https://source.unsplash.com/category/objects/1600x900"); background-position: center center;
Read more