About santhosh

santhosh · ‎03-29-2012

Hi thanks for support I am getting date values correctly if there is any blank character it is not taking double quotes how to get double quotes for blank character

santhosh · ‎03-29-2012

hi, yes i am getting date format / / but the characte with blank taking default single space how can i remove single space in put statement " " i want character as ""

santhosh · ‎03-28-2012

Hi, i am trying to replace the empty date columns with two slash ie., / / but i am not getting it how to replace empty dates with / /

santhosh · ‎03-28-2012

Thanks Tom its working fine

santhosh · ‎03-27-2012

Thanks for support can we select the date insted of system date the report can be generated for any month the date should vary march to march

santhosh · ‎03-26-2012

Thanks for your support i want to generate a title if the report generating period is form April 2011 to Mar2012 then title= "for the financial year 2011 to 2012" if the report is generating for period dec 2011 then title will be "for the financial year 2011-2012" if the report is generating for period jan 2012 then title will be " for the financial year 2011-2012"

santhosh · ‎03-26-2012

Thanks Ksharp it is working fine title of program is report generated for the period 31 Dec 2011 for financial year 2011-2012 (if month is from april 2011 to march 2012) if month is April 2012 then title will be " for financial year 2012-2013" i am unable to put other date

santhosh · ‎03-26-2012

Hi Ksharp not putting all rows in one column i am getting out put of 1st row in 2 lines after 20th column the row is going to next line

santhosh · ‎03-26-2012

Hi Cynthia, i am getting output "char1","date","char2","name" "63586900","15/03/2012","4568012145","Kumar" "12345678","15/11/2012","9876543212","Kermit" "32545435","15/04/2012","6540845521","Gonzo" "87323621","15/08/2012","8943245698","Big Bird" Date column is taking double quotes

santhosh · ‎03-26-2012

yes Creating macro year based on months conditionally if month is JAN/FEB/MAR 2012 then want to create macro year=2011 else macro year=2012

santhosh · ‎03-26-2012

Hi, I am trying to create macros based on month eg., if month is JAN FEB MAR then i need to create year macro -1 year else i want to create macro +1 year if Month JAN/FEB/MAR 2012 then i want to create macro year 2011 else i want to create macro year 2012

santhosh · ‎03-23-2012

Thanks Kshar, I got all values a last help i am generating almost 47 columns i am getting all values correctly with quotes and comma seperated but i am not getting output in single line can u help out i am using TERMSTR=CRLF even i am not getting output in single line

santhosh · ‎03-23-2012

I am trying to generate .csv file from sas data set with " as text delimiter and , as delimiter i am getting output like this 63586900,"15/03/2012",4568012145,"Kumar" 1st column is numeric and i want quotes for that column and where as date is taking as character i want date as numeric is there any way to output like this "63586900",15/03/2012,"4568012145","Kumar"

santhosh · ‎02-01-2012

Date format is 31DEC2011:00:00:00 and by applying attribs i am converting into MMDDYY10.

santhosh · ‎01-30-2012

This is sample code iam using proc export data=sample; outfile="path/sample.txt" dbms=dlm replace; delimiter='|'; run; data sample; infile "path/sample.txt" firstobs=2 dlm='|' dsd missover; attrib ACODE length=$7. informat=$7. format=$7.; attrib X_PRD informat=anydtdte32. format=MMDDYY10.; attrib I_NO length=$10. informat=$10. format=$10.; attrib EI_SYS length=$3. informat=$3. format=$3.; attrib S_PORTCODE length=$10. informat=$10. format=$10.; attrib S_BILLNO length=$10. informat=$10. format=$10.; attrib EXP_DT informat=anydtdte32. format=MMDDYY10.; attrib DUE_DT informat=anydtdte32. format=MMDDYY10.; attrib EXTN_GR length=$1. informat=$1. format=$1.; attrib EXTN_AUTHO length=$4. informat=$4. format=$4.; attrib EXTN_DT informat=anydtdte32. format=MMDDYY10.; attrib ADCODE length=$7. informat=$7. format=$7.; attrib REALISE length=$1. informat=$1. format=$1.; attrib REALISE_DT informat=anydtdte32. format=MMDDYY10.; attrib REMARK length=$35. informat=$35. format=$35.; input ACODE X_PRD I_NO EI_SYS BILL_NO BILL_DT STATUS_H EXP_NAME EXP_ADDR1 EXP_ADDR2 EXP_CITY EXP_PIN S_PORT S_PORTCODE S_BILLNO EXP_DT DUE_DT EXTN_GR EXTN_AUTHO EXTN_DT EXP_CTRY EXP_COMM INV_CUR INV_AMT INV_INR R_CURR R_AMT OS_AMT OSB_NAME OSB_ADDR1 OSB_ADDR2 OSB_CTRY OSB_PIN REALISE REALISE_DT REMARK ; run; I am declearing all column attribs which mentioned in input statement in output i am getting missing date columns and some numeric columns

Online Status	Offline
Date Last Visited	‎05-15-2023 06:50 AM

Re: Creating csv with space in columns

Creating csv with space in columns

Re: Unable to get comma seperated values in proc report after every 3 ...

Unable to get comma seperated values in proc report after every 3 digi...

reading select data from text

Reading particular line from text files

Serial number for Group virables

Re: How to cellmerge in excel

How to cellmerge in excel

How to calculate 0.5 class interval of interest rates

Re: Unable to get comma seperated values in proc report after every 3 ...

Re: Unable to get comma seperated values in proc report after every 3 ...

Re: justifying font in columns

Re: Removing space while resolving macros

Re: How to resove or remove bouble quotes from string macro

Bouble qotes for numeric column in csv

Bouble qotes for numeric column in csv

Bouble qotes for numeric column in csv

Bouble qotes for numeric column in csv

Creating Macros Based on months

Creating Macros Based on months

Creating Macros Based on months

Bouble qotes for numeric column in csv

Bouble qotes for numeric column in csv

Creating Macros Based on months

Creating Macros Based on months

Bouble qotes for numeric column in csv

Bouble qotes for numeric column in csv

Proc export unable to read all columns

Proc export unable to read all columns