Hello community,   Can you please help me understand the puzzle/mystery here. I have created a dataset (chk) using the below code. When I do apply a subset condition for the dataset, it results in 0 records when theta value is >= 1.6. The same 0 records is the outcome when a where condition is applied to the dataset manually in sas window.   data chk; do miu=2 to 3.5 by 0.5;          do sd=0.7 to 1.3 by 0.3;                    do theta=0.8 to 2.8 by 0.2;                               do n=6 to 30 by 4;                               output;                               end;                    end;            end; end; run;   data chk1; set chk; where theta = 1.6; run;     Thank You. ... View more

Hi All,   Can you please help me with the following query. My goal is to count the number of non-missing values and stack those counts to original dataset. Since the counts are all generated in numeric format, when I stack the counts to original dataset it throws an error when it encounters character variable.   data final; set sashelp.electric; run;   ods output cnt=cnt; proc iml; use final; read all var _NUM_ into x[colname=nNames]; n = countn(x,"col"); nmiss = countmiss(x,"col"); read all var _CHAR_ into x[colname=cNames]; close final; c = countn(x,"col"); cmiss = countmiss(x,"col"); /* combine results for num and char into a single table */ Names = cNames || nNames; rNames = {" Missing", "Not Missing"}; cnt = (cmiss // c) || (nmiss // n); print cnt[r=rNames c=Names label=""]; ods trace off;   data final; set final cnt; run;   ... View more

Hi,   Can you please help me in figuring out the code for below scenario.   I have a variable with pagenumbers. I want these numbers to be hyperlinked to an external file. When there are one page numebr in the variable then there are no issues. But when there are multiple page numbers not sure how to code it.   pages 14 12, 15 8, 14, 20, 30, 32, 35         if index(pages,',')=0 then pg_=strip(pages); else if index(pages,',') then do;     pg_=substr(pages, 1, index(pages,','));     pg1_= substr(pages,index(pages,',')+1); end;   if pages ne '' and index(pages, ',')=0 then origin = '{CRF {\field {\*\fldinst HYPERLINK "\\blankcrf.pdf#page=' || trim(left(pg_)) || '"}{\fldrslt {\cs15\cf2 Page ' || trim(left(pg_)) || '}}}}'; else if pages ne '' and countc(pages, ',')=1 then origin = '{CRF {\field {\*\fldinst HYPERLINK "\\blankcrf.pdf#page=' || trim(left(pg_)) || '"}{\fldrslt {\cs15\cf2 Pages ' || trim(left(pg_)) || '}}}}' ||'{{\field {\*\fldinst HYPERLINK "\\blankcrf.pdf#page=' || trim(left(pg1_)) || '"}{\fldrslt {\cs15\cf2 ' || trim(left(pg1_)) || '}}}}';   else if pages ne '' and countc(pages, ',') gt 1 then origin='{Multiple CRF {\field {\*\fldinst HYPERLINK "\\blankcrf.pdf#page=1"}{\fldrslt {\cs15\cf2 Pages}}}}';   Can anyone help me in looping it n number of times based on the page numbers so that all the pages can be hyperlinked and I can replace the "Multiple CRF" value when there are more than two pages in the pages variable.     Thank You for your time. ... View more

Hi 1)  I am trying to print => symbol in Gplot. Any idea to do this. 2) Point label option prints the value of the data point over the datapoint. Is there any way that I can print it beside the datapoint. Thanks. ... View more

Hi I have a messy data which need to be organized. The original file has 500 variables, but for simplicity I came up with a sample excel sheet. The data has two columns school and contact.  The contact information needs to be organized into separate columns (name address phone fax web). The final output should have the following columns      school  name  address  phone  fax    web I appreciate your suggestions and help. School Contact CASTILLEJA SCHOOL Nancy Ware  1310 Bryant Street  Palo Alto California  94301 Phone: (508) 626-1567  Fax: (508) 872-0260 http://www.aaspjhasjearch.net CHALLENGER SCHOOL Wiedmann 1185 Hollenback Avenue  Sunnyvale California 94086 Phone:(954) 689-3984  Fax:(954) 689-3985 http://www.akhsksajtech.com CENTRAL MIDDLE SCHOOL Jan Dresser 828 Chestnut Street San Carlos California 94070http://www.aprjaurpimkesolution.com Cesar Chavez Academy 2450 Ralmar Avenue East Palo Alto California  94303 CLIFFORD SCHOOL http://www.cliffodf0galschool.com Costano School Charles Salter CRITTENDEN MIDDLE SCHOOL C. Anzia, Robin Russell, Joyce Murphree and Barbara Saxton phone: (123) 456-7890 ... View more