Thanks my problem got solved. Mainly by first using file import as .csv and then putting in the right format which was ddmmyy10. Thanks to all the people for giving valuable suggestions and feedback.
... View more
My original data looked like below : couponexpiry 20-02-2014 21-02-2014 22-02-2014 23-02-2014 via using import command
proc import datafile ='/folders/myfolders/grocery_coupons.xls' out=class5.grocery_coupons dbms=xls replace;
sheet= "Data" ;
getnames=Yes;
datarow=2;
run;
I got the table in SAS but my couponexpiry column came as below couponexpiry 41690 41691 41692 41693 as char format so i used the aforementioned code in earlier post to convert this into date type format. I could not understand what error or mistake I'm making which is giving me missing values, may be a silly mistake. Help required.
... View more
I have not got any error message. Only in output I am getting missing values. couponexpiry variable has dates in char format which i wanted in date format.
... View more
In my table grocery i'm having a variable named "couponexpiry" which has been imported into sas as a character, I am trying below code for converting it into date but in output only missing values I can see. Please help. What is wrong in code ??
data test1;
set class5.grocery_coupons;
date_exp=input(couponexpiry,date9.);
format date_exp date9.;
run;
... View more
While exporting my data set from SAS to a preferred location I am getting an error " Server file missing or invalid" Code is given below : proc export data= class2.grocery_coupons outfile= "D:\SASExport\grocery_coupons.xls"; run; I am new to SAS ,so help me in this regard.
... View more
The above solution stands good but what actually I'm looking for is to realign the whole table on basis of price where if price is less than 10 then that entire set should group as one set , then another set on price range of 10-20 and so on. The above solution just creates another column named as code and assign each row a vlaue on identification of price.
... View more
I am having a car sales data file. Wanted to berak the data set where it can give me groups on price ranges. Having price ranges between 1 to 50 . Want to create 4 groups of data 1-10, 10-20,20-30 and so on. How to do this via simple code.
... View more