topic Re: time in SAS Programming

time

mehak — Sat, 21 Oct 2017 19:18:59 GMT

Can anyone please tell me how can i subset the data after a given date . I think i have to use date fn . But dnt know how to keep date in a conditional statement how to find variable informat . ?

Re: time

Kurt_Bremser — Sat, 21 Oct 2017 19:41:57 GMT

Your pidgin english makes no sense. Please post your question in clear, understandable language.

Re: time

mehak — Sat, 21 Oct 2017 19:45:41 GMT

how can i seperate out the data launged after 20 jan 1990 from vechiles

Re: time

kiranv_ — Sat, 21 Oct 2017 19:51:50 GMT

date gt '20JAN1990'

Re: time

Kurt_Bremser — Sat, 21 Oct 2017 19:52:26 GMT

Please post some example data, and which rows you want selected/not selected.

Basically, you can use a where condition or a subsetting if.

Re: time

mehak — Sat, 21 Oct 2017 20:01:31 GMT

i have attached the sample data set . Can you please know tell me how can i seperate out data for passangers vehicles launced after 20 jan .

Re: time

mehak — Sat, 21 Oct 2017 20:02:42 GMT

sir i want to get all the date after 20 jan . Then what i should do ?

Re: time

Reeza — Sat, 21 Oct 2017 20:47:38 GMT

You should read this chapter.

http://documentation.sas.com/?docsetId=lrcon&docsetTarget=p1wj0wt2ebe2a0n1lv4lem9hdc0v.htm&docsetVersion=9.4&locale=en

You can filter dates with a standard IF/WHERE statement, but you need to use dates with the proper format.

'01JAN2017'd -> note the quotes, 3 letter month, and d after the quotes

data want;
set sashelp.stocks;

where date > '01Jan2000'd;

run;

Re: time

error_prone — Sun, 22 Oct 2017 04:53:39 GMT

You have attached a csv-file, not a dataset. Please post the code you wrote to import that file.

Re: time

mehak — Sun, 22 Oct 2017 06:07:59 GMT

libname _class_s "/folders/myfolders/ 1";

PROC IMPORT DATAFILE="/folders/myfolders/1/Car_sales.csv"
		    OUT=_class_s.Car_sales
		    DBMS=csv
		    REPLACE;
RUN;

I have used the above code to import the file and it has import succesfully as i am able to see all the data present in my car file.

Re: time

andreas_lds — Sun, 22 Oct 2017 09:08:29 GMT

proc imports recognizes Latest_Launch as SAS-date, so use the example code posted by @Reeza.