About dash

dash · ‎08-31-2012

Hi I am running one program in the database. But getting error in log window as Invalid (or missing) arguments to the DATEPART function have caused the function to return a missing value. How to get rid of it. proc sql; create table x as select m.case_id, m.case_num,datepart(p.pat_dob) as pat_dob format =date9. from master as m, (select case_id, pat_dob from patient p where length(pat_dob_partial) in (11,17)) p where m.case_id = p.case_id; quit;

dash · ‎08-30-2012

Thanks linin for your great help

dash · ‎08-30-2012

Hi, I want to check whether sales date is greater than current date or not. How can I do I have written using oracle sqlra select sales_date, sysdate from sales where sales_date >sysdate How to write in sas

dash · ‎08-30-2012

Hello everyone, I have two variables for dates i.e. start date and stop date (along with time format) . To skip time, we are using trunc function. when I used the same , I got error like ERROR: Function TRUNC requires at least 2 argument(s). Can anyone help me as I am new. trunc(stop_date) >trunc(start_date) when I used datepart function , i got error like NOTE: Invalid (or missing) arguments to the DATEPART function have caused the function to return a missing value.

dash · ‎07-12-2012

Dear Reeza I have changed the length and format of test to match with test_master and still getting column as blank data test1; set test; format st_number $20.; run; data test1; length st_number $ 20; set test; run;

dash · ‎07-12-2012

Dear Reeza, Yes you are right. How can I do. For test, length is 17 and format is $17. For test_master, length 20 and format is $20. Advance thanks

dash · ‎07-12-2012

Thanks Reeza, When I am putting left join, then I am getting one column i.e. st_number as blank. Could you please help me how to solve as I am new.

dash · ‎07-12-2012

Hello everyone, I have imported 1 lakh data from Text file using proc import procedure into SAS environment and rename as test dataset (with column name st_number having data available like this LU2009CE2013 etc). Again I have connected to oracle database and export data into sas dataset (test_master) containing variable st_number, user_inf. dataset ---------> TEST---- st_number TEST_MASTER-st_number, user_inf I want to get the user information of TEST dataset containing strings. But why I am getting only single record in stead of 1 lakh. Can anyone help me proc sql; create table user_information as ( select * from test_master where st_number in(select st_number from test)); quit;

dash · ‎07-10-2012

Thanks Tom, But I am getting error. I am totally new to SAS. Could you please explain me in details. ERROR: The EXCEL engine cannot be found. ERROR: Error in the LIBNAME statement. libname out oracle user=scott orapw=tiger path=orcl ; libname in excel 'N:\abc\asd.xls'; data out.want ; set in.have; run;

dash · ‎07-10-2012

Hello Everyone!!! I am new to this forum. I want to create one table in oracle from SAS and then import 1.5 lakh records from excel. How is it possible. Can anyone help me Can I use import/export procedure. Please help me I tried using another approach but its not working. proc sql; connect to oracle as EXT1 (user=xx orapw=xxx path=xxxx); create table temp as Select * from connection to EXT1 (SELECT num_id from master where num_id in (1.5 recordsss..............)'); quit;

dash · ‎01-03-2012

Hi all, I have one table employee which contain name, loan, amount, date of loan(mm/dd/yyyy) variables. I want to check the persons who had taken loan on some date(like 23-dec-2011). Aslo how to write macro if i run the program daily proc sql; select name, loan, date from employee where datepart(date of loan) as loan= '23-dec-2011' format=date9. I am getting error Advance thanks

dash · ‎03-10-2011

Hi all, How can I calculate the age of patients from the date of birth. Thanks in advance

dash · ‎03-04-2011

Hi all, Can anybody tell me the difference between pass through facility and libname access method, proc report and proc tabulate. I am unabke to differentiate Thanks in advance

dash · ‎02-02-2011

Hi everybody, I am a newcomers. what are the efficacy, safety and derived variable. what are the safety and efficacy parameters taken if disease is taken as diabetes and alzheimer's disease. I have searched in the internet but till now not getting exact one. plz help.

dash · ‎01-28-2011

Thanks!!!!!!!!! Its running

Online Status	Offline
Date Last Visited	‎11-23-2020 10:07 AM

Re: Transpose the table and insert few column by look up

Transpose the table and insert few column by look up

Find discrepancy between two datasets

Re: Alternative function for extract non missing value from two column

Re: Alternative function for extract non missing value from two column

Alternative function for extract non missing value from two column

compress function not working

Re: Import CSV file with date and time

Import CSV file with date and time

find spl char in the string

Re: Transpose the table and insert few column by look up

Re: Transpose the table and insert few column by look up

Re: Alternative function for extract non missing value from two column

Re: Alternative function for extract non missing value from two column

compress function not working

Re: Erro in date format

Erro in date format

Re: enter sysdate in proc sql

enter sysdate in proc sql

problem in date function

Re: Not getting actual record using proc sql

Re: Not getting actual record using proc sql

Re: Not getting actual record using proc sql

Not getting actual record using proc sql

Re: Im

Im

need your help

Calculate age

difference

Efficacy, safety and derived variable for disease

Re