About Bellefeuille

Tom · ‎11-17-2017

@Bellefeuille wrote: its date i guess what im trying to do is export it so i can use it in sql Table - ACCT DATE Again when i export the content, the date is exported as DDMMMYYYY and if i load the data in sql afterwards, it will concider it txt because of the MMM What do you mean by SQL? In SAS code you can just use a date literal, which uses the DATE9 format that you already have. Whether you do it in normal SAS code or SQL code that you are using in PROC SQL. where acct_date = '17NOV2017'd If some other flavor of SQL then you will need specify what flavor and what syntax it uses to code date literals. In Teradata you you can use the DATE keyword to indicate that you have a date literal. where acct_date = date '2017-11-17' If you are pushing the data into a database then what format you have attached to it should not change how it gets stored in the remote database. SAS will see that it is a DATE and create the proper variable type in the remote database. libname out teradata server= .... ; data out.newtable; set work.mytable; run;

ballardw · ‎11-17-2017

In a data step, since you have already read the data: SASDate = input(yourdate, date9.); format SASdate date9. ; /* or any of the other date formats humans like*/ in sql it would be input(yourdate,date9.) as SASDate format=date9. Best would be to read the data initially.

Shmuel · ‎10-26-2017

Just to complete @ClarkLawson's answer: The syntax to check date is: if date > '01SEP2017'd; The format to use date as literel is 'ddmmmyyyy'd.

ballardw · ‎08-18-2017

@RahulG wrote: Try using WHERE CU.DEATH_DT is not null or Where not missing(Cu.Death_DT)

TomKari · ‎08-17-2017

The INTNX function is incredible. I suggest you read up about it. data have; format CreationDate EffectiveDate date.; CreationDate = '1jan2017'd; EffectiveDate = intnx('year', CreationDate, 1, 'end'); output; CreationDate = '18aug2017'd; EffectiveDate = intnx('year', CreationDate, 1, 'end'); output; CreationDate = '31dec2017'd; EffectiveDate = intnx('year', CreationDate, 1, 'end'); output; run; Tom

ChrisHemedinger · ‎07-11-2017

PROC EXPORT with DBMS=XLSX supports adding sheets to an existing workbook. I have some examples of using ODS EXCEL (to create a workbook) and PROC EXPORT (to add new sheets) in this article.

Bellefeuille · ‎06-29-2017

Thanks art. I already have a program that creates thr workbook and all its tabs. However i have been asked to add a new tab. Ehich reada from other tabs. Since its already created. Im wondering if i can impoer the tab at the end or the creation job.

Ksharp · ‎06-15-2017

Unlike DataBase ,SAS don't have DATE type variable . As long as integer take on date format , this variable is becoming a 'DATE' variable. You can use function FMTINFO() to check if its format is a date or not . Learn it from @Tom yesterday .

RW9 · ‎06-01-2017

You have two text strings therefore: identical=ifc(strip(edat)=strip(trtdat),1,0);

Tom · ‎05-19-2017

You can use the Z format to make an 11 character string with leading zeros and then add the hyphen. Or you could create a picture format. With the picture format you could leave the variable as numeric if you wanted. proc format ; picture id low-high='9999-9999999' other=' '; run; data text ; length x1 x2 8 c1 c2 $12; x1=3456789999 ; x2=x1; format x1 z11. x2 id. ; c1=put(x1,Z11.); c1=catx('-',substr(c1,1,4),substr(c1,5)); c2=put(x1,id.); put (_all_) (=/); run;

ballardw · ‎03-15-2017

Since I doubt that your "unique identifier" consists of 1s do you mean that you are trying to extract the characters starting at position 4 and ending at position 13? If your variable is character that would be ID = substr(Client_key,4,10); /* SAS does not have a MID function, substr does similar when a second position is used*/ If your column headings are longer than 32 characters SAS will apply rules to create SAS useable names from whatever appears in the heading when you use proc import. Anything longer than 32 characters gets truncated, generally spaces and non-alphanumeric characters will be changed to underscores. If the first character is a digit it will likely be replaced with an _, if two columns would have the same name then the variable will be suffixed at some point with a numeric value to indicate a different column. If you don't like automatically generated names then place column headers in the Excel that are useable as SAS variable names OR use a different approach to bringing data into SAS such as save to CSV and use a data step to read values into variable names you assign.

Kurt_Bremser · ‎02-10-2017

By personal preference, I would use yymmddd10. or yymmddn8. as the format for the date value. This automatically sorts the logs in their chronological order.

Online Status	Offline
Date Last Visited	‎01-13-2020 11:42 AM

Re: convert text date to DD/MM/YYYY from DDMMMYYYY

Re: convert text date to DD/MM/YYYY from DDMMMYYYY

Re: convert text date to DD/MM/YYYY from DDMMMYYYY

convert text date to DD/MM/YYYY from DDMMMYYYY

DDMMMMYYYY

Convert String to date and filter

Re: Where clause with missing dates

Re: Where clause with missing dates

Where clause with missing dates

DATE Calculation

Isdate

Re: convert text date to DD/MM/YYYY from DDMMMYYYY

Re: DDMMMMYYYY

Re: Convert String to date and filter

Re: Where clause with missing dates

Re: DATE Calculation

Re: Adding a tab / sheet to an existing workbook / .xlsx file

Re: Import tab from one excel

Re: Isdate

Re: Convert text dates and see if two dates are the same

Re: Split data and pad with zero's

Re: Import with substring

Re: Export SAS log to external files without vbs