About stat_sas

stat_sas · ‎06-10-2014

proc sort data=have; by color date; run; data want; set have; if mod(_n_,4)=1 then grp+1; run; proc sql; select color, sum(value) from want where grp in (1,3) group by color,grp; quit;

stat_sas · ‎06-09-2014

Try this and you will get the correct numbers. In excel file you deleted some of the data points (10) and these were imported as part of sas dataset. proc freq data=have (where=(flowblr1 ne ' ')); table flowblr1; run;

stat_sas · ‎06-09-2014

First I am trying to understand how hourly plotted data on the graph can have multiple seasonality factors. If there is some seasonality in the data it should be hourly not daily, montly or daily unless there is some method which can sum up 24 hours to one day, 7 days to one week etc. on the graph which does not seem to be a possibility. May be other experts can suggest some solution for this sort of problem.

stat_sas · ‎06-09-2014

After plotting your hourly data, how do you determine daily, monthly, yearly seasonality?

stat_sas · ‎06-09-2014

What is the time interval for your data like daily,monthly, yearly?

stat_sas · ‎06-09-2014

Hi, libname new 'C:\Users\Danny\Documents\My SAS Files\9.3'; /* new is the library name assigned to the folder where you have placed your file */ data question03; /* Temporary sas file */ set new.question03; /* reference to the permanent sas datset question03 */ run; proc print data=question03; run;

stat_sas · ‎06-08-2014

Are you normalizing dependent variable or independent variables?

stat_sas · ‎06-08-2014

data a; infile datalines missover; input a :$7. b $7.; datalines; 1234123 2345234 4321432 ; run; proc sql; update a set b=input(transtrn(a,substr(a,3,5),'aaaaa'),$7.) /*set b=substr(a,1,2)||'aaaaa' */ where a is not missing; quit;

stat_sas · ‎06-08-2014

Okay, you can use this syntax to standardize variable. Independent variables in regression usually become in different units (kgs, meters etc.) so we convert them into comaptible units by stadardizing them to have mean equal to zero and standard deviation 1. Hope this helps. proc stdize data=have out=want method=range; var var; run;

stat_sas · ‎06-08-2014

Hi, Do you want to standardize variable using range?

stat_sas · ‎06-07-2014

proc sql; select distinct quote(trim(ticker)) into :firm separated by ',' from have where count=0; select * from have where ticker not in (&firm); quit;

stat_sas · ‎06-06-2014

Hi Loko, You don't need to change the length of variable to 200. This is just a warning that if the values are greater than 7 then it will be truncated. You will get right values in your b variable becasue it is taking only 7 characters which is alright with the defined length of 7. Regards, Naeem

stat_sas · ‎06-06-2014

Hi, If we don't assign length of a variable generated as a result of transtrn function the default length will be 200 bytes. As b is defined with length 7 bytes and value assigned to it through "set b=transtrn(a,substr(a,3,5),'aaaaa') " will be assumed as 200 bytes long. This will generate warning. Try this one to validate. Regards, Naeem data a; infile datalines missover; input a :$7. b $7. c $200.; datalines; 1234123 2345234 4321432 ; run; proc sql; update a set c=transtrn(a,substr(a,3,5),'aaaaa') /*set b=substr(a,1,2)||'aaaaa' */ where a is not missing; quit;

stat_sas · ‎06-06-2014

data want; date1='01Jan2014'd; date2='14Feb2014'd; months=intck('month',date1,date2) + ((intck('days',date1,date2)/31)-1); run;

stat_sas · ‎06-05-2014

Hi, Try this syntax. Code is based on your mentioned requirements. Regards, Naeem data have; input id1 ID1_value_one ID1_VALUE_TWO id2 ID2_VALUE_ONE ID2_VALUE_TWO DEF1 $ DEF2_desc $; datalines; 1 1010 10 2 1251 381 xxx Definition of XXX 1 1010 10 3 1251 640 xxx Definition of XXX 1 1010 10 4 1424 434 xxx Definition of XXX 1 2100 2 5 1200 13 XYZ Definition of XYZ 1 2200 4 6 2300 14 XYZ Definition of XYZ ; data one; set have (keep=id1 ID1_value_one ID1_VALUE_TWO DEF1 DEF2_desc rename=(id1=id ID1_value_one=value ID1_VALUE_TWO=value1)); if _n_=1 then new_id=1; else new_id=_n_+0.5; run; data two; set have (keep=id2 ID2_VALUE_ONE ID2_VALUE_TWO DEF1 DEF2_desc rename=(id2=id ID2_value_one=value ID2_VALUE_TWO=value1)); new_id=id; run; data want(drop=new_id); set one two; by new_id; run;

Online Status	Offline
Date Last Visited	‎02-01-2020 10:06 AM

Re: Averaging count by two variables

Re: How do I Bootstrap a Custom-Made Statistic??

Re: Extracting date, month, year and time from a datetime variable

Re: How do I solve the errors?

Re: t-test after regression by year

Re: Shapiro Wilk Test and ANOVA

Re: Give the Discount to the Last column value

Re: Give the Discount to the Last column value

Re: using proc standardize to put the missing value to zero

Re: Why Proc SQL left join output duplicates values?

Re: Removing a variable conditionally

Re: Removing a variable conditionally

Re: About basic keyword in SAS

Re: Missing observations in Multivariate Regression

Re: Missing observations in Multivariate Regression

Re: Compute stock returns from prices

Re: Join using a partial match

Re: Grouping by character variable

Re: Extracting date, month, year and time from a datetime variable

Re: How do I solve the errors?

Re: Running total

Re: SAS 9.3 proc means problem

Re: forecasting Procedure for multiple seasonality

Re: forecasting Procedure for multiple seasonality

Re: forecasting Procedure for multiple seasonality

Re: Brand New SAS Student

Re: Normalize A Variable

Re: Warning message

Re: Normalize A Variable

Re: Normalize A Variable

Re: help with creating a new dataset

Re: Warning message

Re: Warning message

Re: How to calculate number of months and weeks between 2 dates?

Re: transpose a table in a proper way.