The ZW format Writes standard numeric data with leading 0s, and standardizes it to length W, regardless of the length of the input variable.    Z3 - states a length of 3 Z4 - states a length of 4    If your case is different than what you've initially presented you need to explain in detail how and what you want.    ... View more

Hi, I have to check whether i have access to create excel file in share point . So can we export sas datasets from SAS EG which is on remote server (accessing sas from citrix link ) ... View more

If you have multiple datea values, then I would just modify the sort by variables and what you are using as the variable with your First. satement.  This would get you what you want with the updated data you provided:   data have; input datea time customer$ amount sssid$; informat datea yymmdd10. time time20. customer $10. amount 6. sssid $10.; format datea yymmdd10. time time20. customer $10. amount 6. sssid $10.; datalines; 2015-11-20 11:18:36 lucy 250 xxx 2015-11-20 11:21:09 lucy 250 xxx 2015-11-23 11:20:35 lucy 500 xxx ; run; proc sort data=have; by customer datea descending time; run; data want; set have; by customer datea descending time; If First.datea; run; ... View more

You may want to be more specific as far as what you want the macro variable to do or be equal to, but here's a brief example using 10 days ago from the current date (this is assuming your Date Variable in the Oracle Table is Date and not DateTime):   %let today=%sysfunc(today(),date9.); %let date=%sysfunc(intnx(DAY,"&today"d,-10),date9.); %put *** Today Macro = &today AND Date Macro = &date ***; proc sql; connect to oracle (/*database options*/); create table want as select * from connection to oracle (select * from /*name of table*/ where /*name of date variable*/>="&date"d); quit; ... View more

You are using PASSTHRU to SQL Server so your SQL must conform to what SQL Server accepts, not SAS and using DT on a datetime string is a SAS-specific syntax. Try:   where date >= '2015-03-30' ... View more

here you go:   data have; infile cards dsd; input customer$     phone$     phonetype $10.; cards; lori,12356,cellphone lori,45623,homephone lori,23687,workphone ; proc transpose data=have out=want (drop=_name_);by customer;id phonetype;var phone; ... View more