About SASAna

SASAna · ‎02-08-2017

You are right . I added option missing =' ' before the datastep & before ODS report , all the dots vanished. Thanks much, Ana

SASAna · ‎02-08-2017

I will try adding 'not mising' to all the reformatting of the fileds. Doe athat applies to 'INPUT' - Charcter to Number conversion? Is the below example looks fine? DO; if not missing(AMT) then amt1 = put(AMT ,10.); /* Number to charcter conversion*/ if not missing(NBR) then NBR1 = put(NBR ,10.); if not missing(UNIT) then UNIT1 = input(UNIT,10.); /* charcter to number conversion */ ; END;

SASAna · ‎02-08-2017

Yes, Colline, you are right . They could be missing Numbers.

SASAna · ‎02-08-2017

Hi Reeza, Thank yu. Some of them they changed dot to empty cell. that was helpful . but some of them are still there. I am doing the below logic - IF "class" = "'A'" THEN DO; AMT1 = put(AMT ,10.); /* data type conversion */ NBR1 = put(NBR ,10.); ; END; ELSE DO; AMT1= AMT; /* for other classess data type conversion not needed */ NBR1 = NBR; END; I am renaming them back i the next data step & appending the data by loop of class. when i am appending the data for class A , B, C, D,E, F , G and doing ODS excel.. I am seeing the dots. Thanks, Ana

SASAna · ‎02-08-2017

I came up with below code , thought of sharing with you all. Thanks for all your suggestions. I really appreciate it. PROC SQL ; select files into :filename1 separated by '~' from &SUMMAR where scan(files,1,' ') like '%no%'; %LET FILE_COUNT1=&sqlobs; QUIT; PROC SQL ; select files into :filename2 separated by '~' from &SUMMAR where scan(files,1,' ') not like '%no%'; %LET FILE_COUNT2=&sqlobs; QUIT; Thanks, Ana

SASAna · ‎02-08-2017

SAS Users, Wanting help with removing dots from Excel output, which is been printed by ODS & PROC report. Due to different data types & lengths problem occured while appending the data from many files , i did formatting (Character to Numeric & Numeric to charcter conversions) and used length & formats to avoid truncation. This formatted data is being proc reported & printed to excel by ODS statement. Due to this i see some dots in the excel file. Is there a way to get change dots to empty cells in the Excel using some options ?? Thanks, Ana

SASAna · ‎02-07-2017

Hi, Data is bunch of files and some of them will be like 'No records'. I want to identify them by splitting them. Thanks, Ana

SASAna · ‎02-07-2017

Need help with the below question. scan(files,1,' ') ^= 'No' is not working. & all are going to filename1. some files have 'No records found' & wanted this to go to filename2. %Macro test(SUMMAR= ); PROC SQL ; select files into :filename1 separated by '~' from &SUMMAR where scan(files,1,' ') ^= 'No' ; %LET FILE_COUNT1=&sqlobs; QUIT; PROC SQL ; select files into :filename2 separated by '~' from &SUMMAR where scan(files,1,' ') = 'No' ; %LET FILE_COUNT2=&sqlobs; QUIT; code continues... %MEND; Thanks, Ana

SASAna · ‎02-06-2017

Hi SAS Users, I wanted to check if there is any way to avoid truncation of the data for the below scenario of data append using proc append. I have 10 different tables data i am appending which has different lengths and different data types (around 500 attriutes in each table). I did reformatting of the data for all the variables which ever was different , but due to length issues , data is being truncated after appending it. Example : data length X $10. Y $20, ; Proc Append Base= Base_table Data= sas_ds FORCE NOWARN; I tried to use length statement for dataset sas_ds by taking the max length of the attributes, but that did not help me much. Can you please suggest the options? Thanks, Ana

SASAna · ‎01-27-2017

Worked really well. Thanks for the suggestion.

SASAna · ‎01-26-2017

Hi SAS Users, Need some help with displaying the Table contents into Email. I have a variable called "FILENAME" in a table 'FILES_TABLE" where i stored all the filenames of 500 length. I have to put them in the email. & i used "PUT" statement like below code. %if &syserr=0 %then %do; FILENAME outmail EMAIL SUBJECT = "TEST FILES" FROM = "xyz@xyz.com" TO = "&to_email" DATA _NULL_; FILE outmail; PUT "Hi All,"; PUT " "; PUT "The following files have been created and dropped in the following path."; PUT " "; PUT "&filename"; PUT "Thanks,"; run; I am seeing all the files, but they are coming in same line, or broken filenames in different lines, Dispaly is not clean. Due to one PUT staetement for all the files. Any suggestions to make files look clean & orderly in the Email? Thanks, Ana

SASAna · ‎01-05-2017

Thanks Reeza, It worked with just datetime() and inserted appropriate date time in database.

SASAna · ‎12-30-2016

Hi SAS USers, I need some help with converting this below formatted complete_date to 'DATE' type to insert into database. I tried new_complete_date = input(put(datepart(complete_date),8.),YYMMDD10.) it did not worked. new_complete_datetime = input(put(datepart(complete_date),8.),DATETIME20.) format new_complete_date YYMMDD10. new_complete_datetime DATETIME20.; Variable name type length format informat Complete_date Num 8 DATETIME20. DATETIME20. Thanks, Ana

SASAna · ‎12-19-2016

Hi Tom, I tried DATETIME() : data enter; FORMAT ENTRY_DT DATETIME20.; ENTRY_DT = DATETIME(); run; I am getting full date and time being printed in the tables. (12/19/2016 12:39:26 PM) I want it to be YYYY-MM-DD format. Table has Date format for this variable ENTRY_DT. Thanks, Ana

SASAna · ‎12-16-2016

Hi Tom, Jus loading today() in the entry_dt field is giving resulsts like "1/1/1960 time". I wanted them to be "YYYY- MM-DD" format & also todays date

Online Status	Offline
Date Last Visited	‎06-30-2021 01:11 AM

Re: SCD type2 in SAS

SCD type2 in SAS

Re: Proc transpose

Re: Proc transpose

Proc transpose

Re: proc gee - Nesting continuous variable

proc gee - Nesting continuous variable

Re: min Date conversions to character date

min Date conversions to character date

Re: adding weeks to the max of the date and comparing it with datetime...

Re: SCD type2 in SAS

Re: Proc transpose

Re: adding weeks to the max of the date and comparing it with datetime...

Re: adding weeks to the max of the date and comparing it with datetime...

Re: scan in the proc sql

Re: scan in the proc sql

Excel reading and converting to macro variable error

Re: Converting character date to " DATETIME20."

Re: Proc report ODS excel output to remove dots

Re: Proc report ODS excel output to remove dots

Re: Proc report ODS excel output to remove dots

Re: Proc report ODS excel output to remove dots

Re: PROC SQL scan function

Proc report ODS excel output to remove dots

Re: PROC SQL scan function

PROC SQL scan function

PROC append .. different lengths warning

Re: Displaying Table contents in the Email

Displaying Table contents in the Email

Re: number to DATE conversion

number to DATE conversion

Re: today() to insert into date format of Oracle table

Re: today() to insert into date format of Oracle table