Hi all, i'm not able to print a single quote for one of my variables I tried with different types like  catt, quote(id,"'") but it gives the double quote's only so please suggest some solution for the problem   { DATA _LIC; INFILE DATALINES; INPUT @1 ID 1. @3 LIC $10.; DATALINES; 1 24356578 2 42437254 3 36353239 4 25242762 5 26525326 ; RUN; DATA _LIC2; SET _LIC; ID_NEQ = QUOTE("'",LIC,"'"); RUN; PROC PRINT DATA = _LIC2; RUN;     }   expecting results should be like : ('24356578') not like ("24356578")   Thanks & reagrds  rohit   ... View more

Hi all, I'm facing an issue with the DateTime format and pleas find below the code    { DATA _TIME; INFILE DATALINES; INPUT CMS_DAT DATETIME26.; FORMAT CMS_DAT DATETIME26.6; CMS_DT = PUT(CMS_DAT,DATETIME30.6); DATALINES; 22MAR2018:12:32:43.491538 06DEC2017:00:31:54.664700 03JAN2018:08:33:57.142454 17OCT2017:00:33:19.866942 2018-03-22-02.32.43.491538 28MAR2018:07:33:28.239593 ; RUN; PROC PRINT DATA=_TIME; RUN; DATA _TIMEQ; SET _TIME; RESULT =TRIM(LEFT(PUT(DATEPART(CMS_DAT),YYMMDDD10.)||'-'|| PUT(TIMEPART(CMS_DAT),TIME15.6))); RUN; PROC PRINT DATA = _TIMEQ; RUN; }   and results are comming like  RESULT 2018-03-22-12:32:43.491538 2017-12-06- 0:31:54.664700 2018-01-03- 8:33:57.142454 2017-10-17- 0:33:19.866942 .- . 2018-03-28- 7:33:28.239593 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ after datepart  all 0 values are missing  so kindly help out this senioro  ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ and my expecting results should be like +++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 22MAR2018:12:32:43.491538 06DEC2017:(0)0:31:54.664700 03JAN2018:(0)8:33:57.142454 17OCT2017:(0)0:33:19.866942 . 28MAR2018:(0)7:33:28.239593 what ever i highleted with braghctes those are not comming in expexcted output kindly give some solution for the above issue  Thanks & regards  rohit         ... View more

Hi all, i'm facing sas DateTime function issue in my current job please find below the code    {      DATA _TIME; INFILE DATALINES; INPUT CMS_DAT $char30.; CMS_DT = PUT(CMS_DAT, DATETIME30.6); DATALINES; 22MAR2018:12:32:43.491538 06DEC2017:13:31:54.664700 03JAN2018:08:33:57.142454 17OCT2017:14:33:19.866942 28MAR2018:07:33:28.239593 ;  run; and my rec is : 2018-03-22-12.32.43.491538  } so kindly sugeust solution for above sas mainframe code  & if i remove that put statment i'm getting sum other values after mention put statment it gving exact input values i'm not getting expecting results has mention on the colour  thanks & regards  rohit     ... View more

Hi all, Currently, I'M facing sas date format issue in my existing code kindly give the solution for the below code  { data _null_; infile lss279; input @1 sdte $char10.; datalines; 25.12.2017 ; dte2 = put(dte1,ddmmyy10.); dte2 = substr(dte1,7,4)||substr(dte1,4,2)||substr(dte1,1,2);  run;                                                                                            )   and here is the output: (2017.12.25)   and my requirement is  25.12.2017 but why I am getting that results I'm not able to understand  and the thing is I'm using ZOS 8.1 version (mainframe )    Thanks & regards  rohitkrishna   ... View more

Hi all, I tried to generate a report in sas mainframe by using sas proc report procedure and ods function while using to pdf its not working and I tried to print it in HTML so successfully it prints the output but it's not in the readible format so kindly help to find the solution for this issue below the code plz go through on the code    {     OPTIONS NONUMBER NODATE PAGENO=1 ORIENTATION=LANDSCAPE LS=164 PS=60; ODS LISTING CLOSE;ODS NORESULTS; ODS HTML FILE=OUTPDF; DATA SASWORK.TRP; INFILE INPPDF; INPUT @1 H $CHAR1. @3 HED $CHAR4. @8 NUM 3. @12 SEQNUM 3. @16 BUSDT 8. @25 COUNT 7.; PUT _INFILE_; RUN; DATA SASWORK.FINAL; SET SASWORK.TRP; RUN; PROC REPORT DATA=SASWORK.FINAL OUT=OUTPDF NOWD NOHEADER  STYLE(COLUMN)={ASIS=ON}; TITLE ' '; COLUMNS H SEQNUM COUNT; DEFINE H / DISPLAY NOPRINT; DEFINE SEQNUM / DISPLAY; DEFINE COUNT / DISPLAY; RUN; ODS HTML CLOSE; ODS LISTING;                                                                                                                                                                                         } and below the output plz look on it   <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN"> <HTML> <!-- Ge   ="shutdown()" vlink="#004488" link="#0066AA" leftmargin=8 bgcolor="#E0E0 <font face="Arial, Helvetica, Helv" size="3" color="#002288"><A NAME="I > <TR> <TD ALIGN=CENTER bgcolor="#E0E0E0"><font face="Arial, Helvetica <TABLE cellspacing=1 cellpadding=7 rules=GROUPS frame=BOX border=1 bgc ont></PRE> </TD> <TD ALIGN=RIGHT bgcolor="#D3D3D3"><PRE> <font face="A 000000"> 0</font></PRE> </TD> <TD ALIGN=RIGHT bgcolor="#D3D3D3"> </font><SCRIPT LANGUAGE="JavaScript"> <!-- // This script is to load al   so kindly help on this issue    thanks & regards  Rohit Krishna     ... View more