About jmoore168

SASJedi · ‎09-09-2018

Peter made an excellent suggestion about taking the free Programing 1 course. I'd also like to know a little more detail about what's causing your concern. Are you already used to programming in SAS, and it's just the difference in the programming interface? and by "base SAS" do you mean you are now using PC SAS? Or perhaps you now edit your SAS code in a text editor and submit from the command line? If you could pinpoint the issues a bit. I'll try to provide additional resources.

SASKiwi · ‎07-30-2018

The error message is telling you there is no data source called SERVER defined in your odbc.ini (since you are on Unix) nor do you have a default ODBC driver defined. These need to be added before your connection will work. Alternatively you could try defining everything in the connection string which will look similar to this: proc sql; connect to odbc (noprompt = "server=MyServerName;DRIVER=SQL Server;uid=myusr1;pwd=mypwd1;"); create table Want as select * from connection to odbc (SELECT * FROM [MyDatabase].[MySchema1].[MyTable] ) ; disconnect from odbc; quit;

jmoore168 · ‎03-27-2018

Thanks everyone! I was almost too embarassed to ask.

Kurt_Bremser · ‎03-09-2017

Good catch, @art297!

collinelliot · ‎03-09-2017

Whether your syntax is correct depends on the underlying data, which we cannot see. From the one piece of data you show, it looks like that REQ_DT is a datetime value, not a date value. Are you sure of whether all the variables you have are date and not date time and that you're comparing them correctly?

DanielSantos · ‎01-23-2017

Hi. Could it be as simple as the following? SELECT case when TRANSACTION_FACT.TRN_CD eq '1S' then '1S' else 'N' end as FIN_CD, Daniel Santos @ www.cgd.pt

Peter_C · ‎01-21-2017

This query started talking about transaction codes and now it appears to be about an account. There probably needs to be an inner join of 2 streams of data selected from the original. The first stream identifies accounts for which a TQ is present and the second stream is the other transactions (subject to being not too old) The join is on account number. The date of the TQ transaction acts like an opening-date. The output of the join generates multiple rows per account number. However it seems the requested shape is one row per account with columns for each transaction thpe. It is not obvious whether there might be multiple transaction for each transaction type, nor how to handle that. If the data are unique by transaction type within each account, a transpose is needed. However for non-unique, deduplication needs to have rules defined.

Online Status	Offline
Date Last Visited	‎09-06-2018 06:30 PM

Re: Let's learn some SAS!

Unable to connect to ODBC

Re: Keep only first four characters

Keep only first four characters

Help with proc sql variable equal

Proc Sql = Setting two variables equal

Re: want to output Y if observations variable x equals to something

want to output Y if observations variable x equals to something

Re: Building report using PROC SQL

Re: Building report using PROC SQL

Re: want to output Y if observations variable x equals to something

Re: Difference in days between two dates in two different rows and dif...

Re: Let's learn some SAS!

Re: Keep only first four characters

Re: Let's learn some SAS!

Re: Unable to connect to ODBC

Re: Keep only first four characters

Re: Help with proc sql variable equal

Re: Proc Sql = Setting two variables equal

Re: want to output Y if observations variable x equals to something

Re: Building report using PROC SQL