About iiibbb

iiibbb · ‎03-13-2012

Sorry, that just generates the same 600 line dataset I got with my statement. Thanks

iiibbb · ‎03-13-2012

I normally don't have trouble with merges, but I am usually doing it with simpler datasets. I need to merge two datasets (DAILY_PAR_MRG and IPARF_MRG) to create 5,640 unique entries based on the PAR_periods. The DAILY_PAR_MRG file is data from a meteorlogical station. Depending on which measurement period (PAR_PERIOD) the day falls in, a different factor (IPARf) needs to be applied to the variables DAILY_PAR and DAILY_MJ. I thought this would be staight-forward merge, but the successful dataset will have 5,640 lines; each CLONE (N=15) and REP (N=4) will have 94 values of DAILY_PAR and DAILY_MJ for the dates from June-29 to Sept-30 with the IPARf that corresponds to the PAR_PERIOD for that date. When I do a merge, I only get 600 lines. I'm not sure what I'm missing. Is this something for SQL? I've never used that before. proc sort data=IPARf_mrg; by PAR_Period; run; proc sort data=Daily_PAR_mrg; by PAR_Period; run; data cPAR; mergeDaily_PAR_mrg IPARf_mrg; by PAR_Period; proc print; run; Thank you. I don't know why the above is different than the simple case below. data one; input id $ fruit $12.; datalines; a apple a apricot b banana c coconut c cherry c crabapple ; data two; input id $ color $; datalines; a amber b brown b black c cocoa c cream ; data both; merge one two; by id; run; proc print data=both; run;

iiibbb · ‎02-11-2012

I wish it were intutive, but it's not. I'm willing to learn though.

iiibbb · ‎02-10-2012

Art I think I owe you a beer by now. Thanks everyone.

iiibbb · ‎02-10-2012

Obs Pleg PLT _TYPE_ _FREQ_ Speed Desired_PLT e lagPLT NewPLT 1 51 51 HR1 0 44 2.69545 HR1 . FLD HR1 2 52 52 FLD 0 295 2.03322 FLD . HR2 FLD 3 53 53 HR2 0 145 0.68828 HR2 0 FLD HR2 4 54 54 FLD 0 216 2.54676 FLD 0 HR1 FLD 5 55 55 HR1 0 43 3.08837 HR1 0 FLD HR1 6 56 56 FLD 0 301 2.04751 FLD 0 HR2 FLD 7 57 57 HR2 0 119 0.73277 HR2 0 FLD HR2 8 58 58 FLD 0 21 0.0619 HR2 2 HR2 HR2 9 59 59 HR2 0 3 0 HR2 2 FLD HR2 10 60 60 FLD 0 1 0.1 HR2 2 HR2 HR2 11 61 61 HR2 0 2 0.15 HR2 2 FLD HR2 12 62 62 FLD 0 5 0.12 HR2 2 HR2 HR2 13 63 63 HR2 0 43 0.1 HR2 2 FLD HR2 14 64 64 FLD 0 211 2.61374 FLD 0 HR1 FLD 15 65 65 HR1 0 35 3.22857 HR1 0 FLD HR1 16 66 66 FLD 0 317 1.83533 FLD 0 HR2 FLD 17 67 67 HR2 0 331 0.37583 HR2 0 FLD HR2 18 68 68 FLD 0 243 2.27037 FLD 0 HR1 FLD 19 69 69 HR1 0 86 2.48023 HR1 0 FLD HR1 20 70 70 FLD 0 22 0.76364 HR1 2 HR1 HR1 21 71 71 HR1 0 43 2.3814 HR1 2 FLD HR1 22 72 72 FLD 0 255 2.07961 FLD 0 HR2 FLD 23 73 73 HR2 0 232 0.80819 HR2 0 FLD HR2 24 74 74 FLD 0 208 2.52837 FLD 0 HR1 FLD 25 75 75 HR1 0 2 0.5 HR1 0 FLD HR1 26 76 76 FLD 0 14 0.70714 HR1 2 HR1 HR1 27 77 77 HR1 0 37 3.94865 HR1 2 FLD HR1 28 78 78 FLD 0 171 2.84971 FLD 0 HR2 FLD 29 79 79 HR2 0 299 0.64482 HR2 0 FLD HR2 30 80 80 FLD 0 320 1.83125 FLD 0 HR1 FLD 31 81 81 HR1 0 35 4.18286 HR1 0 FLD HR1 32 82 82 FLD 0 193 2.51244 FLD 0 HR2 FLD 33 83 83 HR2 0 778 0.31427 HR2 0 FLD HR2 34 84 84 FLD 0 310 1.80097 FLD 0 HR1 FLD 35 119 119 HR1 0 39 3.76154 HR1 0 FLD HR1 36 120 120 FLD 0 213 2.11549 FLD 0 HR2 FLD 37 121 121 HR2 0 2 3.45 HR2 0 FLD HR2 38 122 122 FLD 0 2 2.7 HR2 2 HR2 HR2 39 123 123 HR2 0 57 3.38246 HR2 2 FLD HR2 40 124 124 FLD 0 570 1.02649 FLD 0 HR1 FLD 41 125 125 HR1 0 428 0.39556 HR1 . HR1

iiibbb · ‎02-10-2012

I figured out something that worked.... It is not Elegant. Get rid of the drop statement toward the end and you can see the progression. data a; input Obs PLeg PLT $ _TYPE_ _FREQ_ speed Desired_PLT $; cards; 51 51 HR1 0 44 2.69545 HR1 52 52 FLD 0 295 2.03322 FLD 53 53 HR2 0 145 0.68828 HR2 54 54 FLD 0 216 2.54676 FLD 55 55 HR1 0 43 3.08837 HR1 56 56 FLD 0 301 2.04751 FLD 57 57 HR2 0 119 0.73277 HR2 58 58 FLD 0 21 0.0619 HR2 59 59 HR2 0 3 0 HR2 60 60 FLD 0 1 0.1 HR2 61 61 HR2 0 2 0.15 HR2 62 62 FLD 0 5 0.12 HR2 63 63 HR2 0 43 0.1 HR2 64 64 FLD 0 211 2.61374 FLD 65 65 HR1 0 35 3.22857 HR1 66 66 FLD 0 317 1.83533 FLD 67 67 HR2 0 331 0.37583 HR2 68 68 FLD 0 243 2.27037 FLD 69 69 HR1 0 86 2.48023 HR1 70 70 FLD 0 22 0.76364 HR1 71 71 HR1 0 43 2.3814 HR1 72 72 FLD 0 255 2.07961 FLD 73 73 HR2 0 232 0.80819 HR2 74 74 FLD 0 208 2.52837 FLD 75 75 HR1 0 2 0.5 HR1 76 76 FLD 0 14 0.70714 HR1 77 77 HR1 0 37 3.94865 HR1 78 78 FLD 0 171 2.84971 FLD 79 79 HR2 0 299 0.64482 HR2 80 80 FLD 0 320 1.83125 FLD 81 81 HR1 0 35 4.18286 HR1 82 82 FLD 0 193 2.51244 FLD 83 83 HR2 0 778 0.31427 HR2 84 84 FLD 0 310 1.80097 FLD 119 119 HR1 0 39 3.76154 HR1 120 120 FLD 0 213 2.11549 FLD 121 121 HR2 0 2 3.45 HR2 122 122 FLD 0 2 2.7 HR2 123 123 HR2 0 57 3.38246 HR2 124 124 FLD 0 570 1.02649 FLD 125 125 HR1 0 428 0.39556 HR1 ;; run; data b; set a; if PLT="FLD" then a=0; if PLT="HR1" then a=-1; if PLT="HR2" then a=1; b = lag2(a); sumab= abs(a+b); c = lag1(sumab); if sumab = 0 then d = c; else d = sumab; run; proc sort; by descending PLeg; run; data c; drop sumab a b c d; set b; e = lag1(d); LagPLT=lag1(PLT); if e=2 and PLT="FLD" then NewPLT=LagPLT; else NewPLT=PLT; run; proc sort; by PLeg; proc print; run;

iiibbb · ‎02-10-2012

I will try that. I have been mulling over another idea that I'm pretty sure will work, but it is far less elegant looking, more of a square peg, round hole, big robot hammer approach. I will try yours in the next day or two and let you know.

iiibbb · ‎02-09-2012

I know that I've been asking a lot of questions. I have been pushing my SAS envelope quite a bit lately. I have an interesting dataset of GPS data tracking a machine as it travels on a field. It moves from field to headrows on each end. We have 10's of thousands of points taken from GPS and GIS. I am basically trying to quantify the time spent on each leg (up a row, turn around in a headrow, down another row, turn around in a headrow, up another row), and in the future do some other calculations. My current problem Sometimes the machine doesn't cleanly re-enter the field and has to back out, reset, and restart. My approach has been to assign leg numbers to these and when they cross the boundary into another zone. However, I wind up with tiny leg segments that should be lumped in with the point where the machine first exited the field. I anticipated this problem to a degree using a small artificial dataset, used proc means to find out these tiny legs, then reassign their leg using the lag statement. Merged it back and recalculated the legs... worked great. Real life is not as simple. First off, I get multiple tiny leg segments (sometimes close to a dozen, sometimes just a couple). So-- is there a way anyone can think of that I might automate this. I am not generally opposed to doing it by hand, but I have at least 10 of these datasets to go through, and if I can automate it I'd like to. This table represents a subset of data that is generated by my proc means, minus the New_PLT column, which is the column I'd like to find a way to generate automatically. You can see that the machine proceeds from a headrow "HR1" into the field, into "HR2", reenters the field. The attribute that is common is that when I want to lump them in with previous types, there are a series of "legs" (PLeg) with low _FREQ_, and it primarily there is a repeating pattern HR1 FIELD HR1 FIELD repeat... or HR2 FIELD HR2 FIELD repeat... Any ideas? I had some good ones, but I have a headache now. Obs PLeg PLT _TYPE_ _FREQ_ speed New_PLT 51 51 HR1 0 44 2.69545 HR1 52 52 FLD 0 295 2.03322 FLD 53 53 HR2 0 145 0.68828 HR2 54 54 FLD 0 216 2.54676 FLD 55 55 HR1 0 43 3.08837 HR1 56 56 FLD 0 301 2.04751 FLD 57 57 HR2 0 119 0.73277 HR2 58 58 FLD 0 21 0.0619 HR2 59 59 HR2 0 3 0 HR2 60 60 FLD 0 1 0.1 HR2 61 61 HR2 0 2 0.15 HR2 62 62 FLD 0 5 0.12 HR2 63 63 HR2 0 43 0.1 HR2 64 64 FLD 0 211 2.61374 FLD 65 65 HR1 0 35 3.22857 HR1 66 66 FLD 0 317 1.83533 FLD 67 67 HR2 0 331 0.37583 HR2 68 68 FLD 0 243 2.27037 FLD 69 69 HR1 0 86 2.48023 HR1 70 70 FLD 0 22 0.76364 FLD 71 71 HR1 0 43 2.3814 HR1 72 72 FLD 0 255 2.07961 FLD 73 73 HR2 0 232 0.80819 HR2 74 74 FLD 0 208 2.52837 FLD 75 75 HR1 0 2 0.5 HR1 76 76 FLD 0 14 0.70714 HR1 77 77 HR1 0 37 3.94865 HR1 78 78 FLD 0 171 2.84971 FLD 79 79 HR2 0 299 0.64482 HR2 80 80 FLD 0 320 1.83125 FLD 81 81 HR1 0 35 4.18286 HR1 82 82 FLD 0 193 2.51244 FLD 83 83 HR2 0 778 0.31427 HR2 84 84 FLD 0 310 1.80097 FLD 119 119 HR1 0 39 3.76154 HR1 120 120 FLD 0 213 2.11549 FLD 121 121 HR2 0 2 3.45 HR2 122 122 FLD 0 2 2.7 HR2 123 123 HR2 0 57 3.38246 HR2 124 124 FLD 0 570 1.02649 FLD 125 125 HR1 0 428 0.39556 HR1

iiibbb · ‎02-09-2012

This does what I'd expect... data sample; input d c b a; cards; 4 3 2 1 ; data retain_method; retain a b c d; set sample; proc print; run; ---------------------------- The following prints all variables, but fails to reorder them or drop the ones I don't want. Note: Dataset work.a has a mixture of character, date, time, numerical values, and my retain statement is not calling them all because I want to drop them. data b; set a; retain GPS_Date GPS_Time GPS_Second Name Speed Bearing Inclinatio East North Up Max_PDOP Max_HDOP Northing Easting; proc print data=b (obs=40); run; What am I doing wrong?

iiibbb · ‎02-08-2012

Thank you. Sometimes I wonder if I'm ever going to understand some of this syntax... but I've always had so much control over my data before moving to SAS and thus, my code has always been clean and simple. This automated stuff is really making me realize how much I don't know. Thanks

iiibbb · ‎02-08-2012

say the variable's name is GPS_Time. Could you please give me an example of that syntax? I tried adding it, but apparently I'm putting it in the wrong place. Thank you

iiibbb · ‎02-08-2012

Explain further... if I import the data using the import data menu, and create a permanent dataset in a library. Then I create a temporary dataset and convert the variable using that formula? It might help to note that Excel doesn't recognize it as a time field either.

iiibbb · ‎02-08-2012

I am trying to import a GIS field that contains time data. SAS is importing it from Excel as a character string, but I need to convert it to a time string. I can 't seem to figure out how. Examples of the field is 10:12:56am 11:23:23am 12:43:23pm 03:45:21pm 05:23:53pm I am a little befuddled.

iiibbb · ‎02-07-2012

Can anyone suggest a good tutorial for more advanced data step functions? This sort of thing (http://www2.sas.com/proceedings/sugi30/134-30.pdf) I know inside and out.

iiibbb · ‎02-07-2012

I'll admit I'm a neophite. I wish I had the code that botched my sorting. I've already replaced it with code that works (I generally like to destroy non-working code as quick as possible) However, I'm certain I had a well laid out logic that didn't work when it was built into the if/then statement... and worked as soon as I created a stand-alone variable. Needless to say, a learning experience, and I hope that I will come to better understand how this works in the future. I've not worked with data like this before and I'm learning all sorts of new and fun things. At least I can tell when something is not working

Online Status	Offline
Date Last Visited	‎03-08-2024 11:54 PM

Help with simple survival data example

Is there a way to output coefficients for the confidence lines for a r...

Re: Is there a simple way to find the old path for a broken library?

Re: Is there a simple way to find the old path for a broken library?

Re: Is there a simple way to find the old path for a broken library?

Is there a simple way to find the old path for a broken library?

Re: PROC SGPLOT mixing line and scatter plots?

Re: PROC SGPLOT mixing line and scatter plots?

PROC SGPLOT mixing line and scatter plots?

PROC ROBUSTREG ==> can I get some kind of prediction limit or similar?

Re: Is there a simple way to find the old path for a broken library?

Re: Group scatter plots in proc GPLOT

Re: Group scatter plots in proc GPLOT

Re: Group scatter plots in proc GPLOT

Re: Group scatter plots in proc GPLOT

Re: Function Key question

Re: How to create a variable column when repeated groups are unlabled?

Re: An interesting problem...

Big Merge Help

Big Merge Help

Re: An interesting problem...

Re: An interesting problem...

Re: An interesting problem...

Re: An interesting problem...

An interesting problem...

An interesting problem...

Why would "retain" in the data statement fail to reorder variables?

Re: Some help importing some time data.

Re: Some help importing some time data.

Re: Some help importing some time data.

Some help importing some time data.

Re: Help with LAG or RETAIN?

Re: Help with LAG or RETAIN?