cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Eugenio211
‎01-03-2024
  • 92 Posts
  • 8 Likes Given
  • 0 Solutions
  • 7 Likes Received

Re: Proc Report

by Quartz | Level 8 in SAS Programming
‎07-08-2021 08:59 AM
‎07-08-2021 08:59 AM
Thank you.  I did that previously, however when it comes to the final output, the calculation of the 'Total' for 'Conversion Rate' is off, is there a work around for this one?   Jan 2021 Preapprovals Conversion Conversion Rate 47599 2467 757.16%   proc report data=LOCTest_List; columns dm location campaign_month , (customer_count converted ConversionRate); define dm/group; define location/group; define campaign_month/across 'LOC Preapprovals' order=data; define customer_count/sum 'Preapprovals'; define converted/sum 'Conversion'; define ConversionRate/sum 'Conversion Rate'; break after DM/Summarize; rbreak after/Summarize; compute after dm; call define (_ROW_,"Style","Style=[fontweight=bold]"); DM = 'Subtotal'; endcomp; compute after; call define (_ROW_,"Style","Style=[fontsize=3 fontweight=bold]"); DM = 'Total'; endcomp; run; ... View more

Proc Report

by Quartz | Level 8 in SAS Programming
‎07-08-2021 08:34 AM
‎07-08-2021 08:34 AM
Hi - I have this code  below and what I want to do is to add another column by dividing 'converted' over 'customer count'.  is this possible? thanks.   proc report data=Test_List; columns dm location campaign_month, (customer_count converted); define dm/group; define location/group; define campaign_month/across 'LOC Preapprovals' order=data; define customer_count/sum 'Preapprovals'; define converted/sum 'Conversion'; break after DM/Summarize; rbreak after/Summarize; compute after dm; call define (_ROW_,"Style","Style=[fontweight=bold]"); DM = 'Subtotal'; endcomp; compute after; call define (_ROW_,"Style","Style=[fontsize=3 fontweight=bold]"); DM = 'Total'; endcomp; run; ... View more

Proc Report

by Quartz | Level 8 in SAS Procedures
‎07-07-2021 12:32 PM
1 Like
‎07-07-2021 12:32 PM
1 Like
Hello, I wanted to add sub totals and Total to my proc report steps. I am showing this in an excel format.  below is the code that I have ods excel file="directory path\Test_List; proc report data=Test_List; columns dm location campaign_month, (customer_count converted Conversion_Rate); define dm/group; define location/group; define campaign_month/across order=data; define customer_count/sum 'Preapprovals'; define converted/sum 'Conversion'; run; ods excel close;   Current Output:   Jan 2021 Feb 2021 Mar 2021 Apr 2021 Jun 2021 DM LOCATION Preapprovals Conversion Conversion_Rate Preapprovals Conversion Conversion_Rate Preapprovals Conversion Conversion_Rate Preapprovals Conversion Conversion_Rate Preapprovals Conversion Conversion_Rate DM2 1 533 31 6% 22 8 36% 503 16 3% 30 6 20% 485 6 1%   2 352 18 5% 19 3 16% 330 15 5% 29 7 24% 337 2 1%   3 576 18 3% 27 2 7% 529 13 2% 36 1 3% 527 3 1%   4 430 24 6% 12 2 17% 400 18 5% 18 4 22% 372 5 1%   5 666 32 5% 24 5 21% 612 27 4% 27 3 11% 601 5 1%   6 473 26 5% 11 3 27% 437 18 4% 26 5 19% 436 8 2%   7 216 13 6% 10 7 70% 191 12 6% 8 5 63% 166 3 2%   8 377 25 7% 16 4 25% 343 15 4% 23 3 13% 346 1 0%   9 352 25 7% 6 2 33% 307 8 3% 23 2 9% 316 5 2% DM3 10 349 13 4% 8 3 38% 332 15 5% 9 1 11% 304 1 0%   11 497 17 3% 14 3 21% 477 17 4% 22 2 9% 431 4 1%   12 782 30 4% 32 6 19% 729 19 3% 51 9 18% 693 6 1%   13 605 24 4% 19 3 16% 560 12 2% 38 3 8% 517 3 1%   14 719 55 8% 33 5 15% 626 28 4% 47 9 19% 608 9 1%   15 347 14 4% 8 3 38% 331 15 5% 16 4 25% 327 0 0%   16 336 19 6% 19 3 16% 309 7 2% 34 1 3% 332 2 1% DM4 17 204 10 5% 7 3 43% 181 5 3% 8 1 13% 169 2 1%   18 136 6 4% 5 2 40% 132 5 4% 5 2 40% 107 0 0%   19 110 3 3% 2 1 50% 104 3 3% 5 2 40% 80 1 1%   20 111 1 1% 3 0 0% 106 3 3% 8 1 13% 91 0 0%   21 86 1 1% 6 3 50% 83 2 2% 3 1 33% 78 0 0% Desired Ouput:   Jan 2021 Feb 2021 Mar 2021 Apr 2021 Jun 2021 DM LOCATION Preapprovals Conversion Conversion_Rate Preapprovals Conversion Conversion_Rate Preapprovals Conversion Conversion_Rate Preapprovals Conversion Conversion_Rate Preapprovals Conversion Conversion_Rate DM2 SubTotal                                 1 533 31 6% 22 8 36% 503 16 3% 30 6 20% 485 6 1%   2 352 18 5% 19 3 16% 330 15 5% 29 7 24% 337 2 1%   3 576 18 3% 27 2 7% 529 13 2% 36 1 3% 527 3 1%   4 430 24 6% 12 2 17% 400 18 5% 18 4 22% 372 5 1%   5 666 32 5% 24 5 21% 612 27 4% 27 3 11% 601 5 1%   6 473 26 5% 11 3 27% 437 18 4% 26 5 19% 436 8 2%   7 216 13 6% 10 7 70% 191 12 6% 8 5 63% 166 3 2%   8 377 25 7% 16 4 25% 343 15 4% 23 3 13% 346 1 0%   9 352 25 7% 6 2 33% 307 8 3% 23 2 9% 316 5 2% DM3 SubTotal                                 10 349 13 4% 8 3 38% 332 15 5% 9 1 11% 304 1 0%   11 497 17 3% 14 3 21% 477 17 4% 22 2 9% 431 4 1%   12 782 30 4% 32 6 19% 729 19 3% 51 9 18% 693 6 1%   13 605 24 4% 19 3 16% 560 12 2% 38 3 8% 517 3 1%   14 719 55 8% 33 5 15% 626 28 4% 47 9 19% 608 9 1%   15 347 14 4% 8 3 38% 331 15 5% 16 4 25% 327 0 0%   16 336 19 6% 19 3 16% 309 7 2% 34 1 3% 332 2 1% DM4 SubTotal                                 17 204 10 5% 7 3 43% 181 5 3% 8 1 13% 169 2 1%   18 136 6 4% 5 2 40% 132 5 4% 5 2 40% 107 0 0%   19 110 3 3% 2 1 50% 104 3 3% 5 2 40% 80 1 1%   20 111 1 1% 3 0 0% 106 3 3% 8 1 13% 91 0 0%   21 86 1 1% 6 3 50% 83 2 2% 3 1 33% 78 0 0%     Thanks a lot. ... View more

Re: Data Step / Query

by Quartz | Level 8 in SAS Programming
‎06-29-2021 11:19 AM
‎06-29-2021 11:19 AM
Thanks Paige. ... View more

Re: Data Step / Query

by Quartz | Level 8 in SAS Programming
‎06-29-2021 10:52 AM
‎06-29-2021 10:52 AM
I am counting the number of Customers and Converted for each month and translating it to a column.  it should be blank if there is no count for that CAMPAIGN_MONTH.   here is a new example, I added the Customer_Count and Converted columns.  Thanks a lot.   DM LOCATION CAMPAIGN_DATE CUSTOMER_COUNT CONVERTED CAMPAIGN_MONTH FEB19_CUSTOMERS FEB19_CONVERTED APR19_CUSTOMERS APR19_CONVERTED JUL19_CUSTOMERS JUL19_CONVERTED SEP19_CUSTOMERS SEP19_CONVERTED OCT19_CUSTOMERS OCT19_CONVERTED JAN20_CUSTOMERS JAN20_CONVERTED JUN20_CUSTOMERS JUN20_CONVERTED JUL20_CUSTOMERS JUL20_CONVERTED AUG20_CUSTOMERS AUG20_CONVERTED SEP20_CUSTOMERS SEP20_CONVERTED OCT20_CUSTOMERS OCT20_CONVERTED NOV20_CUSTOMERS NOV20_CONVERTED DEC20_CUSTOMERS DEC20_CONVERTED JAN21_CUSTOMERS JAN21_CONVERTED FEB21_CUSTOMERS FEB21_CONVERTED MAR21_CUSTOMERS MAR21_CONVERTED APR21_CUSTOMERS APR21_CONVERTED MAY21_CUSTOMERS MAY21_CONVERTED John Smith Store 1 01/26/2021 1 0 Jan 2021                                                     1 0                 John Smith Store 1 02/24/2021 1 0 Feb 2021                                                         1 0             John Smith Store 1 03/18/2021 1 0 Mar 2021                                                             1 0         John Smith Store 1 04/20/2021 1 0 Apr 2021                                                                 1 0     John Smith Store 1 01/08/2020 834 396 Jan 2020                     834 396                                                 John Smith Store 1 07/17/2020 295 47 Jul 2020                             295 47                                         John Smith Store 1 08/20/2020 17 8 Aug 2020                                 17 8                                     John Smith Store 2 09/25/2020 13 3 Sep 2020                                     13 3                                 Jane Doe Store 2 10/22/2020 230 12 Oct 2020                                         230 12                             Jane Doe Store 2 11/11/2020 113 14 Nov 2020                                             113 14                         Jane Doe Store 2 12/09/2020 471 18 Dec 2020                                                 471 18                     Jane Doe Store 2 01/26/2021 533 31 Jan 2021                                                     533 31                 Jane Doe Store 2 02/24/2021 22 8 Feb 2021                                                         22 8             Jane Doe Store 2 03/18/2021 503 16 Mar 2021                                                             503 16         Jane Doe Store 2 04/20/2021 30 6 Apr 2021                                                                 30 6     Jane Doe Store 2 05/11/2021 458 14 May 2021                                                                     458 14 Jane Doe Store 2 01/08/2020 277 135 Jan 2020                     277 135                                                 Jane Doe Store 2 07/17/2020 139 26 Jul 2020                             139 26                                         John Brown Store 3 08/20/2020 15 4 Aug 2020                                 15 4                                     John Brown Store 3 09/25/2020 22 4 Sep 2020                                     22 4                                 John Brown Store 3 10/22/2020 151 5 Oct 2020                                         151 5                             John Brown Store 3 11/11/2020 79 10 Nov 2020                                             79 10                         John Brown Store 3 12/09/2020 288 16 Dec 2020                                                 288 16                     John Brown Store 3 01/26/2021 352 18 Jan 2021                                                     352 18                 John Brown Store 3 02/24/2021 19 3 Feb 2021                                                         19 3             John Brown Store 3 03/18/2021 330 15 Mar 2021                                                             330 15         John Brown Store 4 04/20/2021 29 7 Apr 2021                                                                 29 7     John Brown Store 4 05/11/2021 296 9 May 2021                                                                     296 9 John Brown Store 4 01/08/2020 593 263 Jan 2020                     593 263                                                 John Brown Store 4 07/17/2020 324 40 Jul 2020                             324 40                                         John Brown Store 4 08/20/2020 27 10 Aug 2020                                 27 10                                     Joe Blown Store 4 09/25/2020 19 2 Sep 2020                                     19 2                                 Joe Blown Store 4 10/22/2020 280 13 Oct 2020                                         280 13                             Joe Blown Store 4 11/11/2020 107 4 Nov 2020                                             107 4                         Joe Blown Store 4 12/09/2020 525 16 Dec 2020                                                 525 16                     Joe Blown Store 4 01/26/2021 576 18 Jan 2021                                                     576 18                 Joe Blown Store 4 02/24/2021 27 2 Feb 2021                                                         27 2             Joe Blown Store 4 03/18/2021 529 12 Mar 2021                                                             529 12         Joe Blown Store 5 04/20/2021 36 1 Apr 2021                                                                 36 1     Joe Blown Store 5 05/11/2021 511 10 May 2021                                                                     511 10 Joe Blown Store 5 01/08/2020 502 257 Jan 2020                     502 257                                                 Joe Blown Store 5 07/17/2020 285 61 Jul 2020                             285 61                                         Joe Blown Store 5 08/20/2020 13 6 Aug 2020                                 13 6                                     Joe Blown Store 5 09/25/2020 15 6 Sep 2020                                     15 6                                 Joe Blown Store 5 10/22/2020 214 14 Oct 2020                                         214 14                             Joe Blown Store 5 11/11/2020 101 21 Nov 2020                                             101 21                         Wonder Woman Store 5 12/09/2020 364 20 Dec 2020                                                 364 20                     Wonder Woman Store 5 01/26/2021 430 24 Jan 2021                                                     430 24                 Wonder Woman Store 5 02/24/2021 12 2 Feb 2021                                                         12 2             Wonder Woman Store 6 03/18/2021 400 18 Mar 2021                                                             400 18         Wonder Woman Store 6 04/20/2021 18 4 Apr 2021                                                                 18 4     Wonder Woman Store 6 05/11/2021 355 7 May 2021                                                                     355 7 Wonder Woman Store 6 01/08/2020 629 266 Jan 2020                     629 266                                                 Wonder Woman Store 6 07/17/2020 339 51 Jul 2020                             339 51                                         Wonder Woman Store 6 08/20/2020 18 7 Aug 2020                                 18 7                                     Wonder Woman Store 6 09/25/2020 18 5 Sep 2020                                     18 5                                 Wonder Woman Store 6 10/22/2020 287 12 Oct 2020                                         287 12                             Wonder Woman Store 6 11/11/2020 146 11 Nov 2020                                             146 11                         Wonder Woman Store 6 12/09/2020 576 35 Dec 2020                                                 576 35                     ... View more

Re: Data Step / Query

by Quartz | Level 8 in SAS Programming
‎06-29-2021 09:55 AM
2 Likes
‎06-29-2021 09:55 AM
2 Likes
my bad, here is the sample output.   DM LOCATION CAMPAIGN_MONTH FEB19_CUSTOMERS FEB19_CONVERTED APR19_CUSTOMERS APR19_CONVERTED JUL19_CUSTOMERS JUL19_CONVERTED SEP19_CUSTOMERS SEP19_CONVERTED OCT19_CUSTOMERS OCT19_CONVERTED JAN20_CUSTOMERS JAN20_CONVERTED JUN20_CUSTOMERS JUN20_CONVERTED JUL20_CUSTOMERS JUL20_CONVERTED AUG20_CUSTOMERS AUG20_CONVERTED SEP20_CUSTOMERS SEP20_CONVERTED OCT20_CUSTOMERS OCT20_CONVERTED NOV20_CUSTOMERS NOV20_CONVERTED DEC20_CUSTOMERS DEC20_CONVERTED JAN21_CUSTOMERS JAN21_CONVERTED FEB21_CUSTOMERS FEB21_CONVERTED MAR21_CUSTOMERS MAR21_CONVERTED APR21_CUSTOMERS APR21_CONVERTED MAY21_CUSTOMERS MAY21_CONVERTED John Smith Store 1 Jan 2021                                                     1 0                 John Smith Store 1 Feb 2021                                                         1 0             John Smith Store 1 Mar 2021                                                             1 0         John Smith Store 1 Apr 2021                                                                 1 0     John Smith Store 1 Jan 2020                     834 396                                                 John Smith Store 1 Jul 2020                             295 47                                         John Smith Store 1 Aug 2020                                 17 8                                     John Smith Store 2 Sep 2020                                     13 3                                 Jane Doe Store 2 Oct 2020                                         230 12                             Jane Doe Store 2 Nov 2020                                             113 14                         Jane Doe Store 2 Dec 2020                                                 471 18                     Jane Doe Store 2 Jan 2021                                                     533 31                 Jane Doe Store 2 Feb 2021                                                         22 8             Jane Doe Store 2 Mar 2021                                                             503 16         Jane Doe Store 2 Apr 2021                                                                 30 6     Jane Doe Store 2 May 2021                                                                     458 14 Jane Doe Store 2 Jan 2020                     277 135                                                 Jane Doe Store 2 Jul 2020                             139 26                                         John Brown Store 3 Aug 2020                                 15 4                                     John Brown Store 3 Sep 2020                                     22 4                                 John Brown Store 3 Oct 2020                                         151 5                             John Brown Store 3 Nov 2020                                             79 10                         John Brown Store 3 Dec 2020                                                 288 16                     John Brown Store 3 Jan 2021                                                     352 18                 John Brown Store 3 Feb 2021                                                         19 3             John Brown Store 3 Mar 2021                                                             330 15         John Brown Store 4 Apr 2021                                                                 29 7     John Brown Store 4 May 2021                                                                     296 9 John Brown Store 4 Jan 2020                     593 263                                                 John Brown Store 4 Jul 2020                             324 40                                         John Brown Store 4 Aug 2020                                 27 10                                     Joe Blown Store 4 Sep 2020                                     19 2                                 Joe Blown Store 4 Oct 2020                                         280 13                             Joe Blown Store 4 Nov 2020                                             107 4                         Joe Blown Store 4 Dec 2020                                                 525 16                     Joe Blown Store 4 Jan 2021                                                     576 18                 Joe Blown Store 4 Feb 2021                                                         27 2             Joe Blown Store 4 Mar 2021                                                             529 12         Joe Blown Store 5 Apr 2021                                                                 36 1     Joe Blown Store 5 May 2021                                                                     511 10 Joe Blown Store 5 Jan 2020                     502 257                                                 Joe Blown Store 5 Jul 2020                             285 61                                         Joe Blown Store 5 Aug 2020                                 13 6                                     Joe Blown Store 5 Sep 2020                                     15 6                                 Joe Blown Store 5 Oct 2020                                         214 14                             Joe Blown Store 5 Nov 2020                                             101 21                         Wonder Woman Store 5 Dec 2020                                                 364 20                     Wonder Woman Store 5 Jan 2021                                                     430 24                 Wonder Woman Store 5 Feb 2021                                                         12 2             Wonder Woman Store 6 Mar 2021                                                             400 18         Wonder Woman Store 6 Apr 2021                                                                 18 4     Wonder Woman Store 6 May 2021                                                                     355 7 Wonder Woman Store 6 Jan 2020                     629 266                                                 Wonder Woman Store 6 Jul 2020                             339 51                                         Wonder Woman Store 6 Aug 2020                                 18 7                                     Wonder Woman Store 6 Sep 2020                                     18 5                                 Wonder Woman Store 6 Oct 2020                                         287 12                             Wonder Woman Store 6 Nov 2020                                             146 11                         Wonder Woman Store 6 Dec 2020                                                 576 35                     ... View more

Re: Data Step / Query

by Quartz | Level 8 in SAS Programming
‎06-29-2021 09:42 AM
‎06-29-2021 09:42 AM
Hi - this is a good query, however I was looking for a query that will shorten the one I have but will also give me the same output as my original query. thanks. ... View more

Re: Data Step / Query

by Quartz | Level 8 in SAS Programming
‎06-29-2021 09:12 AM
‎06-29-2021 09:12 AM
The sample data I have came also from a data step. How do I run this without having the 'cards'? thanks ... View more

Re: Data Step / Query

by Quartz | Level 8 in SAS Programming
‎06-29-2021 09:05 AM
‎06-29-2021 09:05 AM
Hi - it's part of a process to create a report. I just want to write a query that I don't have to update every month when there are new records available for the current month. ... View more

Data Step / Query

by Quartz | Level 8 in SAS Programming
‎06-29-2021 08:31 AM
‎06-29-2021 08:31 AM
Hello!  hope everybody is doing great.  I would like to ask your expertise and help on how to shorten the below query so as not to update this every month.    Data Have; set Want; if month(campaign_date)=2 and year(campaign_date)=2019 then do; CAMPAIGN_MONTH = 'Feb 2019'; FEB19_CUSTOMERS = CUSTOMER_COUNT; FEB19_CONVERTED = CONVERTED; end; else if month(campaign_date)=4 and year(campaign_date)=2019 then do; CAMPAIGN_MONTH = 'Apr 2019'; APR19_CUSTOMERS = CUSTOMER_COUNT; APR19_CONVERTED = CONVERTED; end; else if month(campaign_date)=7 and year(campaign_date)=2019 then do; CAMPAIGN_MONTH = 'Jul 2019'; JUL19_CUSTOMERS = CUSTOMER_COUNT; JUL19_CONVERTED = CONVERTED; end; else if month(campaign_date)=9 and year(campaign_date)=2019 then do; CAMPAIGN_MONTH = 'Sep 2019'; SEP19_CUSTOMERS = CUSTOMER_COUNT; SEP19_CONVERTED = CONVERTED; end; else if month(campaign_date)=10 and year(campaign_date)=2019 then do; CAMPAIGN_MONTH = 'Oct 2019'; OCT19_CUSTOMERS = CUSTOMER_COUNT; OCT19_CONVERTED = CONVERTED; end; else if month(campaign_date)=1 and year(campaign_date)=2020 then do; CAMPAIGN_MONTH = 'Jan 2020'; JAN20_CUSTOMERS = CUSTOMER_COUNT; JAN20_CONVERTED = CONVERTED; end; else if month(campaign_date)=6 and year(campaign_date)=2020 then do; CAMPAIGN_MONTH = 'Jun 2020'; JUN20_CUSTOMERS = CUSTOMER_COUNT; JUN20_CONVERTED = CONVERTED; end; else if month(campaign_date)=7 and year(campaign_date)=2020 then do; CAMPAIGN_MONTH = 'Jul 2020'; JUL20_CUSTOMERS = CUSTOMER_COUNT; JUL20_CONVERTED = CONVERTED; end; else if month(campaign_date)=8 and year(campaign_date)=2020 then do; CAMPAIGN_MONTH = 'Aug 2020'; AUG20_CUSTOMERS = CUSTOMER_COUNT; AUG20_CONVERTED = CONVERTED; end; else if month(campaign_date)=9 and year(campaign_date)=2020 then do; CAMPAIGN_MONTH = 'Sep 2020'; SEP20_CUSTOMERS = CUSTOMER_COUNT; SEP20_CONVERTED = CONVERTED; end; else if month(campaign_date)=10 and year(campaign_date)=2020 then do; CAMPAIGN_MONTH = 'Oct 2020'; OCT20_CUSTOMERS = CUSTOMER_COUNT; OCT20_CONVERTED = CONVERTED; end; else if month(campaign_date)=11 and year(campaign_date)=2020 then do; CAMPAIGN_MONTH = 'Nov 2020'; NOV20_CUSTOMERS = CUSTOMER_COUNT; NOV20_CONVERTED = CONVERTED; end; else if month(campaign_date)=12 and year(campaign_date)=2020 then do; CAMPAIGN_MONTH = 'Dec 2020'; DEC20_CUSTOMERS = CUSTOMER_COUNT; DEC20_CONVERTED = CONVERTED; end; else if month(campaign_date)=12 and year(campaign_date)=2020 then do; CAMPAIGN_MONTH = 'Dec 2020'; DEC20_CUSTOMERS = CUSTOMER_COUNT; DEC20_CONVERTED = CONVERTED; end; else if month(campaign_date)=1 and year(campaign_date)=2021 then do; CAMPAIGN_MONTH = 'Jan 2021'; JAN21_CUSTOMERS = CUSTOMER_COUNT; JAN21_CONVERTED = CONVERTED; end; else if month(campaign_date)=2 and year(campaign_date)=2021 then do; CAMPAIGN_MONTH = 'Feb 2021'; FEB21_CUSTOMERS = CUSTOMER_COUNT; FEB21_CONVERTED = CONVERTED; end; else if month(campaign_date)=3 and year(campaign_date)=2021 then do; CAMPAIGN_MONTH = 'Mar 2021'; MAR21_CUSTOMERS = CUSTOMER_COUNT; MAR21_CONVERTED = CONVERTED; end; else if month(campaign_date)=4 and year(campaign_date)=2021 then do; CAMPAIGN_MONTH = 'Apr 2021'; APR21_CUSTOMERS = CUSTOMER_COUNT; APR21_CONVERTED = CONVERTED; end; else if month(campaign_date)=5 and year(campaign_date)=2021 then do; CAMPAIGN_MONTH = 'May 2021'; MAY21_CUSTOMERS = CUSTOMER_COUNT; MAY21_CONVERTED = CONVERTED; end; drop CUSTOMER_COUNT CONVERTED campaign_date; run;     Below is the data sample:   DM LOCATION CAMPAIGN_DATE CUSTOMER_COUNT CONVERTED John Smith Store 1 01/26/2021 1 0 John Smith Store 1 02/24/2021 1 0 John Smith Store 1 03/18/2021 1 0 John Smith Store 1 04/20/2021 1 0 John Smith Store 1 01/08/2020 834 396 John Smith Store 1 07/17/2020 295 47 John Smith Store 1 08/20/2020 17 8 John Smith Store 2 09/25/2020 13 3 Jane Doe Store 2 10/22/2020 230 12 Jane Doe Store 2 11/11/2020 113 14 Jane Doe Store 2 12/09/2020 471 18 Jane Doe Store 2 01/26/2021 533 31 Jane Doe Store 2 02/24/2021 22 8 Jane Doe Store 2 03/18/2021 503 16 Jane Doe Store 2 04/20/2021 30 6 Jane Doe Store 2 05/11/2021 458 14 Jane Doe Store 2 01/08/2020 277 135 Jane Doe Store 2 07/17/2020 139 26 John Brown Store 3 08/20/2020 15 4 John Brown Store 3 09/25/2020 22 4 John Brown Store 3 10/22/2020 151 5 John Brown Store 3 11/11/2020 79 10 John Brown Store 3 12/09/2020 288 16 John Brown Store 3 01/26/2021 352 18 John Brown Store 3 02/24/2021 19 3 John Brown Store 3 03/18/2021 330 15 John Brown Store 4 04/20/2021 29 7 John Brown Store 4 05/11/2021 296 9 John Brown Store 4 01/08/2020 593 263 John Brown Store 4 07/17/2020 324 40 John Brown Store 4 08/20/2020 27 10 Joe Blown Store 4 09/25/2020 19 2 Joe Blown Store 4 10/22/2020 280 13 Joe Blown Store 4 11/11/2020 107 4 Joe Blown Store 4 12/09/2020 525 16 Joe Blown Store 4 01/26/2021 576 18 Joe Blown Store 4 02/24/2021 27 2 Joe Blown Store 4 03/18/2021 529 12 Joe Blown Store 5 04/20/2021 36 1 Joe Blown Store 5 05/11/2021 511 10 Joe Blown Store 5 01/08/2020 502 257 Joe Blown Store 5 07/17/2020 285 61 Joe Blown Store 5 08/20/2020 13 6 Joe Blown Store 5 09/25/2020 15 6 Joe Blown Store 5 10/22/2020 214 14 Joe Blown Store 5 11/11/2020 101 21 Wonder Woman Store 5 12/09/2020 364 20 Wonder Woman Store 5 01/26/2021 430 24 Wonder Woman Store 5 02/24/2021 12 2 Wonder Woman Store 6 03/18/2021 400 18 Wonder Woman Store 6 04/20/2021 18 4 Wonder Woman Store 6 05/11/2021 355 7 Wonder Woman Store 6 01/08/2020 629 266 Wonder Woman Store 6 07/17/2020 339 51 Wonder Woman Store 6 08/20/2020 18 7 Wonder Woman Store 6 09/25/2020 18 5 Wonder Woman Store 6 10/22/2020 287 12 Wonder Woman Store 6 11/11/2020 146 11 Wonder Woman Store 6 12/09/2020 576 35 ... View more

Re: Modify Character

by Quartz | Level 8 in SAS Programming
‎03-24-2021 11:43 AM
‎03-24-2021 11:43 AM
Thank you so much. ... View more

Re: Modify Character

by Quartz | Level 8 in SAS Programming
‎03-24-2021 11:31 AM
‎03-24-2021 11:31 AM
Thank you. how do you add another if statement? ... View more

Modify Character

by Quartz | Level 8 in SAS Programming
‎03-24-2021 11:03 AM
‎03-24-2021 11:03 AM
Hello!  I just want to ask assistance on how to change or modify characters. below is the example that I'm working on: LOCATION CUSTOMER_KEY City 1401 1000001 GRANDE PRAIRIE 1401 1000002 GRANDE PRAIRIE 1401 1000003 GRANDE PRAIRIE 1401 1000004 GRANDE PRAIRIE 1401 1000005 GRANDE PRAIRIE 1401 1000006 GRANDE PRAIRIE 1401 1000007 WHITECOURT 1401 1000008 GRANDE PRAIRIE 1401 1000009 GRANDE PRAIRIE 1401 1000010 GRANDE PRAIRIE 1401 1000011 WHITECOURT 1401 1000012 GRANDE PRAIRIE 1401 1000013 GRANDE PRAIRIE 1401 1000014 GRAND PRAIRIE 1401 1000015 GRANDE PRAIRIE 1401 1000016 GRANDE PRAIRIE 1401 1000017 GRANDE PRAIRIE 1401 1000018 GRANDE PRAIRIE 1401 1000019 GRANDE PRAIRIE 1401 1000020 WHITECOURT 1401 1000021 GRANDE PRAIRIE 1401 1000022 GRANDE PRAIRIE 1401 1000023 GRANDE PRAIRIE 1401 1000024 GRANDE PRAIRIE 1401 1000025 GRANDE PRAIRIE 1401 1000026 GRANDE PRAIRIE 1401 1000027 GRANDE PRAIRIE 1401 1000028 GRANDE PRAIRIE 1401 1000029 WHITECOURT 1401 1000030 WHITECOURT 1401 1000031 GRANDE PRAIRIE 1401 1000032 GRANDE PRAIRIE 1401 1000033 GRANDE PRAIRIE 1401 1000034 GRANDE PRAIRIE 1401 1000035 GRANDE PRAIRIE 1401 1000036 GRANDE PRAIRIE 1401 1000037 GRANDE PRAIRIE 1401 1000038 GRANDE PRAIRIE 1401 1000039 GRANDE PRAIRIE 1401 1000040 WHITECOURT 1401 1000041 GRANDE PRAIRIE 1401 1000042 GRAND PRAIRIE 1401 1000043 GRANDE PRAIRIE 1401 1000044 GRANDE PRAIRIE 1401 1000045 GRANDE PRAIRIE 1401 1000046 GRANDE PRAIRIE 1401 1000047 GRAND PRAIRIE 1401 1000048 GRANDE PRAIRIE 1401 1000049 GRANDE PRAIRIE 1401 1000050 GRANDE PRAIRIE 1401 1000051 GRANDE PRAIRIE 1401 1000052 GRANDE PRAIRIE 1401 1000053 GRANDE PRAIRIE 1401 1000054 GRANDE PRAIRIE 1401 1000055 GRANDE PRAIRIE 1401 1000056 GRAND PRAIRIE 1401 1000057 GRANDE PRAIRIE 1401 1000058 GRANDE PRAIRIE 1401 1000059 GRANDE PRAIRIE 1401 1000060 GRANDE PRAIRIE 1401 1000061 GRANDE PRAIRIE 1401 1000062 GRANDE PRAIRIE 1401 1000063 GRANDE PRAIRIE 1401 1000064 GRANDE PRAIRIE 1401 1000065 GRANDE PRAIRIE 1401 1000066 WHITE COURT 1401 1000067 GRANDE PRAIRIE 1401 1000068 GRANDE PRAIRIE 1401 1000069 GRANDE PRAIRIE 1401 1000070 GRANDE PRAIRIE 1401 1000071 GRANDE PRAIRIE 1401 1000072 GRANDE PRAIRIE 1401 1000073 WHITECOURT 1401 1000074 GRANDE PRAIRIE 1401 1000075 GRANDE PRAIRIE 1401 1000076 GRANDE PRAIRIE 1401 1000077 GRANDE PRAIRIE 1401 1000078 GRANDE PRAIRIE 1401 1000079 WHITECOURT 1401 1000080 GRANDE PRAIRIE 1401 1000081 GRANDE PRAIRIE 1401 1000082 GRANDE PRAIRIE 1401 1000083 GRANDE PRAIRIE 1401 1000084 GRANDE PRAIRIE 1401 1000085 GRANDE PRAIRIE 1401 1000086 WHITECOURT 1401 1000087 GRANDE PRAIRIE 1401 1000088 GRANDE PRAIRIE 1401 1000089 GRANDE PRAIRIE 1401 1000090 GRANDE PRAIRIE 1401 1000091 GRANDE PRAIRIE 1401 1000092 GRANDE PRAIRIE 1401 1000093 WHITECOURT 1401 1000094 GRANDE PRAIRIE 1401 1000095 GRANDE PRAIRIE 1401 1000096 WHITECOURT 1401 1000097 GRANDE PRAIRIE 1401 1000098 GRANDE PRAIRIE 1401 1000099 GRANDE PRAIRIE 1401 1000100 GRANDE PRAIRIE 1401 1000101 WHITECOURT 1401 1000102 GRANDE PRAIRIE 1401 1000103 WHITECOURT 1401 1000104 GRANDE PRAIRIE 1401 1000105 WHITECOURT 1401 1000106 GRANDE PRAIRIE 1401 1000107 GRANDE PRAIRIE 1401 1000108 GRANDE PRAIRIE 1401 1000109 GRANDE PRAIRIE 1401 1000110 GRANDE PRAIRIE 1401 1000111 GRANDE PRAIRIE 1401 1000112 GRANDE PRAIRIE 1401 1000113 GRANDE PRAIRIE 1401 1000114 GRANDE PRAIRIE 1401 1000115 GRANDE PRAIRIE 1401 1000116 GRANDE PRAIRIE 1401 1000117 GRANDE PRAIRIE 1401 1000118 WHITECOURT 1401 1000119 GRANDE PRAIRIE 1401 1000120 WHITECOURT 1401 1000121 GRANDE PRAIRIE   what I want to do is to make the City column uniform, like 'Grande Prairie' and 'GrandPairie' change to 'Grand Prairie'.   Thanks a lot. ... View more

Re: if else if

by Quartz | Level 8 in SAS Programming
‎01-12-2021 10:35 AM
‎01-12-2021 10:35 AM
this works perfect. the data lined up with the expectation. Thank you so much. One last favor, would it be possible for you to add a comment as to what each step do? I want to understand more each steps function. from 'array' step up to the last 'if' statement. Thanks a lot! ... View more

Re: if else if

by Quartz | Level 8 in SAS Programming
‎01-12-2021 09:07 AM
‎01-12-2021 09:07 AM
Hello - thanks always for your help.  I ran your code and it did not work as expected.  I've got rows that did not meet the objective.   see example:  the code picked up the wrong campaign_date(n), campaign_converted should be campaign_date3. CUSTOMER campaign_date1 campaign_date2 campaign_date3 campaign_date4 LOANDATE CAMPAIGN_CONVERTED CUSTOMER A 06/23/2020 09/25/2020 11/11/2020   11/28/2020 09/25/2020 ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎01-03-2024 05:04 PM
Likes given to
Likes from
Quick links