About ren2010

ren2010 · ‎11-01-2010

Hello all, I am a situation where i have dataset with two variables name and alias: Name Alias xxx_999_aa 999 vvv_156_bb 156 My requirement is to find the alias in the name,so as per below i need to find if 999 or 156 is present in names.I tried using the FIND function like the following; data test; set a; x=find(name,alias); if x > 0 then delete; run; but this does not seems working as the value of the x is getting assigned as 0. Please help

ren2010 · ‎10-16-2010

Thanks SBB.

ren2010 · ‎10-15-2010

Hi, I have a pipe( | ) delimitted file and when i tried to import using import wizard the length of the a field is getting changed. for eg: in my pipe delimitted file ,i have the first field as cust id(length $ 100),but after the import ,the length of the field in sas dataset is cust id (length 20). Any idea why is this happening? Please help. Thanks in advance.

ren2010 · ‎09-24-2010

Hi, I read that mentioning COMPRESS=YES/CHAR/BINARY will save space but this will also casue a delay on CPU as it process the compressed dataset. So only compressing the final dataset in a program will be a nice idea rather than specifying COMORESS=YES in the begining of the program as it compress as work dataset and cause delays CPU process. So please let me know your thougts on this topic.

ren2010 · ‎09-24-2010

My code is below, and I am trying to convert a MMDDYY var to DATETIME19.,but getting unreasonable value. example: data _null_; x=today(); put x= date.; put x1= datetime.; run; This code produces the following: X=12/01/2010 X1=01JAN60:04:02:23 is there any way to avoid the non valid value of X1? Please help

ren2010 · ‎08-13-2010

Hi, Data temp; set input_file; run; Data Temp; Set Temp; if sal < 1000 then flag=1; run;. I know this works,but is this recommended? Please let me know your valuable comments. Thanks in advance.

ren2010 · ‎07-20-2010

Hi All, I have a file which has date fields(data is in text format eg:'20090112') for eg fromdate1,fromdate2,fromdate3, thrudate1 thrudate2 thrudate3. I wanted to run a proc freq on these date fileds,is it possible to include the proc freq in a do loop with in a macro? Thanks in advance.

ren2010 · ‎07-19-2010

A big THANK YOU to all of you for your suggestions,appreciate it.

ren2010 · ‎07-16-2010

Hi, my input file has the following data: date$ 20071206 20011102 20071009 i use the following: dt=input(date,yymmdd8.); but my output looks like 07-12-06 01-11-02 . 07-10-09 because of the "." i can getting error invlaid argument used in input statement. can anybody tell me how can i do this. thanks

ren2010 · ‎07-16-2010

Hi, I Have a character variable with comes with leading zeroes. ID 0111 0222 0333 my desired result: ID 111 222 333 Please help

ren2010 · ‎07-02-2010

Hi, I was trying to create a table using Proc Sql,but I am getting the follwoing error: "The width value for F is out of bounds. It should be between 1 and 32." My sql code converts two numeric fields to characters and .I have no clue why this error is comming. Please help me to resolve this error.

ren2010 · ‎06-24-2010

HI, Here is my code to call a macro variable: %let dd='tt','rr'; data gg; input id name $2.; datalines; 1 tt 2 rr 3 gh ; run; %macro file1(ts); proc sql; create table out as select * from gg where name in("&ts."); quit; %mend; %file1(&dd.); SAS is giving me an error saying multiple parameters in macro call,is there any way to pass the value without this error. Thanks in advance.

ren2010 · ‎06-18-2010

Once Again Thank you to Ksharp and Flip.

ren2010 · ‎06-18-2010

Hello All. Is there a way to see the contents of the sas Index file? Can i use proc contents ? Please let me know your opinions. Thanks in advance.

ren2010 · ‎06-11-2010

Thanks Flip and Khsharp, The sql mentioned in my email is working fine.I did not see any issues when i ran it.It looks for the associated ID and SAL,not just an entry because I am using AND if had used OR then it would have picked any entry in the lookup table. Once I set the dept =' ' then in the next data step I have to fix the dept values like this: if dept=cd; and this time I wanted to check if the value of cd is in lookup table if the value of the cd is in lookup table then i make the dept=NODEPT. Thanks once again for your suggestions.

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Numeric data

Numeric data

Splitting Text into different variables/columns

Splitting Text into different variables/columns

SAS Script to edit sas programs in a library

SAS Script to edit sas programs in a library

Re: how to pad character variable with leading zeroes?

Re: Length

Length

SAS Error

How to print the current date and time in the SAS Output window

How to remove leading zeroes from character variable

Finding String

Re: Proc Import:Data import issue

Proc Import:Data import issue

COMPRESS

How to convert to Datetime?

Use of same dataset

Proc Freq in a macro loop

Re: How to remove leading zeroes from character variable

how to convert character date to yymmdd8

How to remove leading zeroes from character variable

The width value for F is out of bounds. It should be between 1 and 32.

calling macro variable

Re: Macro variable and DATA step-Part 2

How to see the contents of an Index file?

Re: Macro variable and DATA step-Part 2