About Gladis6680

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

Gladis6680 · ‎06-06-2019

Thank you both so so so much !!

Gladis6680 · ‎06-06-2019

Is it possible to select rows where we have the same A, but different B and C. For example, from this table I would like rows where A=4 and A=10 A B C 1 yellow italy 1 yellow italy 2 green greece 3 purple london 4 orange portugal 4 orange belgium 5 red spain 6 brown netherlands 7 white france 8 black russia 8 black russia 9 grey barcelona 10 violet turkey 10 violet romania

Gladis6680 · ‎06-05-2019

thank you, but I think I my have not explained my problem well enough I just added a proc freq, table /list that gave me a concise table that looks like this, without the 0's Foodbuy_SubCategory Manufacturer Frequency Cumulative Frequency Beef Boxed Maple Leaf 2 2 Beef Boxed Cooked Hospital Food Services (HFS) 2 4 Beef Brisket Erie Meat Products 3 7 Beef Brisket Lesters Foods 212 219

Gladis6680 · ‎06-05-2019

What I would like is below, but I don't think its as easy as I thought. DRESS 6 DRESS 7 BLUE 34 10 DRESS 4 YELLOW 6 DRESS 6 PINK 18 DRESS 2 DRESS 6 DRESS 7 GREEN 5 427 79 DRESS 4 DRESS 6 DRESS 7 PURPLE 12 3 63

Gladis6680 · ‎06-05-2019

Is there an option that you can write in proc freq where we can only view the table only with values and not 0's DRESS 1 DRESS 2 DRESS 3 DRESS 4 DRESS 5 DRESS 6 DRESS 7 BLUE 0 0 0 0 0 34 10 YELLOW 0 0 0 6 0 0 0 PINK 0 0 0 0 0 18 0 RED 0 0 0 0 0 0 0 GREEN 0 5 0 0 0 427 79 PURPLE 0 0 0 12 0 3 63

Online Status	Offline
Date Last Visited	‎10-10-2023 01:17 PM

picking common selects

Re: PROC MERGE

PROC MERGE

Re: Analytics Pro - Desktop

Analytics Pro - Desktop

Re: PROC TABULATE

PROC TABULATE

Re: LAYOUT

LAYOUT

Re: Converting a numeric variable into character

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: 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

Re: selecting observations that have different corresponding columns

selecting observations that have different corresponding columns

Re: Delete 0's from proc freq crosstab

Re: Delete 0's from proc freq crosstab

Delete 0's from proc freq crosstab

SAS Analytics Explorers