About Gladis6680

Gladis6680 · ‎06-21-2019

You show an example: "Spoon Soup Celine 18/0 Round 7 - 17.8Cm (502513) 12/1 Ea" where you want the "12/1 Ea" as result. The first / occurs before the values you want. Answer: Yes you are right, I apologize, the "/" can occur anytime, I just want the quantity. Your example does not have a consistent starting place as far as I can tell, or a consistent number of words at the end of the description. Answer: Yes you are right, it can be one word and it can be 2 words or even 3 words. I do understand that there is no set pattern, which makes it extremely difficult and I also understand I may not be able to get the desired result for all the rows. But anything to just get me started would be great. Also I had a slightly different request in another post,(How to split a character variable), where I only needed the description and not the quantity and one of the super users were able to get me started using the command below. This may be a silly question, but does the deleted characters get stored somewhere and if so, are we able to pull that info prxchange('s/\S+\s*(Ea|Ct|Kg|Gr|Lt|Lb|Ml)\b//i',-1,have); Thanks a lot

Gladis6680 · ‎06-21-2019

Missing details needed: Does every single one of your desired values contain a / character? Answer: Yes Is that the only place that a / character appears in the data? Answer: I am not sure if I understand, the measurement usually appears at the end and the description (character) appears at the end Is the value prior to the first / always immediately adjacent to the / character (no spaces for instance) and is it always numeric? Answer:Yes If this were my project I might ask around to see if there is an Inventory management program already in place. Many times those will already have fields related to packaging and contents per package. It might be easier to extract the information you need from that program, especially if the answer to any of my questions is "no". Answer:I have tried that and I haven't heard back

Gladis6680 · ‎06-21-2019

Hi there, I have asked this question in another thread, but I am not sure if it belongs there. I have a character variable with lots numeric values as well. I wanted to extract the numeric values and put them into another field. For example: What i have is the variable on the left and I would like to split the HAVE variable so that I could get the quantity which is on the right. I would really appreciate some help HAVE Quantity Sauce Alfredo #2 4/2 Kg 4/2 Kg Sauce Alfredo 2/3.7 Lt 2/3.7 Lt Assist 1Al1 1/18.9 LT 1/18.9 LT Assouplissant Solid Navisoft Bp S#Ncf# 2/6Lb 2/6Lb 100% Whole Wheat 1/675 Gr 1/675 Gr 15X20X1/2 White Cut/Board 6/1 Ea 6/1 Ea 16Oz White Plastic Funnel 1/1 Ea 1/1 Ea Spoon Soup Celine 18/0 Round 7 - 17.8Cm (502513) 12/1 Ea 12/1 Ea Spoon Soup Ecopro Poly 1/1000 Ea (10057937706427) 1/1000 Ea 16Oz White Plastic Funnel 1/1 Ea 1/1 Ea A&W Diet Root Beer 12/355 Ml 12/355 Ml A&W Rootbeer Fridge Pack 12/355 Ml 12/355 Ml Bag Garbage 35X50 Regular Black 1/100 Ct 1/100 Ct Bar Granola Fruit & Nut Trail Mix (000065633408811) 8/12/35 Gr 8/12/35 Gr

Gladis6680 · ‎06-21-2019

Hi, Also is it possible to put the quantity (what was deleted in the prxchange command) into another field? For example: HAVE Quantity Sauce Alfredo #2 4/2 Kg 4/2 Kg Sauce Alfredo 2/3.7 Lt 2/3.7 Lt Assist 1Al1 1/18.9 LT 1/18.9 LT Assouplissant Solid Navisoft Bp S#Ncf# 2/6Lb 2/6Lb 100% Whole Wheat 1/675 Gr 1/675 Gr 15X20X1/2 White Cut/Board 6/1 Ea 6/1 Ea 16Oz White Plastic Funnel 1/1 Ea 1/1 Ea A&W Diet Root Beer 12/355 Ml 12/355 Ml A&W Rootbeer Fridge Pack 12/355 Ml 12/355 Ml Almond Slivered Blanched (20067261010715) 2/1.50 Kg 2/1.50 Kg Almond Slivered Blanched 1/3 Kg 1/3 Kg Almond Whole Blanched (20067261010418) 2/1.50 Kg 2/1.50 Kg Bacon 14/16 Ct Center Cut 8.75 In Sliced 1/5 Kg 1/5 Kg Bacon 16/18 Ct Applewood Smoked 1/5 Kg 1/5 Kg Bacon 16/18 Ct Center Cut 1/5 Kg 1/5 Kg Bag Garbage 35X50 Heavy Duty Natural 1/200 Ct 1/200 Ct Bag Garbage 35X50 Regular Black 1/100 Ct 1/100 Ct Bar Granola Fruit & Nut Trail Mix (000065633408811) 8/12/35 Gr 8/12/35 Gr Bar Granola Oats N' Honey Crunchy 6/12/46 Gr 6/12/46 Gr Spoon Set Measure SS 6/1 Ea 6/1 Ea Spoon Soup Celine 18/0 Round 7 - 17.8Cm (502513) 12/1 Ea 12/1 Ea Spoon Soup Ecopro Poly 1/1000 Ea (10057937706427) 1/1000 Ea Spoon Soup Medium Weight Polypro Dense (00620868514701) 1/1000 Ct 1/1000 Ct Spoon Wooden 18 In W/Long Handle 1/1 Ea 1/1 Ea Spoon Wooden Heavy Duty 16 In - 40.6 Cm 1/1 Ea (575386) 1/1 Ea Spread Apple Raspberry 1/14 Kg 1/14 Kg thank you for your help

Gladis6680 · ‎06-12-2019

Thank you so much !!! this will help me get started for sure

Gladis6680 · ‎06-12-2019

Thank you for your advise, I have reached out to the source.

Gladis6680 · ‎06-11-2019

Is it possible to give me an example with some code Thanks

Gladis6680 · ‎06-11-2019

Hi there, I have a character variable called Description HAVE WANT Sauce Alfredo #2 4/2 Kg Sauce Alfredo Sauce Alfredo 2/3.7 Lt Sauce Alfredo Assist 1Al1 1/18.9 LT Assist 1Al1 Assouplissant Solid Navisoft Bp S#Ncf# 2/6Lb Assouplissant Solid Navisoft Bp S#Ncf# 100% Whole Wheat 1/675 Gr 100% Whole Wheat 15X20X1/2 White Cut/Board 6/1 Ea 15X20X1/2 White Cut/Board 16Oz White Plastic Funnel 1/1 Ea 16Oz White Plastic Funnel A&W Diet Root Beer 12/355 Ml A&W Diet Root Beer A&W Rootbeer Fridge Pack 12/355 Ml A&W Rootbeer Fridge Pack Almond Slivered Blanched (20067261010715) 2/1.50 Kg Almond Slivered Blanched (20067261010715) Almond Slivered Blanched 1/3 Kg Almond Slivered Blanched Almond Whole Blanched (20067261010418) 2/1.50 Kg Almond Whole Blanched (20067261010418) Bacon 14/16 Ct Center Cut 8.75 In Sliced 1/5 Kg Bacon 14/16 Ct Center Cut 8.75 In Sliced Bacon 16/18 Ct Applewood Smoked 1/5 Kg Bacon 16/18 Ct Applewood Smoked Bacon 16/18 Ct Center Cut 1/5 Kg Bacon 16/18 Ct Center Cut Bag Garbage 35X50 Heavy Duty Natural 1/200 Ct Bag Garbage 35X50 Heavy Duty Natural Bag Garbage 35X50 Regular Black 1/100 Ct Bag Garbage 35X50 Regular Black Bar Granola Fruit & Nut Trail Mix (000065633408811) 8/12/35 Gr Bar Granola Fruit & Nut Trail Mix (000065633408811) Bar Granola Oats N' Honey Crunchy 6/12/46 Gr Bar Granola Oats N' Honey Crunchy Spoon Set Measure SS 6/1 Ea Spoon Set Measure SS Spoon Soup Celine 18/0 Round 7 - 17.8Cm (502513) 12/1 Ea Spoon Soup Celine 18/0 Round 7 - 17.8Cm (502513) Spoon Soup Ecopro Poly 1/1000 Ea (10057937706427) Spoon Soup Ecopro Poly (10057937706427) Spoon Soup Medium Weight Polypro Dense (00620868514701) 1/1000 Ct Spoon Soup Medium Weight Polypro Dense (00620868514701) Spoon Wooden 18 In W/Long Handle 1/1 Ea Spoon Wooden 18 In W/Long Handle Spoon Wooden Heavy Duty 16 In - 40.6 Cm 1/1 Ea (575386) Spoon Wooden Heavy Duty 16 In - 40.6 Cm (575386) Spread Apple Raspberry 1/14 Kg Spread Apple Raspberry I would like to take the Quantity out for eg (Ea, Ct, Kg, Kg), some of the Ea's are in between the description. I would appreciate any help. Thanks

Gladis6680 · ‎06-09-2019

Thank you very much, I forgot to mention, that ..yes i am still figuring out which logic to use first(I may use the min AMOUNT, or max AMOUNT) for duplicates (like for Chicken,which Manufacture and which Brand I should use) .....but for the time being I would like the output to have all the the Chicken - Manufacture, Brand and Amount side by side like Manufacture_1 Brand _1 Manufacture_2 Brand_2. Also I am so sorry is it also possible to give this to me in a DATA STEP as I not familiar with SQL. Thank for your help

Gladis6680 · ‎06-09-2019

Thank you, is it possible for you to help me with a sample code. I think it will be easier for me to understand

Gladis6680 · ‎06-09-2019

Hi, I feel this subject may not be the appropriate title.sorry I thought I would explain my concern once again. I have changed the data slightly. Produce is my unique variable/by variable Produce Manufacturer Brand Amount Beans CLICxxx Clicxxxx $0 Kidneys Pantry Pantry Shelf $0 Brussel Sprouts Limson Limson $0 Cabbage Bear Bear Creek $0 Chicken Grannys Grannys Poultry Cooperative $0 Milk Global Global Direct $0 Beans Ital Ital-Pasta $4 Kidneys Primo Primo $5 Brussel Sprouts Alasko Alasko $6 Cabbage Keybrand Laurie's $7 Chicken Galco Flamingo $2 Chicken Maple Sofina $3 Chicken Maple Kitchen Essential $6 Milk Agropur Sealtest $5 Milk Saputo Neilson $6 What I would like is the table below: Produce Manufacturer Brand Amount Manufacturer_1 New_Brand_1 Potential_Amount_1 Manufacturer_2 New_Brand_2 Potential_Amount_2 Manufacturer_3 New_Brand_3 Potential_Amount_3 Beans CLICxxx Clicxxxx $0 Ital Ital-Pasta $4 Kidneys Pantry Pantry Shelf $0 Primo Primo $5 Brussel Sprouts Limson Limson $0 Alasko Alasko $6 Cabbage Bear Bear Creek $0 Keybrand Laurie's $7 Chicken Grannys Grannys Poultry Cooperative $0 Galco Flamingo $2 Maple Sofina $3 Maple Kitchen Essential $6 Milk Global Global Direct $0 Agropur Sealtest $5 Saputo Neilson $6 Basically for the same Produce variable that does not have an Amount, I would like to give Potential amounts with the corresponding Manufacturer and Brand and if there are multiple Manufactuers, Brands and Amounts for the Produce variable...in this case Chicken and Milk, I would like to see those potential Manufacturers, Brands, Amounts.

Gladis6680 · ‎06-07-2019

Thank you for your response Can you please explain what you mean with an example

Gladis6680 · ‎06-07-2019

Hi, I have a data with Produce as my BY Variable /unique variable My goal is to give potential Amounts to Produce that does not have an amount. I started off by creating another data set with Produce that have an amount and then later thought of merging with the main data, but my dilemma is I have 3 Chicken with 2 different Manufacturer and 2 brands giving 3 amounts, similarly for MILK. Ideally I would like to show amounts of Chicken with the corresponding Manufacturer, Brand and Amount. Produce Manufacturer Brand Amount Beans CLICxxx Clicxxxx $0 Kidneys Pantry Pantry Shelf $0 Brussel Sprouts Limson Limson $0 Cabbage Bear Bear Creek $0 Chicken Grannys Grannys Poultry Cooperative $0 Milk Global Global Direct $0 Beans Ital Ital-Pasta $4 Kidneys Primo Primo $5 Brussel Sprouts Alasko Alasko $6 Cabbage Keybrand Laurie's $7 Chicken Galco Flamingo $2 Chicken Maple $3 Chicken Maple Kitchen Essential $6 Milk Agropur Sealtest $5 Milk Saputo Neilson $6

Gladis6680 · ‎06-06-2019

thank you so much !!!!!!

Gladis6680 · ‎06-06-2019

Also, is this possible to do in a DATA step, I am not so familiar with proc sql. Thank you

Online Status	Offline
Date Last Visited	13 hours ago

Re: proc command

Re: proc command

Re: proc command

Re: proc command

proc command

picking common selects

Re: PROC MERGE

PROC MERGE

Re: Analytics Pro - Desktop

Analytics Pro - Desktop

Re: Analytics Pro - Desktop

Re: PROC TABULATE

Re: PROC TABULATE

Re: Converting a numeric variable into character

Re: How to split a character variable

Re: Splitting/Extracting numeric values from a character variable

Re: Splitting/Extracting numeric values from a character variable

Splitting/Extracting numeric values from a character variable

Re: How to split a character variable

Re: How to split a character variable

Re: How to split a character variable

Re: How to split a character variable

How to split a character variable

Re: Merging 2 BY variables

Re: Merging 2 BY variables

Re: Merging 2 BY variables

Re: Merging 2 BY variables

Filling in missing values

Re: selecting observations that have different corresponding columns

Re: selecting observations that have different corresponding columns

SAS Analytics Explorers