About sasmaverick

sasmaverick · ‎01-18-2023

@Ksharp Thanks a lot. This is exactly what I was looking for!!

SASKiwi · ‎06-16-2022

How about creating the volatile table using SAS then checking if it exists with Teradata SQL Assistant? I'm able to do this with SQL Server using MS SQL Server Management Studio so I'm thinking it should work in Teradata SQL Assistant. Also try PROC CONTENTS in SAS: proc contents data=TD._all_; run;

SASKiwi · ‎06-15-2022

How long is extremely long? In my experience SAS's default database table loading settings such as DBCOMMIT and INSERTBUFF are not optimal. You should experiment with load times using a much smaller sample of rows, say 100,000. Set DBCOMMIT / INSERTBUFF to say 5,000 (default is 1,000) to start with then try increasing it. What SAS code are you using to load the data?

sasmaverick · ‎01-04-2018

Hi @RW9 Thanks for the effort. I think this works. The customer count in output data shown was just for reference and not exact numbers that we would get. What I am trying to achieve is to get the count of customers unique across an amount-channel-brand group. and I think your solutions addresses that. Regards,

jklaverstijn · ‎12-29-2017

I dare you with this denormalized model. Remember there are brand_1 and brand_2 variables that need to be combined. I look forward to your mean MEANS. And don't make it non-trivial! Regards, -- Jan.

rajan_sharma · ‎12-27-2017

proc sort data = large; by name; run; proc sort data = small; by person_name; run; data merged; retain name person_name; merge large(in= l) small(rename = (person_name=name) in = s); by name; length status$ 8; if s then do; person_name = name; if l then status = "match"; else status = "no match"; end; else do; person_name = ""; status = "no match"; end; run;

Reeza · ‎06-07-2017

Try adding the PRINTMISS option after the TABLE statement. See the example in the docs: http://support.sas.com/documentation/cdl/en/proc/65145/HTML/default/viewer.htm#p1f1t9bipbeqy5n1vowhzzk3vuby.htm

sasmaverick · ‎01-12-2017

Hi Reeza, Below is the code I am using proc standard data=sample mean=0 std=1 out=sample_out; var amount transaction; run; Would this give me the top 15% customer if I put the condition "amount>1" and bottom 15% if I put "amount<-1". This is the score calculated from the above step for amount. I see some conditions are not fulfilled and I get 0 observations. For example if I put transaction<-1 Thanks

sasmaverick · ‎12-26-2016

Thank you, I was able to do it by setting default formats for frequencies by using PROC Template.

RW9 · ‎12-06-2016

Personally I avoid using formats, but even more so when dealing with numbers as characters. Would the text "8" be considered between "008" and "024"? Textually its not. Is there a reason for the format need? Why not just convert to numeric and use numeric ranging - makes more sense as your really dealing with numeric data. Nothing stopping you keeping both, text and num, and using num.

data_null__ · ‎08-18-2016

This is a good place to apply the UPDATE trick it handles BY group automatically. data XY; input X Y @@; cards; 1 70 1 . 1 . 1 . 1 80 1 . 1 . 2 60 2 . 3 . ;;;; run; proc print; run; data LOCF; update XY(obs=0) XY; by X; output; run; proc print; run;

sasmaverick · ‎08-10-2016

Yours alongwith Ballardw's suggestion helped me. Thanks

Reeza · ‎08-10-2016

That adds a manual step into the process...which is usually what DDE/automation is intended to avoid

RW9 · ‎08-08-2016

I assume you have those CSV files as SAS datasets too, and you create the CSV from those? If so (and you have SAS 9.4) you can use the libname excel to write to various parts of an Excel file: http://www2.sas.com/proceedings/sugi31/024-31.pdf Personally however, I would use VBA in Excel, to load the CSV files, and process them into the spreadsheet, if you have to use Excel at all.

Reeza · ‎08-08-2016

Use the ODS table. Proc freq data=have; Table v1 v2; ODS output onewayfreqs = want; Run; Here's an example to generate a nicely formatted table: https://gist.github.com/statgeek/e0903d269d4a71316a4e

Online Status	Offline
Date Last Visited	‎01-19-2023 12:48 AM

Re: Select Subset of a Group and Return All Rows

Re: Select Subset of a Group and Return All Rows

Select Subset of a Group and Return All Rows

Re: Create Volatile Table in Teradata Using ODBC

Re: Create Volatile Table in Teradata Using ODBC

Re: Create Volatile Table in Teradata Using ODBC

Unable to Transfer Large SAS Dataset to Teradata Using ODBC

Create Volatile Table in Teradata Using ODBC

Re: Restructure Dataset

Re: Restructure Dataset

Re: Select Subset of a Group and Return All Rows

Re: Restructure Dataset

Re: Summarize by Multiple Variables in Data Step

Re: Month-Year Loop

Re: Country Code Format Lookup

Re: Create Volatile Table in Teradata Using ODBC

Re: Select Subset of a Group and Return All Rows

Re: Create Volatile Table in Teradata Using ODBC

Re: Unable to Transfer Large SAS Dataset to Teradata Using ODBC

Re: Restructure Dataset

Re: Summarize by Multiple Variables in Data Step

Re: Join Datasets Without Key

Re: Show All Ranges of Proc Format in Proc Freq

Re: Calculate Z Score

Re: Formatting Scientific Notation in PROC FREQ

Re: Specifying character Values as Ranges

Re: Pick The Last Non Missing Value

Re: Month-Year Loop

Re: SAS DDE to Excel 2013 freezes SAS

Re: Write Different CSV Outputs to Same Excel Sheet

Re: Proc Freq Separate Dataset for Each Variable