Recently in the SAS Community Library: Love VS Code? Want to use it with SAS OnDemand for Academics? SAS' @ChrisHemedinger shows you how! ... View more

Hi Everyone,   I am getting below error message when trying to run below code with ENCODING=WLATIN1 from SAS Studio. Can you please suggest on it.  Note : The same code is running fine with ENCODING=UTF-8   DATA T1; var1="aábcčdď"; run;     ... View more

I'd generate the cumulative incidence rate at several specific time points by using proc lifetest. Code was shown below. However, I still get the cumulative incident rate at continuous time points. Could you help me figure it out?   proc lifetest data=data intervals=0 to 12 by 1 method = lt; time Month*death(0)/EVENTCODE=1; strata group; run; ... View more

Brand new to SAS.   I'm doing something that I expect is relatively easy, but I'm struggling to get it right.  The requirement is basic - I'm reading in a long file with many rows, if a record matches a criteria I want it to be shipped to a different "bypass" file that I'll work on in a later process, but it should be removed from the original read-in file. Environment is zOS - input file is defined and passed in via JCL (all working). I get the following errors if I remove my actual logic - if I leave the FILENAME statement in without referencing it there's no errors. ERROR: Invalid logical name. ERROR: Error in the FILENAME statement. ERROR: Invalid file, BYPASS_FILE.   FILENAME BYPASS_FILE BYPASS1; /***********************************************************/ /* READ FILE */ /***********************************************************/ DATA DATAIN; INFILE DATAIN; INPUT @ 00001 RECORD_NUMBER $CHAR8. @ 01769 COMPONENT_STATUS $CHAR1. ; /*******************************************************************/ /* CREATE BYPASS FILE - USED TO STORE RECORDS WHICH HAVE AN */ /* INACTIVE COMPONENT: COMPONENT_STATUS = I */ /*******************************************************************/ IF COMPONENT_STATUS = 'I' THEN DO; FILE BYPASS_FILE; PUT; DELETE; END;     ... View more

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 ... View more