About Raj21

Raj21 · ‎07-27-2016

Pretty sure that worked perfect! Thank you!

Raj21 · ‎07-27-2016

A little more information for this one. I would want these observations (master data set) EquipmentTypeID CommodityCodeA SolverInclude CompartmentID C45CD NONPRO 28-30 Yes <No_Compartment_Specified> C45CD NONPRO 34-38 Yes <No_Compartment_Specified> C45CD NONPRO 38-42 Yes <No_Compartment_Specified> C45CD NONPRO 45-50 Yes <No_Compartment_Specified> To have these observations added to each one of the aboves observations. CommodityCodeB *DFT 3RD-PARTY CHEMICALS DRY DRY CHEMICAL DRY EE DRY ES DRY FAK DRY FOOD DRY GENERAL DRY HAZMAT DRY NORIDEFD DRY PET FOOD DRY SCENTED EE 28-30 EE 34-38 EE 38-42 Then I would just look for when commodityA and commodityB are the same and delete those observations and i would be set, so this would become 17 X 4 = 68 observations.

Raj21 · ‎07-27-2016

I have two data sets. One of which is a master data set with 965 observations and then i want to take the second data set which is 95 values and take every value and add it to each observation in the first data set. Could someone point me in the correct direction to a command that can do this. It should become 91675 observations by doing this, and then i can just weed out duplications with a if-then delete statement.

Raj21 · ‎07-25-2016

This worked exactly the way that I wanted, thank you!

Raj21 · ‎07-25-2016

I want to collapse dollars by summing by a specific variable. Every column in these two observations is the exact same except the PYMT_AMT_DLR. I would like to get that load to add up together then i can can sum by TRIP later and eventually do a comparison. LD_LEG_ID TRIP_ID PYMNT_AMT_DLR 10790980 349314 144.00 10790981 349314 -24.04 10790981 349314 144.00 Any help would be appreciated!

Raj21 · ‎07-25-2016

I can organize this by Trip_ID, that shouldn't be a problem. That do loop worked like a charm, thank you very much!

Raj21 · ‎07-25-2016

Sorry CHRG_CD is bundle and yes that is what I would be trying to do .

Raj21 · ‎07-25-2016

The first column is Load Leg, the second column is Trip ID and the third column is Bundle. For this observation I would like it to use the Trip id which would be the same and copy the bundle value. There are many more observations, so I would want that logic for the whole table.

Raj21 · ‎07-25-2016

I am trying to copy one cell to the next cell when another column has the same value. I have been using this code, but it doesn't seem to be working the way i want. if TRIP_ID=Lag(TRIP_ID) then CHRG_CD=lag(CHRG_CD); The trip_ID is 349333 10791391 349333 10791390 349333 3892B 10791390 349333 3892B

Raj21 · ‎07-23-2016

I wouldn't use it but unfortunately the software is requiring that. It is transportation modeler supplied by JDA. I'm still in the process of investigating if I can use something else instead of access.

Raj21 · ‎07-23-2016

Thank you again very much for your assistance and I will test that!

Raj21 · ‎07-23-2016

This is so awesome Reeza, thank you so much! My other question is this. I posted it wrong before. Still learning how to do stuff on this community. 🙂 Also when you use the insert buff command like so. PROC EXPORT DATA=WORK.xxxxxxxx OUTTABLE='xxxxxxxx' DBMS=ACCESSCS REPLACE; DATABASE='C:\xxxxxx\xxxxx\xxxxxxxxx.mdb'; SERVER='xxxxxxx'; PORT=xxxx; DBDSOPTS='INSERTBUFF=15'; RUN; if i increase this to 100, could this speed up the writing of the database?

Raj21 · ‎07-22-2016

Also when you use the insert buff command like so. PROC EXPORT DATA=WORK.xxxxxxxx OUTTABLE='xxxxxxxx' DBMS=ACCESSCS REPLACE; DATABASE='C:\xxxxxx\xxxxx\xxxxxxxxx.mdb'; SERVER='xxxxxxx'; PORT=xxxx; DBDSOPTS='INSERTBUFF=15'; RUN; if i increase this to 100, could this speed up the writing of the database?

Raj21 · ‎07-22-2016

I have not partitioned an access database before, but i can read up on this to figure it out. Would i essentially be telling SAS to write 1-1000000 observation and then 1000001-2000000 would be the next set?

Raj21 · ‎07-22-2016

I am running into size limitations with proc export to access. I was wondering if there is any way that i could write up to the 2GB limitation and then start a new access database immediately. I would just want this to keep going until everything is written and then i will link the access databases after that. I am trying to create one database that the software that i am utilizing can ping over and over to gather the necessary information.

Online Status	Offline
Date Last Visited	‎08-04-2016 12:32 PM

Re: Create new dataset

Re: Create new dataset

Create new dataset

Re: Summation

Summation

Re: Copying cell values

Re: Copying cell values

Re: Copying cell values

Copying cell values

Re: Access Size Limitation

Re: Create new dataset

Re: Create new dataset

Create new dataset

Re: Summation

Summation

Re: Copying cell values

Re: Copying cell values

Re: Copying cell values

Copying cell values

Re: Access Size Limitation

Re: Access Size Limitation

Re: Access Size Limitation

Re: Access Size Limitation

Re: Access Size Limitation

Access SAS export