About ciro

ciro · ‎11-26-2014

thanks robert! it works very well now. I am heading now towards the greplay part.

ciro · ‎11-25-2014

okay, here is where I am stuck.. after defining with pattern statements the colors I would like to use, I had produced maps with by group processing. Each by group is a sector. after that the plan was to put individual graphs in a greplay template to show small multiples. however for each by group sas uses only some of the colors I have set, while I would like it assigned a precise color to each range, so that comparisons can be made across individual maps. here is the kind of code I am using. proc format; value map2fmt .='No Data' low-20='<=20' 20<-22='20<-22' 22<-24='22<-24' 24<-26='24<-26' 26<-28='26<-28' 28<-30='28<-30' 30<-32='30<-32' 32<-34='32<-34' 34<-36='34<-36' 36<-38='36<-38' 38<-40='38<-40' 40<-high='>40' ; run; goptions reset=all; goptions ftext=swiss ftitle=swiss xpixels = 1600 ypixels = 1200 ; %patterns(%bquote(&ramp)); proc gmap data=estimates map=country all ; by sector; format ch map2fmt.; id id; choro ch / coutline=black discrete name="gra" anno=centeranno; run; quit; any help is greatly appreciated.

ciro · ‎11-23-2014

Thank you guys, I am in the process of trying your techniques.

ciro · ‎11-20-2014

I am running 9.4 M1 The kind of graph I'am trying to produce is similar to the one at the bottom of this page: AllAnalytics - Jonathan Schwabish - Get Visual With Small Multiples Actually I dont' need so many maps, more in the range 6-12. And each subgraph should have only one "title", that is I a matrix-like structure is not needed. at the bottom of the whole graph there should be the legend with the colors used.

ciro · ‎11-19-2014

Hi, I would like to produce small multiple maps, but I was unable to find suggestions. I would appreciate some guidance on the steps needed. Is there any solution with statistical graphics? thank you in advance!

ciro · ‎02-27-2014

Thank you very much Bruno. It's perfect for what I need. Just I do not understand the use of the second @ in the first input statement.

ciro · ‎02-27-2014

dear all, I have to infile a text file like the one following. At the moment I just need to have a dataset with one variable and one record for each row of the text file. So that following I can extract something from it (for instance I need all the codes following @I01) I am not good with infile and input and my attempts have failed. I also tried to transform into excel and the import it into sas but without success. any help is appreciated thank you in advance :R: John Smith, 999-7543,John.Smith@gmail.com :I: //Q XYZRTSWPQ NSPRQLQ //N L 01WOW13 @T !BRR 08;LIM 20 @01@?30@02 !BRR -100;LIM 0 !LIM 68;BRR 2 @03 @A Dear CompanyName Street Name Town Name County Post Code @I01100100100 @I02robqqgzr @I03100100100 @A Dear CompanyNAme Street Name Town Name County PostCode @I01200200200 @I02robfxmal @I03200200200 @A

ciro · ‎10-30-2013

dear all, when I export a file as follows it ends with an empty row. proc export data=sashelp.class outfile='G:\temp\a.csv' dbms=dlm; delimiter=';'; run; In other terms when I open the file with a text editor, I can put the cursor one line after the last line of data. is there any possibilty to end it at the very last line of data? thank you very much in advance

ciro · ‎09-24-2012

hi, thank you very much for introducing me all these tools. I am learning a lot studying your examples. As a statistician (and not very good data step programmer) I liked very much the function graycode and the scoring approach, even if It might be not the more performance wise. I might probably mix some of your ideas. xcen > it

ciro · ‎09-21-2012

thank you for the suggestions, guys. but sorry, probably my explanation was not very clear. I need to find for each record the combination of variables (x1-x6) whose sum is closer to variable v. so for instance for the first record this is obtained by variables (x2,x3,x4) or (x3,x4,x5) an in that case I can accept one of them randomly, say (x2,x3,x4). In this case variable r should be equal to 011100 signaling which are the variables. for the second record the distance with variable v is minimized by sum(x1,x5) and in this case r should be 100010 and so on hope this is clearer

ciro · ‎09-21-2012

xcen > it hi everybody, I need to find the variables in an array (x1-x6) whose sum has a minimum distance with a variable v. for instance to the following dataset data before; input x1-x6 v; cards; 0.279567742 0.978487097 0.978487097 0.978487097 0.978487097 0.139783871 3 0.928564286 1.083325 1.083325 1.083325 0.154760714 0 1.2 0.838703226 0.978487097 0.978487097 0.978487097 0.559135484 0 2.8 0.43333 1.011103333 1.011103333 1.011103333 0.86666 0 4.333 ; run; I would like to add a string that indicates which variables provide the most similar value to variable v such as: data after; input x1-x6 v r $; cards; 0.279567742 0.978487097 0.978487097 0.978487097 0.978487097 0.139783871 3 011100 0.928564286 1.083325 1.083325 1.083325 0.154760714 0 1.2 100010 0.838703226 0.978487097 0.978487097 0.978487097 0.559135484 0 2.8 111000 0.43333 1.011103333 1.011103333 1.011103333 0.86666 0 4.333 111110 ; run; xcen > it in case of tie a random choice would be fine. please consider that the dataset is quite big, so in case of different options I would like suggestions on which is less resource intensive. any input is very appreciated thank you very much in advance

ciro · ‎09-06-2012

thank you everybody. I'll try some of the suggestions. no hashing though. isn't it useful in such a situation? As a further information I need the data in sas (not sure if temporary or permanent dataset) they are subject to further processing. xcen > it

ciro · ‎09-03-2012

thank you to all for the answers. following is an example of what i need. as for the operations it is not to be performed often, so I can afford to bring the data soon in sas and then perform the join. another thing that i forgot and is not in the example is that I can have multiple records for the key (X,Y,M) in dataset A, though not frequently. In that case let's suppose I need variables from one record randomly for the moment data A; input X $ Y $ M Z $ var1 ; cards; A 0001 1 P 10 A 0001 2 P 11 A 0001 3 P 12 A 0001 4 P 13 A 0001 8 P 17 A 0001 9 P 18 A 0001 10 P 20 A 0002 4 P 21 A 0002 5 P 23 A 0002 6 P 25 A 0002 7 P 27 A 0002 8 P 27 A 0002 9 P 20 A 0002 10 P 15 A 0002 11 P 14 A 0002 12 P 12 B 0041 1 F 18 B 0041 2 F 18 B 0041 3 F 19 B 0041 4 F 20 B 0041 5 F 21 B 0041 6 F 17 B 0041 7 F 17 B 0041 8 F 17 B 0041 9 F 20 ; run; data B; input X $ Y $ M S $ var2 ; cards; A 0001 5 E 4 A 0001 6 E 4 A 0001 7 E 6 A 0001 10 O 2 A 0001 12 E 6 A 0002 3 E 4 B 0041 8 O 5 B 0041 9 O 6 B 0041 10 E 6 B 0041 11 E 6 ; run; data A_after; infile datalines delimiter=','; input X $ Y $ M Z $ var1 S $ var2; cards; A,0001,1,P,10, , A,0001,2,P,11, , A,0001,3,P,12, , A,0001,4,P,13, , A,0001,5,P,13,E,4 A,0001,6,P,13,E,4 A,0001,7,P,13,E,6 A,0001,8,P,17, , A,0001,9,P,18, , A,0001,10,P,20,O,2 A,0001,12,P,20,E,6 A,0002,3,P,21,E,4 A,0002,4,P,21, , A,0002,5,P,23, , A,0002,6,P,25, , A,0002,7,P,27, , A,0002,8,P,27, , A,0002,9,P,20, , A,0002,10,P,15, , A,0002,11,P,14, , A,0002,12,P,12, , B,0041,1,F,18, , B,0041,2,F,18, , B,0041,3,F,19, , B,0041,4,F,20, , B,0041,5,F,21, , B,0041,6,F,17, , B,0041,7,F,17, , B,0041,8,F,17,O,5 B,0041,9,F,20,O,6 B,0041,10,F,20,E,6 B,0041,11,F,20,E,6 ; run; xcen > it

ciro · ‎09-03-2012

Hi everybody, I need to perform a join between a main table with about 200 millions records (call it table A) and a table with about 3 millions records (table B). both have repeated observations (monthly) per subject within a year. the merging key is composed by two variables that identify the subject (X, Y) and the month (M). The resulting table should be composed of all records of table A plus the records not found in table A but only in B. For these last type of records I would like to assign some of the variables from the closest month (if any) according to the following rule: the closest previous month or, if there are no record from the past, the closest subsequent month. both tables resides on a Oracle DBMS and are indexed by the variables (X,Y,M), although I can download them to use in sas I would appreciate any suggestions. If hash objects are involved I would need some more explanations as I am quite new to this world. However I'm willing to learn about them. Thank you very much in advance xcen > it

ciro · ‎05-31-2012

thank you to all fro the answers. I've learned something from each of them

Online Status	Offline
Date Last Visited	3 weeks ago

Re: find all possible sum of variables that amount to a value

find all possible sum of variables that amount to a value

Re: deduplicate data constrained to have different values across subgr...

Re: deduplicate data constrained to have different values across subgr...

Re: deduplicate data constrained to have different values across subgr...

deduplicate data constrained to have different values across subgroups

Re: minimize sum of distances given contraints

Re: minimize sum of distances given contraints

Re: minimize sum of distances given constraints

minimize sum of distances given contraints

Re: find all possible sum of variables that amount to a value

Re: find all possible sum of variables that amount to a value

Re: find all possible sum of variables that amount to a value

Re: find all possible sum of variables that amount to a value

Re: minimize sum of distances given contraints

find all possible sum of variables that amount to a value

Re: Making a publication quality table from regression results using p...

Re: small multiple maps

Re: small multiple maps

Re: small multiple maps

Re: small multiple maps

small multiple maps

Re: infile strange text file

infile strange text file

export without last empty line

Re: find variables whose sum minimizes distance with another variable

Re: find variables whose sum minimizes distance with another variable

find variables whose sum minimizes distance with another variable

Re: complex join with large tables

Re: complex join with large tables

complex join with large tables

Re: format multilabel all values