Home

jaypennington

I have a dataset Id system1 system2 system3 system4 1 0001 0001 0001 0002 2 0002 0001 0002 0003 3 0003 0002 0002 0004 4 missing 0001 missing missing I want to the new data set to include a new column which is the most frequent value across these systems. Id system1 system2 system3 system4 mostfrequent countofmostfrequent 1 0001 0001 0001 0002 0001 3 2 0002 0001 0002 0003 0002 2 3 0003 0002 0002 0004 0002 2 4 missing 0001 missing missing 0001 1 Any help you can provide would be greatly appreciated!

smackerz1988

Hi, I'm currently waiting to get access for sas viya but I have a test case scenario to compare between sas eg and sas viya and just want to verify the sas viya code. For bootstrapping in sas eg I have this code proc surveyselect data=data out=BootSamples noprint seed=25 reps=2000 method=urs samprate=1 outhits; run; Am I right that this would be the equivalent code in sas viya or am i missing something? /* Start CAS session and load data into CAS */ cas mysess sessopts=(caslib='casuser'); libname mylib cas sessref=mysess; /* Load example data */ proc casutil; load data=data casout="sample" replace; run; /* Perform bootstrap resampling using the sampling action set */ proc cas; action sampling.srs result=r / table={caslib='casuser', name='sample'} output={casout={caslib='casuser', name='BootSamples', replace=true}} samppct=100 /* Sampling rate of 100% for bootstrap */ method='URS' /* Unrestricted random sampling with replacement */ seed=25 /* Seed for reproducibility */ reps=2000; /* Number of bootstrap replicates */ selection={name='Freq', includeFreq=true}; /* Include frequency counts in the output */ quit; /* Fetch and display some of the bootstrap samples (Optional) */ proc cas; table.fetch / table={caslib='casuser', name='BootSamples'} to=10; quit; /* End CAS session */ cas mysess terminate;

tc

Thanks to a little math help from StackExchange, here's a SAS ODS Graphics Happy Father's Day greeting! * Fun w/SAS ODS Graphics: Happy Father's Day! (Scatter + Polygon + Text Plots) Star vertices algorithm from math.stackexchange.com/questions/3582342/coordinates-of-the-vertices-of-a-five-pointed-star; data star; * Generate points for stars; retain id 0 r1 6 r2 2.5 dad "DAD" xT 0 yT 0; * Star outer radius is 6, inner radius is 2.5; pi=constant("pi"); do pt=1 to 600; * Points for 600 little Unicode stars; xS=-6.25+12.5*ranuni(123); yS=-5.75+12.5*ranuni(456); output; end; xS=.; yS=.; do k=0 to 4; * Points for 1 big polygon star; x=r1*cos(2*pi*k/5+pi/2); y=r1*sin(2*pi*k/5+pi/2); output; x=r2*cos(2*pi*k/5+pi/2+2*pi/10); y=r2*sin(2*pi*k/5+pi/2+2*pi/10); output; end; ods graphics / reset width=5in height=5in noborder; * Make Dad a star!; proc sgplot noautolegend aspect=1 noborder nowall pad=0; styleattrs backcolor=navy; symbolchar name=uniStar char='2605'x; * Unicode value for 5-pointed star; scatter x=xS y=yS / markerattrs=(symbol=unistar color=White size=24pt); * Plot little unicode stars; polygon x=x y=y id=id / fill fillattrs=(color=cxd9d9d9) dataskin=crisp; * Plot big polygon star; text x=xT y=yT text=dad / contributeoffsets=none textattrs=(size=48pt color=navy weight=bold) contributeoffsets=none; * "DAD"; xaxis display=none values=(-6.25 6.25) offsetmin=.01 offsetmax=.01; * Hide axes; yaxis display=none values=(-5.75 6.75) offsetmin=.01 offsetmax=.01; run;

Lucasmarques94

Boa tarde, tenho duas tabelas e gostaria de gerar/exportar um arquivo único, em que, cada tabela ficasse em uma aba do excel. Como fazer este procedimento?

r0sner

Hey SAS Community, I am new to SAS and would appreciate any advice on this topic. For a university project, I need to calculate the expected sales value for the upcoming months after my dataset runs out. The dataset includes Total_amt , which contains the transaction values, and Tran_date , which specifies the dates of the transactions. data TransactionsWithSasDate; set Transactions; Tran_date = mdy(Month, Day, Year); format Tran_date date9.; run; proc sql; create table MonthlySales as select intnx('Month', Tran_date, 0, 'Beginning') as Month format=date9., sum(Total_amt) as MonthlySalesValue from TransactionsWithSasDate group by calculated Month; quit; proc arima data=MonthlySales; identify var=MonthlySalesValue(12); estimate p=1 q=1; forecast lead=12 id=Month interval=Month out=ForecastedSalesValue; run; proc sgplot data=ForecastedSalesValue; series x=Month y=MonthlySalesValue / lineattrs=(color=blue) legendlabel="Actual"; series x=Month y=Forecast / lineattrs=(color=red) legendlabel="Forecast"; xaxis label='Month'; yaxis label='Monthly sales value'; title 'Monthly Sales Trend and Forecast'; run; I double-checked my code, but I am not sure if it is correct because the output graph looks a little off. Any advice on this topic would be highly appreciated! Greetings, Johannes