About Foody

Foody · ‎09-06-2016

Hello everyone, I did a survey to know what people think about my brochure. And i would like to draw a pie with their % good or bad opinion. the variable i want to draw is " Brochure " coded in 1,2,3,4. I would like to choose the color of the pie : 1 = Very good in Green 2= Good in greenyellow 3= satisfying in red 4= not satisfying in Black SAS put me random colors... is it possible to choose each color for each value of the variable drawn in the pie please ? Thank you, if you find me a solution 🙂 title1'Readibility of the brochure'; pattern1 color=green; pattern2 color=greenyellow; pattern3 color=red; pattern4 color=black; proc format; value brochure 1='Very Good' 2='Good' 3='Satisfying' 4='Not Satisfying'; run; proc gchart data=conso; PIE brochure/ value=none percent=arrow slice=arrow noheading plabel=(font='Albany AMT/bold' h=1.3 color=depk); format brochure brochure.; run; goptions reset=all; These are the colors that i would like to have.

Foody · ‎09-05-2016

Thank you ! Now it works ! proc gchart data=conso; vbar cat_age /discrete maxis=axis1 raxis=axis2; format cat_age cat_age.; run; quit;

Foody · ‎09-05-2016

Hello, I have the number of people by age. My numeric variable of age category ' Cat_age ' was coded in 1,2,3. 1='3-5 years' 2='6-11 years' 3='12-18 years' I would like to draw a graph with the number of people by age. So i used a proc format to display in my graph "3-5 years' instead of "1" but it doesn't seem to work... The graph displays me column with 1,2,3 in the horizontal axis. Ci-below my script (i am a beginner in SAS ...). Thanks in advance, title 'Age distribution'; axis1 stagger label=('Âge'); axis2 label=('Effectif'); proc format; value cat_age 1='3-5 ans' 2='6-11 ans' 3='12-18 ans'; run; proc gchart data=conso; vbar cat_age /discrete maxis=axis1 raxis=axis2; format cat_age; run; quit;

Foody · ‎07-04-2016

Thanks all for your help ! It seems to work now.

Foody · ‎07-01-2016

Thank you Tom and JohnHoughton ! I tested both your programs and it works. I have a last question.. I have a big Excel file with more than 500 variables for the food brand. Is it possible to copy-paste the whole Excel file under the instruction Cards/Datalines ? I have a table called 'Limonade', is it possible to replace : data food_list; input id :$10. Sprite1 Sprite2 Sprite99 Sprit100 Schweppe Schwepp2 Schwepp3 Schwepp4 Schwepp5 ; cards; ISP1002 2 4 5 4 7 8 6 6 2 ISP1018 4 6 2 3 8 4 7 86 4 ISP1027 5 8 1 1 5 5 2 2 5 ISP1033 8 7 5 5 3 8 2 1 7 ISP1034 1 5 4 4 4 4 3 3 65 ISP1065 9 4 8 8 5 0 1 1 5 ISP1068 7 8 4 5 441 5 0 0 4 By : data food_list; set limo; /* Limo is the consumption table with Tonic/soda products */ run; Sorry if my question seem to be naive or stupid, I am a beginner in this software. Anyways : a big thanks for your help.

Foody · ‎07-01-2016

Sorry, i forgot to precise the calculations would be done by Sweeteners. This is an example just for the aspartame : - The calculation for the Aspartame intake Idfolder (participants) Sprite1 Sprite2 Sprite99 Sprit100 Schweppe Schwepp2 Schwepp3 ISP1002 2 * 0 4 * 0 5 * 9.3 4 * 1.9 7 * 7.2 8 * 0 6 * 14.1 ISP1018 4 * 0 6 * 0 2 * 9.3 3 * 1.9 8 * 7.2 4 * 0 7* 14.1 ISP1027 5 * 0 8 * 0 1 * 9.3 1 *1.9 5 * 7.2 5* 0 2* 14.1 ISP1033 8 * 0 7 * 0 5 * 9.3 5 * 1.9 3 * 7.2 8* 0 2* 14.1 ISP1034 1 * 0 5 * 0 4 *9.3 4 *1.9 4 *7.2 4* 0 3* 14.1 Concentration [aspartame]=0 Concentration [aspartame]=0 Concentration [aspartame]=9.3 Concentration [aspartame]=1.9 Concentration [aspartame]=7.2 Concentration [aspartame]=0 Concentration [aspartame]=14.1 Concentration (mg/ 100 ml) Aspartame Sprite1 0 Sprite2 0 Sprite99 9,3 Sprit100 1,9 Schweppe 7,2 Schwepp2 0 Schwepp3 14,1 Schwepp4 3,8 Schwepp5 0 Then, i will do the same for the Acesulfame-K intake, Cyclamate intake and so on, for each food products. Sorry it isn't easy to understand.. Thanks

Foody · ‎07-01-2016

Hello, I need any help to try to solver this problem... I want to calculate a sweetener intake = food consumption x sweeteners concentration in food I have a first data base (table A) with the food consumption of 2000 participants (IDFolder). Each column refer to a food product/brand. And in each column, the values are the food consumption. FOOD CONSUMPTION BRANDS Idfolder (participants) Sprite1 Sprite2 Sprite99 Sprit100 Schweppe Schwepp2 Schwepp3 Schwepp4 Schwepp5 ISP1002 2 4 5 4 7 8 6 6 2 ISP1018 4 6 2 3 8 4 7 86 4 ISP1027 5 8 1 1 5 5 2 2 5 ISP1033 8 7 5 5 3 8 2 1 7 ISP1034 1 5 4 4 4 4 3 3 65 ISP1065 9 4 8 8 5 0 1 1 5 ISP1068 7 8 4 5 441 5 0 0 4 In a second data table (table B), I have the concentration in sweeteners (aspartame, acésulfame-K...) for the food products. Concentration (mg/ 100 ml) Aspartame Acesulfame-K Cyclamate Saccharine Sucralose Sprite1 0 0 0 0 0 Sprite2 0 0 0 0 0 Sprite99 9,3 14,3 0,2 0 0 Sprit100 1,9 3,4 0,2 0 0 Schweppe 7,2 8,8 0 0 6,9 Schwepp2 0 13,4 0 0 10,0 Schwepp3 14,1 18,9 0 0 0 Schwepp4 3,8 4,8 0,2 3,8 0 Schwepp5 0 14,8 0,2 0 7,2 I would like to multiply for each food, the food consumption column (1 full column in table A) by the sweeteners concentration in this food (a single case in table B). I don't know how to do and if it is possible... or maybe, i should arrange or modify the dataset B. if someone could help me, i would be very grateful ! Thanks and have a nice day,

Online Status	Offline
Date Last Visited	‎09-12-2016 03:26 AM

Choose colors for variable values in a pie graph

Re: Change names values in graph

Change names values in graph

Re: Multiply a column by a single value from another dataset

Re: Multiply a column by a single value from another dataset

Re: Multiply a column by a single value from another dataset

Multiply a column by a single value from another dataset

Re: Change names values in graph

Choose colors for variable values in a pie graph

Re: Change names values in graph

Change names values in graph

Re: Multiply a column by a single value from another dataset

Re: Multiply a column by a single value from another dataset

Re: Multiply a column by a single value from another dataset

Multiply a column by a single value from another dataset