About wil1212

wil1212 · ‎12-16-2022

Thank you so much! This works.

wil1212 · ‎12-14-2022

It's a variable in the dataset. The billing2023 table will not be created until Jan 2023 (billing for services used in Dec 2022). I thought about creating an empty table for Billing2023, but I want to automate this process and not have to update it each month. I want it to only use the Billing2023 once it has been created. My data has a date variable for the 1st of each month.

wil1212 · ‎12-14-2022

The billing2023 table will not be created until Jan 2023 (billing for services used in Dec 2022). I thought about creating an empty table for Billing2023, but I want to automate this process and not have to update it each month. I want it to only use the Billing2023 once it has been created. My data has a date variable for the 1st of each month.

wil1212 · ‎12-13-2022

Hello, I need to sum revenue each month to accumulate the revenue for the year. The revenue is reported from Feb of the current year to Jan of the next year. So, to sum revenue for 2022, I need two billing tables (Billing2022 and Billing 2023). I am automating this code using Marco variables, so I do not have to update the dates each year. How do I create code that tells SAS to use the Billing2022 table if the monthyear is >= Feb2022? But if the monthyear = Jan2023, I want to combine the two tables (Billing2022 and Billing 2023) together. I am familiar with SAS and SQL. Thank you.

wil1212 · ‎11-22-2016

I would like to merge three datasets A, B, and C to find all the obs in A that do not match B and C. B and C are both subsets of A. Obs in B and C do not match each other. I have tried the code below and many other logic test, but I cannot seem to get the right output. Any help would be appreciated. data want; merge A(in= inA) B(in=inB) C(in=inC); by id date; if not inA or (not inB and not inC) then output want; run;

wil1212 · ‎01-25-2016

I am using Windows 12. The file has 34 variables, and I am unsure how many rows. proc import datafile="D:\projects\Billing History\ResBillHis2015.csv" out=ResBillHis2015 dbms=csv replace; namerow=2; datarow=3; run;

wil1212 · ‎01-25-2016

Hello, I am trying to import a large CSV file into SAS. The variable names start on row 2 and data starts on row 3. How can I get SAS to start reading at row 2? I cannot open the file and delete the first row, because the file is to large for excel. I have also tried namerow=, but it doesn't work. Any help would be appreciated.

wil1212 · ‎11-05-2015

Hello all, I am new to SAS, and I would like help creating code for percent change bins, and it also counts the number of bills within each bin and the average of the old and new bills. The bins range from < -0.2 to >= 0.2 increasing by 0.05. Any help would be greatly appreciated. < -0.2 -0.2 to -0.15 -0.15 to -0.1 So on. Input OldBill NewBill PercentChange $124.10 $149.13 20% $107.63 $132.29 23% $97.68 $130.62 34% $147.68 $161.38 9% $212.68 $190.74 (10%) $376.64 $266.43 (29%) $425.59 $292.86 (31%) $383.71 $271.55 (29%) $378.74 $269.02 (29%) $223.95 $190.27 (15%) $119.50 $139.74 17% $121.51 $143.21 18% $21.58 $23.89 11% $27.91 $22.82 (18%) $26.23 $22.03 (16%) Output Percent Change NumberBills AvgOldBill AvgNewBill <-0.2 4 $391.17 $274.96 -0.2--0.15 3 $92.70 $78.37 -0.15--0.1 1 $212.68 $190.74 0.05-0.1 1 $147.68 $161.38 0.1-0.15 1 $21.58 $23.89 0.15-0.2 2 $120.51 $141.47 >0.2 3 $109.80 $137.35

wil1212 · ‎10-07-2015

Thanks so much. Another question, I do not want to set a limit in the do statement. I would like for it to equal the number of observations in my dataset. Can I exclude the "to 100" part?

wil1212 · ‎10-07-2015

Hello, I am trying to create a variable that contains a letter and an incremented numeric value (e.g T1, T2, T3,...Tn). Does it have to be in a certain format? I have tired everything I know, but can't seem to figure it out. I am sure it is super simple. Any help would be greatly appreciated.

wil1212 · ‎08-18-2015

Hello, I would like help finding the max value for each meter. My data is below. Meter date hr1 hr2 hr3 hr4 hr5 123 1/1/2015 2 15 6 7 13 234 1/1/2015 40 10 3 1 0 345 1/1/2015 12 15 6 24 12 456 1/1/2015 2 18 5 6 11 567 1/1/2015 2 10 33 1 21 And I want it to look like... Meter date MaxVal 123 1/1/2015 15 234 1/1/2015 40 345 1/1/2015 24 456 1/1/2015 18 567 1/1/2015 33

wil1212 · ‎05-04-2015

Sorry for the confusion. I'm new to SAS and haven't been to training yet. Still learning the software. I'm not familiar with the code either...training soon! But Casey, that was the help I needed. I knew how to filter the data for 2013, but I did not think to go back and join the tables to get the additional records. Thanks SO much.

wil1212 · ‎05-01-2015

Account Bill_Date Address Thanks so much for replying! But my data looks more like the ex below. I want to exclude accounts 2 because it does not have 12 consecutive bills for 2013. I also want to exclude account 3 because it was not at the same address in 2013. In the end, I would like to select all the records for account 1 because it was at the same address and had 12 bills in 2013. I should show all 17 records for account 1. 1 Nov-2012 1 addr 1 Dec-2012 1 addr 1 Jan-2013 1 addr 1 Feb-2013 1 addr 1 Mar-2013 1 addr 1 Apr-2013 1 addr 1 May-2013 1 addr 1 Jun-2013 1 addr 1 Jul-2013 1 addr 1 Aug-2013 1 addr 1 Sep-2013 1 addr 1 Oct-2013 1 addr 1 Nov-2013 1 addr 1 Dec-2013 1 addr 1 Jan-2014 1 addr 1 Feb-2014 1 addr 1 Mar-2014 1 addr 2 Sep-2013 2 addr 2 Oct-2013 2 addr 2 Nov-2013 2 addr 2 Dec-2013 2 addr 2 Jan-2014 2 addr 2 Feb-2014 2 addr 2 Mar-2014 2 addr 3 Jan-2012 3 addr 3 Feb-2012 3 addr 3 Mar-2012 3 addr 3 Apr-2012 3 addr 3 May-2012 3 addr 3 Jun-2012 3 addr 3 Jul-2012 3 addr 3 Aug-2012 3 addr 3 Sep-2012 3 addr 3 Oct-2012 3 addr 3 Nov-2012 3 addr 3 Dec-2012 3 addr 3 Jan-2013 3 addr 3 Feb-2013 3 addr 3 Mar-2013 3 addr 3 Apr-2013 3 addr 3 May-2013 3 addr 3 Jun-2013 3 addr 3 Jul-2013 10 addr 3 Aug-2013 10 addr 3 Sep-2013 10 addr 3 Oct-2013 10 addr 3 Nov-2013 10 addr 3 Dec-2013 10 addr 3 Jan-2014 10 addr 3 Feb-2014 10 addr 3 Mar-2014 10 addr

wil1212 · ‎05-01-2015

Hello, I would like assistance with setting up a filter in EG 6.1. I have thousands of records with billing information for 3 years. I would like to filter the data to remove all accounts that did not have 12 consecutive bills in a year at the same location. My problem is I'm not sure how to filter the data based off a condition. The condition: if account had 12 consecutive bills in 2014 at the same location, list all billing records for all 3 years for that account. The billing date is formatted as a date. Any help would be greatly appreciated.

Online Status	Offline
Date Last Visited	‎12-16-2022 11:40 AM

Re: Use existing table or combine tables based on year

Re: Use existing table or combine tables based on year

Re: Use existing table or combine tables based on year

Use existing table or combine tables based on year

Merging 3 datasets to find no matches

Re: Proc Import to Read CSV File Variable Names Start on Row 2

Proc Import to Read CSV File Variable Names Start on Row 2

Creating Bins and Calculating Average # of Bills

Re: Increment a Character and Numeric Value

Increment a Character and Numeric Value

Re: Use existing table or combine tables based on year

Re: Use existing table or combine tables based on year

Re: Use existing table or combine tables based on year

Use existing table or combine tables based on year

Merging 3 datasets to find no matches

Re: Proc Import to Read CSV File Variable Names Start on Row 2

Proc Import to Read CSV File Variable Names Start on Row 2

Creating Bins and Calculating Average # of Bills

Re: Increment a Character and Numeric Value

Increment a Character and Numeric Value

How to find Max observation?

Re: Help filtering records for 12 consecutive months

Re: Help filtering records for 12 consecutive months

Help filtering records for 12 consecutive months

SAS Analytics Explorers