Actually looking at what your code is doing you should probably not be including the denominator variable in the array. Then it would not matter if it was before, after or in the middle of the list of numerator variables in the data vector. data share_three; set &cleaned_data(keep=store_id year quarter vol_g: vol_i: ); array share vol_g: ; do over share; if vol_i_0000 = 0 then share=0; else share = share / vol_i_0000 ; end; * Un comment next line if you want to force VOL_I_0000 to 1 as your previous code did ; * if vol_i_0000 ne 0 then vol_i_0000=1; run;
... View more
Personally, I find the coefficients easier to interpret if I use "reference cell" coding. A good reference that uses SAS for the examples is Paul Allison's "Logistic Regression Using the SAS System" that is a SAS BBU.
... View more
Hi: Yes, you are correct. IF c:\wombat exists, that would be an acceptable solution. IF, however, c:\wombat directory did NOT exist, then you would get the same error message. cynthia 1 FILENAME _TEMP_ "c:\wombat\something.html"; 2 3 ODS LISTING CLOSE; 4 5 ODS CHTML FILE =_TEMP_ RS=NONE; NOTE: Writing CHTML Body file: _TEMP_ ERROR: Physical file does not exist, c:\wombat\something.html. WARNING: No body file. CHTML output will not be created.
... View more
The original IDs are in the variable STRATUMID but I don't know how to add that into the template. You can try replacing the graphdatavalue/graphdatatext with that in the template and see if it works. Replace the classatrisk with STRatum provides the labels as 1: YOURLABEL and 2: YOUR LABEL. The legend will also have that by default and for now I can't see a way around it. SAS support has an example of how to get the atrisk table at the bottom of the graph (rather than inside) you may want to check that one. It'll be fully customized for that particular procedure but will work. Or contact tech support .
... View more
Thanks FriedEgg. Very kind of you to share the documentation about Teradata in SAS. I have boomarked it. I am slowly learning about SAS and finally beginning to get comfortable with it. Cheers, Yeti.
... View more
This is correct Cynthia, and thank you. I appreciate you clearing this up. Before any responses were posted I had managed to dig all of this info up in the help file, so when Reeza posted the information I gave it a only quick glance. When referencing the table you do need "TTests" and not just "TTest"
... View more
Run the proc with with the code between ods trace on and off ie ods trace on; proc logistic....rest of code ods trace off; Look at the log and get the names of the tables you're interested in or the doc that Art provided a link to. then add in the line for either ods select or ods exclude. ods select tablenameshere; proc logistic then the only output you'll get are the ones youre interested in. If you only want to exclude one table then its easier to ods exclude tablename rather than type ods include allothers so decide what works for you.
... View more
Agusto, One caution about using the Modify statement. Make sure the original is backed up somewhere first. A syntax error can make a mess of the dataset. "Damage to the SAS data set can occur if the system terminates abnormally during a DATA step that contains the MODIFY statement. Observations in native SAS data files might have incorrect data values, or the data file might become unreadable. DBMS tables that are referenced by views are not affected. " Doc Muhlbaier Duke
... View more
I will have to try this method and see how it works. I have not yet been able to try it on my data but will let you know if it works out. thank you for the suggestion!
... View more
community admins can tag other the posts of other people. I don't know about one user tagging another user's posts. As it happens, I am at a conference right now learning more about this software. I'm taking notes of all of your questions and will see what I can do to get them answered.
... View more
Thank you Reeza. This is exactly what I needed. SET WORK.ALL_COL; BY id; keep id _ref_id; delim1 = ';'; do count = 1 to cnt_ref_id; _ref_id = scan(re_id,count,delim1, 'or'); output; end;
... View more
The code is below and Robs suggestions of using midpoints was the correct one. Becuase I'm using numeric values it was midpoints=0 to 1 by 0.1 that got it working without the fake data points. Thanks! data fake_map_data; length region $10.; lha=''; do i=1 to 100 by 10; pop_pct3=i/100; pop_pct15=i/100; pop_pct16=i/100; output; end; drop i; run; data region_data2; set region_data fake_map_data; run; legend1 label=none across=1 position=(right middle); proc gmap data=region_data2 map=map_data; id region; choro pop_pct3 / discrete coutline=black midpoints=0 to 1 by 0.1 legend=legend1; format pop_pct3 rate.; run; quit;
... View more
It has been several years since I used sas on mainframe, and many more since I did so through a mac os, but I remember using the following terminal emulator when I connected to the IBM 3270 mainframe we were using at the time. It looks like it has been maintained through current versions os mac os too. http://www.brown.edu/cis/tn3270/ From windows I used to be fond of Reflections, but i do not this they make a version for mac. One other that comes to mind is called ZOC, like Reflections though, is not a free software.
... View more
