10-18-2020
ashutosh83
Fluorite | Level 6
Member since
05-16-2017
- 3 Posts
- 5 Likes Given
- 0 Solutions
- 0 Likes Received
-
Latest posts by ashutosh83
Subject Views Posted 2421 11-22-2018 07:38 AM 2506 11-21-2018 09:12 AM 1667 05-03-2018 09:01 AM -
Activity Feed for ashutosh83
- Liked PROC REPORT Next Steps for JaneEslinger. 10-16-2020 01:03 AM
- Posted Re: Reading imported date value in SAS and using SQL to query that USing SAS EG7.1 on SAS Programming. 11-22-2018 07:38 AM
- Posted Reading imported date value in SAS and using SQL to query that USing SAS EG7.1 on SAS Programming. 11-21-2018 09:12 AM
- Liked Re: Arrays for novinosrin. 11-14-2018 09:13 AM
- Liked What is the difference between Missover and Truncover? for Cynthia_sas. 05-29-2018 09:32 AM
- Liked Re: Calculating a new column for SuryaKiran. 05-04-2018 06:26 AM
- Liked Re: How do I insert one or many copies of a row based on a condition while incrementing a variable for novinosrin. 05-03-2018 11:04 AM
- Posted Re: How do I insert one or many copies of a row based on a condition while incrementing a variable on SAS Programming. 05-03-2018 09:01 AM
-
Posts I Liked
Subject Likes Author Latest Post 3 1 2 2 1
11-22-2018
07:38 AM
Yes while importing the file I changed the source_informat to anydtdtew. and it resolved the issue. Still not sure how it did . data a; input date1 anydtdte.; datalines; 1/31/2011 4:42:40 AM ; run; proc sql; select date1 as date2 format date9. from a where date1 eq "31jan2011"D; quit;
... View more
11-21-2018
09:12 AM
Hi all, I have some date in excel it have column date1 as 1/31/2011 4:42:40 AM when imported in SAS with format date9. it's shows as 31Jan2011 when I see the unformated value it's like 18658.196296. when I query the table it does not return any record. data new; format date1 date9.; input date1; datalines; 18658.196296 ; run; /* But when I use below query the table it did not return any record*/ proc sql; select * from new where date1="31jan2011"D; quit; In Excel: Data1 1/31/2011 4:42:40 AM data new; format date1 date9.; input date1; datalines; 18658.196296 ; run; Gives: date1 31Jan2011 But when I use below query the table it did not return any record proc sql; select * from new where date1="31jan2011"D; /*datepart is also not working*/ quit; Why this happening and how we can handle this.
... View more
05-03-2018
09:01 AM
This works for me : data test; set have; do i=unit_comp_order to max_unit_order; output; end; drop unit_comp_order; rename i=unit_comp_order; run;
... View more