Arimitra Tracker

Re: Can SAS plot more than 36 points on X-axis

Arimitra — Mon, 03 Aug 2015 14:07:03 GMT

Many Thanks Dan. I am able to create what I intended. All my best wishes and many thanks for helping and enhancing me.

Re: Can SAS plot more than 36 points on X-axis

Arimitra — Fri, 31 Jul 2015 15:49:06 GMT

SAS 4.3.

proc gplot data=trend_months;

plot fpm * month_number = yearnum_c/ overlay

cframe=white haxis=axis1 vaxis=axis2 annotate=anno_all

autovref LVREF=1 CVREF=bgr wvref=1;

format month_number dataord.
FPM &s_format;

run;

quit; The dataset month_number has all distinct month numbers from 1 to 48. It is showing fine till 36, as I am using the first letter of evcery month and then annotating. Did I confuse you? Apologies.

Can SAS plot more than 36 points on X-axis

Arimitra — Fri, 31 Jul 2015 15:38:45 GMT

Hi Experts,

I have a data which has 48 rows, (at times it may go higher than 48). These 48 rows are basically months of last 4 years. When I try to plot them in SAS it is not plotting more than 36 months. I could group by years and plot 12 months on x axis, but the trend needs to be continious and all months need to come in a line.

Any help would be much appreciated.

Thanks!

Arimitra Maiti

Re: SAS SQL update iterative tables

Arimitra — Thu, 07 Mar 2013 04:49:54 GMT

Hi Tom,

Attached is the query, I have tried to create separate tables for each subcategory but I found no way to append them. The output is required in one table.

I am unable to attach the excel file data. Not sure if I have explained my query properly

Please help.

Re: SAS SQL update iterative tables

Arimitra — Thu, 07 Mar 2013 03:54:37 GMT

The intent of this query is I dont know how many subcategories to count. so I would need where clause to query which subcategories to count.

Re: SAS SQL update iterative tables

Arimitra — Thu, 07 Mar 2013 03:30:57 GMT

I beg you pardon for the typo error. When I counting the distinct subcategories which I dont know in advance I am using the below:-

proc sql noprint;

select count(distinct Subcategory)

into :n

from candy_sales_summary;

select distinct(Subcategory)

into :C1 - :C%left(&n)

from candy_sales_summary;

quit;

SAS SQL update iterative tables

Arimitra — Thu, 07 Mar 2013 03:26:56 GMT

Hi All,

I have a table of 1500 observations with Subcategory and their Sales value. I want to find out the count of each subcategory group by subcategory in one table.

In total there are 6 unique subcategories.

proc sql noprint;

count(distinct Subcategory)

candy_sales_summary;

distinct(Subcategory)

:C1 - :C%left(&n)

candy_sales_summary;

;

%put &n;

%put &C3;

I am unable to complete the below code.

%macro calc;
%let i = &n;
%let j = %eval(&n - 1);
%do %until (&i ge &j);
proc sql;
create table Test as
select Subcategory,count(Subcategory) as Units
from candy_sales_summary
where Subcategory in ("&&C&i")
group by Subcategory

union all

select Subcategory,count(Subcategory) as Units
from candy_sales_summary
where Subcategory in ("&&C&j")
group by Subcategory
;
quit;
run;
%end;
%mend calc;
%calc;

Is there any way in sql where I can iteratively append the count of each subcategory in one table

For example when I run this, I get count of only two, when I need all 6 in one table

proc sql;

select Subcategory,count(Subcategory) as Units

from candy_sales_summary

where Subcategory in ('Mixed')

group by Subcategory

union all

select Subcategory,count(Subcategory) as Units

from candy_sales_summary

where Subcategory in ('Gum')

group by Subcategory

;

quit;

Please help