About Newbie_sas_YR

Newbie_sas_YR · ‎11-04-2020

The problem I was experiencing was because the Y2 axis variable came in as character. SO, the axis was not in ascending order. Thank you!

Newbie_sas_YR · ‎10-30-2020

The Y2 axis values are not in ascending order and strangely they have the same values of _M_count variable for each date(x-axis). The Y- axis(S-Count) is not doing that just with the _M_count. I also output only graph with just series x=date y=_M_Count and that is still happening with _M_Count. Is it something to do with the way the Dataset is?

Newbie_sas_YR · ‎10-29-2020

Thank You. I have attached the Dataset sample and the Query and the Output. I have 4 sheets with different data and the 5th sheet starts the SGPLOT produce with the By - Group Variable .There is Y2- Axis -1. It is not sorted in ascending order like the Y- Axis. And if you observe the values are the same as the column values- Mbr_Count. How can I fix it.I do not want to specify values because each by-variable has different range ..unless there is a way of working around that. 2. I have already tried that the sheet Names are the By- Group variable names and that is not working. Any help is Appreciated. TIA.

Newbie_sas_YR · ‎10-29-2020

This is the Dataset: data WORK.NEW1; infile datalines dsd truncover; input Date:DATE9. cli:$5. sbr_count:$5. _Mbr_Count:$5.; datalines; 01MAR2020 00090 1941 3899 02MAR2020 00090 1938 3885 09MAR2020 00090 1933 3876 16MAR2020 00090 1933 3874 23MAR2020 00090 1936 3874 30MAR2020 00090 1936 3874 06APR2020 00090 1936 3868 13APR2020 00090 1936 3867 20APR2020 00090 1941 3868 27APR2020 00090 1941 3868 04MAY2020 00090 1942 3862 11MAY2020 00090 1943 3862 18MAY2020 00090 1939 3845 25MAY2020 00090 1940 3850 ...... . . . . . . . . . . . . . . . . . . 01MAR2020 00445 3965 7907 . . 02MAR2020 00445 3970 7916 09MAR2020 00445 3979 7938 16MAR2020 00445 3985 7951 23MAR2020 00445 3991 7967 30MAR2020 00445 4001 7989 06APR2020 00445 3936 7855 13APR2020 00445 3944 7869 20APR2020 00445 3954 7881 27APR2020 00445 3969 7905 04MAY2020 00445 3915 7802 11MAY2020 00445 3924 7814 18MAY2020 00445 3936 7832 25MAY2020 00445 3940 7836 ;;

Newbie_sas_YR · ‎10-28-2020

A Newbie esp in SAS Grahs- I am using SGPLOT to get the graphs for 2 variables. Code is as follows: 1.The Y axis is fine but, the y2-axis values are the same as the variable values and Y2 Axis is not ordered and crowded. 2. Trying to output each graph into separate excel sheet and want the sheet name to be the "By-Variable"- Not able to get the sheet names correct. 3. X-Axis formatting not working right. - TIA proc sgplot data=new2; styleattrs datacolors=(red blue); xaxis type=discrete; Y2AXIS TYPE=DISCRETE; series x=date y=s_count / datalabel datalabelattrs=(size=12pt)lineattrs=(color=red thickness=3px) legendlabel = 'SCount' by cvar; series x=date y=_M_Count / DATALABEL datalabelattrs=(size=12pt)lineattrs=(color=blue thickness=3px) legendlabel = 'MCount' y2axis; by cvar; y2axis label = "Member Count " display=(noline) grid; yaxis label = "Acc Count " display=(noline) grid; xaxis interval=MONTH label=' ' valuesformat=MONYY7. minor minorcount=120; xaxis label = ' ';

Online Status	Offline
Date Last Visited	‎11-09-2020 02:21 PM

Re: SGPLOT- Y axis values same as the variable values and By-Variable ...

Re: SGPLOT- Y axis values same as the variable values and By-Variable ...

Re: SGPLOT- Y axis values same as the variable values and By-Variable ...

Re: SGPLOT- Y axis values same as the variable values and By-Variable ...

SGPLOT- Y axis values same as the variable values and By-Variable as S...

Re: SGPLOT- Y axis values same as the variable values and By-Variable ...

Re: SGPLOT- Y axis values same as the variable values and By-Variable ...

Re: SGPLOT- Y axis values same as the variable values and By-Variable ...

Re: SGPLOT- Y axis values same as the variable values and By-Variable ...

SGPLOT- Y axis values same as the variable values and By-Variable as S...