About Pritish

Pritish · ‎11-21-2011

Hi, Even it worked for me! Here's what I have: data data01; input key col1; cards; 1 101 2 102 3 103 4 104 5 105 ; run; data data02; input key col1; cards; 1 101 <-- This col is same as previous dataset 6 102 7 103 8 104 9 105 ; run; data want; merge data01 data02; by key; run; Result Set: Key Col1 1 101 2 102 3 103 4 104 5 105 6 102 7 103 8 104 9 105 Do you have the same column name in all the tables? If possible provide example of what you have.

Pritish · ‎10-26-2011

Ksharp, Based on what you said, Index are not always useful. Can you suggest me good way for finding Null values from a column? I am using SQL statement in SAS right now. Do you think, using SAS statements will provide me the result faster?

Pritish · ‎09-27-2011

@Art and @Tom - Thanks for sharing the knowledge. @Peter, Well it depends on the business rules and requirements. I was writing some code and came up with this and was not able to think clearly on the solution. So that's the reason I came up with this question.

Pritish · ‎09-27-2011

Hi All, I know this is a very stupid question to ask, but I am bit confused with the following: How can I get the First Name and Middle Name in the same column and Last name in a different column? As I don't have double space before the last name so I can't use '&' in my INPUT statement. Data Sample; Input First_name $ Last_Name; Cards; Nadal Anthony Samuel John Beth Goodrich ; Run; Result: First_Name Last_Name Winston Anthony Samuel John Beth Goodrich Thanks for your help!

Pritish · ‎06-21-2011

Cynthia, Here's some additional information: This date is a part of my dataset and basically represent the modificationdate column. Regarding the datatype it is a "Character" variable. The dataset is residing in a SAS table. The reason why I want to convert the date to a date format is becuase, I want to compare the date with a specific date let's say today's date 06/21/2011. All the date values in the table have the same format. Here's few more example: Fri Feb 25 12:51:57 2011 Fri Mar 11 13:12:56 2011 Mon Mar 21 09:48:58 2011 Fri Apr 1 11:49:19 2011 Fri Apr 8 14:24:26 2011 Mon Apr 18 17:37:01 2011 Fri Apr 22 10:01:57 2011 Fri Apr 29 11:22:39 2011 Thu May 26 12:34:03 2011 Fri May 27 15:16:17 2011 The day of the week is a three (3) character long The month is represented in three (3) character only .. Sep .. Oct .. Nov Hope this helps!

Pritish · ‎06-21-2011

Hi, I am trying to convert following date into a simple format. Wed May 18 16:58:32 2011 I am looking to have something like this: May 18 2011 or 05/18/2011 Can anyone please guide me getting this sort of format?

Pritish · ‎06-21-2011

I thought the solution might help me with the date format I have but it didn't. So here's what I have: Wed May 18 16:58:32 2011 How can I get only the Month Date Year ?? For ex: May 18 2011. Can you please help me out?

Pritish · ‎06-07-2011

Is there any white space between the variables in the same cell?

Pritish · ‎06-02-2011

Darrylovia: DINFO will give me only the count of the items in a directory. Is that correct?

Pritish · ‎06-02-2011

@SASKiwi: I am using SAS EG 4.2. Even I checked the link that you had posted and it seems like for getting the data it is looking for / require a file name. My scenaio is like: The file get's dropped into the folder everyday but the file name might change everytime it get's loaded. So I am looking for something which is not dependent on the file name. Any idea?

Pritish · ‎06-01-2011

Shankar, I am looking out some solution for the same problem. Did you get any solutions on how it can be done? Message was edited by: Pritish

Pritish · ‎05-22-2011

Hi Raj, You can always refer to Oracle Discussion forums. Here's the link: http://forums.oracle.com/forums/forum.jspa?forumID=75

Pritish · ‎05-21-2011

how about using Proc Means to get what you are trying to? PROC MEANS NOPRINT DATA = TEST_01; OUTPUT MEAN=TOT_MEAN; RUN;

Pritish · ‎04-21-2011

Hi Sbb, Thanks for your reply. It was really helpful. For the Process_Time I did something like this: DATA _NULL_; FORMAT MYTIME TIME9.; YY = PUT(00,Z2.); MYTIME = INPUT(PUT(0820,Z4.)||YY, ND8601TM10.); PUT MYTIME=; PUT _ALL_; RUN; The reason why I am concatenating 00 is b'coz i just have "1820" or "0820" in my text file. Do let me know if you have better way of doing it. Thanks again. @ Everyone: Thanks for checking out and helping me. Really appreciate your time.

Pritish · ‎04-21-2011

Well, that's a good question Rick. I have both sort of values in my txt file. ex: 010911 and 100110 The date in the txt file are 6 digits in length.

Online Status	Offline
Date Last Visited	‎04-09-2021 09:47 PM

GLMSelect - Selection=Lasso | Selection=GroupLasso

Re: Displaying all Labels for X-Axis

Re: Displaying all Labels for X-Axis

Re: Displaying all Labels for X-Axis

Displaying all Labels for X-Axis

Re: SGPlot - Display Missing Category

SGPlot - Display Missing Category

Re: Plotting Data and output as PDF

Plotting Data and output as PDF

Re: Rollup data - conditional grouping

Re: Finding top variables (attributes)

Re: how to convert char var to sas date?

Re: Help with grouping

Re: que regarding proc standard

Re: what is the difference?

How to merge datasets and print a summary?

Re: PROC codes for tables

How to merge files with similar names in the same library

Running Proc SQL on Large DB (1b records)

Getting values in one column

Getting values in one column

Re: Converting a Date Format

Converting a Date Format

Re: 01JUN2011:00:00:00 Convert To SAS Date...

Re: importing excel-multiple variables in one cell

Re: Way to pick the latest file

Re: Way to pick the latest file

Re: Way to pick the latest file

Re: SQL Resources

Re: New to SAS, need help with calculating average

Re: Date & Time Conversion

Re: Date & Time Conversion