Hi , I have also got the same error, but I could rectify when only there are no duplicates for the year value. (But i know that it is wrong) After doing that I got another error: when there is missing values for any observation the model we are applying is not accepting. Please the check the combination of ID statement. Sorry, i don't have any idea with these kind of analysis.
... View more
Hi, ANYDTDTEw. Reads and extracts the date value from any of the following: DATE, DATETIME, DDMMYY, JULIAN, MDYAMPM, MMDDYY, MMxYY*, MONYY, TIME, YMDDTTM, YYMMDD, YYQ, YYxMM*, month-day-year Try anydtdte11. in your case.
... View more
Hi Reeza, Thank you for the reply, can we calculate the percentages in the same step? data set : Output dataset: value count value count a 58 a 58 b 42 b 42 z 100 ------> This is the sum of above two observations.. I want to do it in sql procedure... Thank you.. Durga
... View more
Hi all proc freq data=sasuser.flightdelays noprint; by date notsorted; tables origin*destinationtype /out=delay; run; how to re-write this same code with using proc sql; please help me out to write the code... i want to learn proc sql in easy way to. Thank you all in advance..
... View more
Hi SeanZ, there will be a supporting variable for company name in numeric (i think) if it is in this cases. check for that variable which will have some code for each company; if there no such thing just make it through hard coding like, if companyname='management' then companycode=1 in both datasets then you can merge them by this new variable created. -- Durga.
... View more
Hi, Thank you for you both.. the suggestion helped to gain knowledge. but, as of software issue i couldn't make Anca's procedure. Thank you Again. -- Durga.
... View more
Hi Aman, I think this code might help you.. please change the data set name as per your records.. proc report data=bank nowd; column acctype (branch,amount); define acctype / group; define branch / across; define amount / sum ; run; -- Durga.
... View more
Hi Anca, Thank you. I have got a message error : Cimport cannot read the Xport file (something related like this.. don;t remember exact thing) i will try it and let you know..
... View more
Hi every one , I have a xls file, but I have to do it without proc import procedure and DDE triplet. I have to use only "infile and data step" please help.... .
... View more
Hi Everyone, Any data step or procedure that .xpt file can be taken from system environment to sas environment. Example: i have vsn.xpt file in my D;\ drive. I have to import it to my sas library as dataset. Thanks in advance..
... View more
