About Daya87

Daya87 · ‎06-06-2017

Hi All, I want to Convert the date/time from ISO8601 format to hour Format Please help on this. I have data like name Date1 Date2 XYZ 2016-10-03T13:05 2016-09-26T12:35 ABC 2016-07-15T12:00 2016-10-18T11:30 BAC 2016-10-26T12:00 2016-08-10T10:45 CAB 2017-06-02 2016-09-26T11:30 BDG 2016-06-23T14:00 2016-10-18T09:28 I require the output in two variables Hour1 and Hour2 Thanks in advance Regards Daya

Daya87 · ‎05-03-2016

HI All, Please help me on this. I have dataset with a variable name. NAME Alice James Jeffrey Joyce Barbara The above given observation's present in a PDF document. 1. Alice present in page number 4 and 5. 2. James present in page number 3 3. Jeffrey present in page number 1, 2 and 3 4. Joyce present in page number 2 and 3 5. Barbara present in page number 1 So i want an output dataset like NAME NUMBER Alice 4, 5 James 3 Jeffrey 1, 2, 3 Joyce 2, 3 Barbara 1 Note:- If more than one page number , should be seperated with ", " in output. Thanks in Advance. Regards Daya

Daya87 · ‎03-09-2016

Yes, It's working Fine. Thanks a lot.

Daya87 · ‎03-09-2016

I Have a Data Like below table. I Just Had only name and Grade. Need to create All_Grades(Individual Grades should come seperated by "-") Name Grade All_Grades Alfred A A-B-C-A-D Alfred B A-B-C-A-D Alfred C A-B-C-A-D Alfred A A-B-C-A-D Alfred D A-B-C-A-D James B B-C-A James C B-C-A James A B-C-A Philip D D-C-A-A Philip C D-C-A-A Philip A D-C-A-A Philip A D-C-A-A William A A-A-C William A A-A-C William C A-A-C Thanks in advance

Daya87 · ‎05-04-2015

Really today you guys made my life easy. Thanks Loko, Mark Johnson, Xia Keshan and Slchen for the valueble suggetions and fast response on this discussion.

Daya87 · ‎05-04-2015

Hello, I just require the First letter in varible value in Uppercase and 2nd letter in variable value should be in lower case, it should continue till the end letter of the variable value. /********************I have a the data like this *****************/ Data Have; Input Name $ 30.; cards; abcdefhg ghfedcba IJKLMNOP qtunvjrf FgYhbder ; /************************The output Should be like below**************/ NAME AbCdEfGh GhFeDcBa IjKlMnOp QtUnVjRf FgThBdEr Please help me on this .

Daya87 · ‎04-19-2015

Thanks a lot, It's working Fine.

Daya87 · ‎04-18-2015

Hi Everyone, I have the Data in the below structure, I just want to check A variable numbers in B variable List. If the A variable Number not found in B variable I need that non matching record in output. Sno A B 1 1 1,2,3,4,5,6,7,8,9,10 2 2 1,2,3,4,5,6,7,8,9,10 3 4 1,2,3,4,5,6,7,8,9,10 4 5 1,2,3,4,5,6,7,8,9,10 5 1,2 1,2,3,4,5,6,7,8,9,10 6 2,6 1,2,3,4,5,6,7,8,9,10 7 3,8 1,2,3,4,5,6,7,8,9,10 8 0,11 1,2,3,4,5,6,7,8,9,10 9 12,8,18 1,2,3,4,5,6,7,8,9,10 Note;- Both variables in Character. Here i am supposed to get 8th and 9th Observation in output.Please help me on this.

Online Status	Offline
Date Last Visited	‎10-17-2024 06:47 AM

Conversion of ISO8601 date format to Hour format

Getting the page numbers from PDF

Re: Getting all the values in a single variable

Getting all the values in a single variable

Re: Converting the case of letters in a variable

Converting the case of letters in a variable

Re: Comparison between two variable........

Comparison between two variable........

Re: Getting all the values in a single variable

Conversion of ISO8601 date format to Hour format

Getting the page numbers from PDF

Re: Getting all the values in a single variable

Getting all the values in a single variable

Re: Converting the case of letters in a variable

Converting the case of letters in a variable

Re: Comparison between two variable........

Comparison between two variable........