About PravinMishra

PravinMishra · ‎02-26-2015

Hi, I have a table called employee.Which have 10 different column or variable.I want to divide the table on the basis of column means 3 col or variable in each table. code should handel if the col or variable number increased by 1000+. Appreciate your suggestions. Thanks

PravinMishra · ‎01-15-2015

Hi, Please let me know how to generate ASCII value of a string value or number or a special character. for ex. Name Employee ID Address Ricky Martin 123456 #21,North Hampton Street-->15+45 let me know how to find the ascii value of each value in three column. and please let me know if there is any proc available in sas.

PravinMishra · ‎12-25-2014

I agreed on your concern.Even I have the same concern.But the data on which I am working belong to 2014 January month data. Due to which I am feeling little bit comfortable with the conversion. I appreciate your concern

PravinMishra · ‎12-25-2014

Thanks for your help and it's really helpfull.I achieved it by doing below. Let me if you see any loophole in my code. data auth; input AU_TRANS_DATE_JUL; datalines; 114010 14010 ; run; data req_date; set auth(keep=AU_TRANS_DATE_JUL reqt_hh reqt_mm reqt_ss); if AU_TRANS_DATE_JUL>100000 then auth_trans_date=tranwrd(put(dhms(datejul(1900000+AU_TRANS_DATE_JUL),reqt_hh,reqt_mm,reqt_ss),E8601DT21.),'T',' '); else auth_trans_date=tranwrd(put(dhms(input(put(AU_TRANS_DATE_JUL,6.),JULIAN6.),reqt_hh,reqt_mm,reqt_ss),E8601DT21.),'T',' '); run;

PravinMishra · ‎12-25-2014

Hi, It's in Julian format with six digit. there are function like Datejul which will help to convert it into Date.But that is for 5 0r 7 digit not for 6 digit.

PravinMishra · ‎12-25-2014

114010 date is 2014-01-10

PravinMishra · ‎12-24-2014

I am expecting an output in YYYY MM DD HH MM SS format.HH MM SS will taken care by reqt_hh,reqt_mm,reqt_ss variable.Let me know if you have any query.

PravinMishra · ‎12-24-2014

Hi, I am facing an issue regarding date conversion. I have a date which is in CYYDDD format It's nothing but a JULIAN format of the date. Date are given below 114010 14001 I need to convert this date into YYYYMMDD format But I can't see any function which can help to convert it required format. I am using below method to convert it.which helping me to convert 14001 in req format req_date=tranwrd(put(dhms(input(put(given_date,6.),JULIAN6.),reqt_hh,reqt_mm,reqt_ss),E8601DT21.),'T',' '); Please let me know how to convert first julian date

PravinMishra · ‎12-15-2014

I have used below code and it's working fine. data join_one/view=join_one; set oil.oil; run; data join_two/view=join_two; set ocb.ocb; run; data out.join_vw/ view=out.join_vw; set join_one join_two; run; data join_out; set out.join_vw; run;

PravinMishra · ‎12-15-2014

Hi, I have two SAS table one and two.both the table having some same column and some different col.I need to append the data and create a single dataset. on top of that I need to create view on the combine table. I am using below code but not able to do it. data join / view=one.join_vw; set one two; run; its throwing an error ERROR: The requested type of view (Input or Output) cannot be determined. let me know anyone have any solution for this. further I need to access the view for different process. can I would be able to access the view as it is created on two different table. Thanks;

PravinMishra · ‎11-06-2014

Hi, It's time varaiable and time is calculated in hrs. as sas stored it in numerical value starting from 1Jan 1060.

PravinMishra · ‎11-04-2014

Hi Jaap, Below is the error. ERROR: Not enough memory for all variables. Variable RAR_ENTERED_ACCT removed after 3470836 levels. ERROR: The SAS System stopped processing this step because of insufficient memory. Below is the Code which I am running proc freq data=SRS_AUTH_201302 noprint; &num_freq; run; &num_freq is a macro variable having last of 45 variable with proper syntax.

PravinMishra · ‎11-03-2014

Hi I have a date value 19370 19375 i would Like to convert it in 12JAN13:00:00:00 17JAN13:00:00:00 I am using below piece of code but it's not working tranwrd(put(dhms(datepart(ldate),0,0,0),E8601DT19.),"T",""); Thanks

PravinMishra · ‎10-30-2014

Hi Reza, I am also not sure just trying to figure it out. I put all analysis and out in my question. Thanks

PravinMishra · ‎10-30-2014

Hi, I have a table in which time is in num 8 and format time8.. I am trying to convert it in to HH:MM:SS AM/OM format. When I am using below code data test1; infile datalines; length time 6. time1 6.; input time 6. time1 6.; format time time12. time1 timeampm.; datalines; 464633 464633 464628 464628 464632 464632 464624 464624 464634 464634 464632 464632 ; run; OUTPUT is: Time Time1 129:03:53 12:54:23 PM 129:03:48 12:54:22 PM 129:03:52 12:54:23 PM 129:03:44 12:54:22 PM 129:03:54 12:54:23 PM 129:03:52 12:54:23 PM For below code output is data test1; infile datalines; length time 6.; input time 6. ; format time time8.; datalines; 464633 464628 464632 464624 464634 464632 ; run; OUTPUT Time 129:03 129:03 129:03 129:03 129:03 129:03 and same variable is giving me below output data test1; infile datalines; length time 6.; input time 6. ; format time timeampm.; datalines; 464633 464628 464632 464624 464634 464632 ; run; 9:03:53 AM 9:03:48 AM 9:03:52 AM 9:03:44 AM 9:03:54 AM 9:03:52 AM Can anyone let me know which one is the correct one and how to convert Time into HH:MM:SS format. My objective is to concatenate date and time field together?

Online Status	Offline
Date Last Visited	‎04-07-2017 11:01 AM

Re: extracting first few digits from a numeric variable

Sub setting the data set

User define end of line character

How to read Big Endian format in sas

Re: view creation error?

Re: view creation error?

view creation error?

How to create sas views with more records?

Re: Read Pipe Delimited File

Re: Read Pipe Delimited File

Re: extracting first few digits from a numeric variable

How to generate ASCII value of string or number or special character

Divide the table on column

How to generate ASCII value of string or number or special character

Re: how to convert Julian to YYYY MM DD ?

Re: how to convert Julian to YYYY MM DD ?

Re: how to convert Julian to YYYY MM DD ?

Re: how to convert Julian to YYYY MM DD ?

Re: how to convert Julian to YYYY MM DD ?

how to convert Julian to YYYY MM DD ?

Re: How to create single view on multiple table and access it?

How to create single view on multiple table and access it?

Re: Time format Issue

Re: Proc Freq Out of memory issue

Convert numeric to datetime stamp

Re: Time format Issue

Time format Issue