cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Abdulla1
‎02-10-2023
  • 44 Posts
  • 32 Likes Given
  • 2 Solutions
  • 8 Likes Received

Re: is it possible to produce bar chart with both frequency and percen...

by Quartz | Level 8 in SAS Programming
‎11-18-2022 09:50 AM
‎11-18-2022 09:50 AM
y2axis that is just a great option. thank you .   ... View more

Re: is it possible to produce bar chart with both frequency and percen...

by Quartz | Level 8 in SAS Programming
‎11-17-2022 01:34 PM
‎11-17-2022 01:34 PM
i think in order for it to work with the percentage per type we need to write the value inside each colored portion cause otherwise the percent access  needs a different bar as the percentage scale changes along the type I found a way of adding the percent (out of total) in color like this but this losses the information of what each section of the bar represent (origin data in my example). I wish I can keep write the percentage (and adjust it to pertype) value in the boxes instead of the frequency. code : PROC SGPLOT DATA = sashelp.cars; VBAR type /group=origin COLORSTAT=PCT SEGLABEL; RUN;     ... View more

Re: is it possible to produce bar chart with both frequency and percen...

by Quartz | Level 8 in SAS Programming
‎11-17-2022 11:44 AM
‎11-17-2022 11:44 AM
if it is possible to do it per type that would be great. 😄   ... View more

is it possible to produce bar chart with both frequency and percentage...

by Quartz | Level 8 in SAS Programming
‎11-17-2022 10:13 AM
‎11-17-2022 10:13 AM
Hello all I've created the bar chart below, and I wonder if it is possible to let the bar chart show be both the frequency and the percentage ? code" PROC SGPLOT DATA = sashelp.cars; VBAR type /group=origin; RUN; " function output: wanted output examples thanks   ... View more

Re: problem with showing the format

by Quartz | Level 8 in SAS Programming
‎11-15-2022 02:25 PM
‎11-15-2022 02:25 PM
thank you Reeza, may you explain the $1. below what is that ?   proc print data=mysurvey1; var q1-q3; format q1-q3 $1.; run;   ... View more

Re: problem with showing the format

by Quartz | Level 8 in SAS Programming
‎11-15-2022 02:20 PM
‎11-15-2022 02:20 PM
that explains it all. thank you very much.😀😀😀 ... View more

Re: problem with showing the format

by Quartz | Level 8 in SAS Programming
‎11-15-2022 02:10 PM
‎11-15-2022 02:10 PM
that is probably the easiest way of doing it, but it will be harder for me to adjusting some of the values, such as "normal" which doesn't have a number before it and I would code it later as 2. thanks for the suggestion   ... View more

Re: problem with showing the format

by Quartz | Level 8 in SAS Programming
‎11-15-2022 01:53 PM
‎11-15-2022 01:53 PM
lol they are not in the actual data for sure. but thanks for notifying me.   ... View more

Re: problem with showing the format

by Quartz | Level 8 in SAS Programming
‎11-15-2022 01:48 PM
‎11-15-2022 01:48 PM
Thank you Tom That is helpful. may you help me on how to read it the data using the informat like on a data that was already defined (has set statement instead of input). I tired the code data mysurvey2; set mysurvey1; format q1-q3 qanswer.; run; ... View more

Re: problem with showing the format

by Quartz | Level 8 in SAS Programming
‎11-15-2022 12:36 PM
‎11-15-2022 12:36 PM
I have just tired to replace invalue with value in the proc format step. yet I'm still getting the same answer. I also tried to replace the format with informat in the proc print step but now I'm seeing my original data. is that what you meant? ... View more

problem with showing the format

by Quartz | Level 8 in SAS Programming
‎11-15-2022 12:12 PM
‎11-15-2022 12:12 PM
hello all I have  the following data set and I'm trying to switch it's value using proc format but it is not working as expected   data mysurvay1; input q1 $ q2 $ q3 $; DATALINES; 1_strogly_agree 4_not_important 3_very_low 1_strogly_agree 3_somewhat_importatnt 9_left_blank 2_agree 9_left_blank 9_left_blank 4_disagree 2_important normal 9_left_blank 2_important 1_high agree 3_somewhat_importatnt 2_normal ; run; proc format; invalue $qanswer "1_high" =1 "1_strogly_agree" =1 "2_agree" =2 "2_important" =2 "2_normal" =2 "3_somewhat_importatnt"=3 "3_very_low" =3 "4_disagree" =4 "4_not_important" =4 "9_left_blank" = . other =999 ; run; proc print data=mysurvay1; format q1-q3 $qanswer.; run; expected output q1 q2 q3 1 4 3 1 3 . 2 . . 4 2 999 . 2 1 999 3 2   but what I'm getting is may you help me with that ... View more

Re: adjusting the data based on their rows.

by Quartz | Level 8 in SAS Programming
‎04-08-2022 09:44 AM
‎04-08-2022 09:44 AM
Thank you ballardw That was very helpful. ... View more

Re: adjusting the data based on their rows.

by Quartz | Level 8 in SAS Programming
‎04-08-2022 09:39 AM
1 Like
‎04-08-2022 09:39 AM
1 Like
@Abdulla1 wrote: I want to drop the prod# if it has ind5 and ind6 identical. (which will drop prod1 prod2 and Prod6) I figured out the following way of doing it. data mydata; input indix $ prod1-prod6; cards; ind1 0.4 5 2 3 11 13 ind2 1 7 10 20 15 25 ind3 4 2 6 10 13 24 ind4 5 6 15 27 31 22 ind5 18 1 28 38 11 12 ind6 18 1 22 39 13 12 ind7 10 2 19 40 10 11 ind8 11 9 40 70 2 10 ; run; proc transpose data=mydata(RENAME=(indix=_NAME_)) out=TEMPDATA1;run; data TEMPDATA2; set TEMPDATA1; if ind5=ind6 THEN DELETE; RUN; proc transpose data=TEMPDATA2 out=WANT(rename=(_NAME_=indix));run; ... View more

Re: adjusting the data based on their rows.

by Quartz | Level 8 in SAS Programming
‎04-06-2022 12:26 PM
‎04-06-2022 12:26 PM
I'm not sure why the code appeared in this way. please find the data code below: data mydata; input indix $ prod1-prod6; cards; ind1 0.4 5 2 3 11 13 ind2 1 7 10 20 15 25 ind3 4 2 6 10 13 24 ind4 5 6 15 27 31 22 ind5 18 1 28 38 11 12 ind6 18 1 22 39 13 12 ind7 10 2 19 40 10 11 ind8 11 9 40 70 2 10 ; run; ... View more

adjusting the data based on their rows.

by Quartz | Level 8 in SAS Programming
‎04-06-2022 12:25 PM
1 Like
‎04-06-2022 12:25 PM
1 Like
I have a data that I'm trying to adjust based on the row number, or say row name,  say I have the data below   data mydata; input indix $ prod1-prod6; cards; ind1 0.4 5 2 3 11 13 ind2 1 7 10 20 15 25 ind3 4 2 6 10 13 24 ind4 5 6 15 27 31 22 ind5 18 1 28 38 11 12 ind6 18 1 22 39 13 12 ind7 10 2 19 40 10 11 ind8 11 9 40 70 2 10 ; run;   I want to drop the prod# if it has ind5 and ind6 identical. (which will drop prod1 prod2 and Prod6) moreover, I have a dataset that has more than 100 line. is there a quick way to keep only the first 6 rows and delete the rest.   ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎02-10-2023 03:11 AM
Likes given to
Likes from
View All
Quick links