Google finds lots of discussions on this topic. ... View more

I have had to read files that some creatively modified the rules for quotes for delimited text such that I had values like   column1, "Some text with, and " in the middle", 45.3, column4 text.   And those break almost every standard import tool.   Manually write a couple of lines similar to what I show (or you seem to want). Then use proc import to read the file. Or import into Access or some other data base as a CSV and see what you get.   One might ask what you will do with the resulting file.   ... View more

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

Hi,   You can use following SQL query:- proc sql; create table want as select * from have t1 where end_time=(select max(end_time) from have t2 where t1.term=t2.term and t1.classday=t2.classday and t1.room=t2.room group by term,classday,room); quit; Please let me know if it helps you.   Regards, Abd. ... View more

@lokeshbm wrote: I now wanted to remove those strings{not pre post text,only the above mentioned words} from the dataset .       I can't see any list of mentioned words or characters. You need to define those.  Then you can use a combination of translate or transwrd functions.  Regular expressions can probably help as well. ... View more

Then I would write a macro like %macro insert_va(var,as,cond); %if &cond = 1 %then %do; , &var as &as %end; %mend; Now you can write the select part of your SQL as a succession of macro calls, using different conditions for different variable groups. Set the conditions as macro variables before the SQL, and the rest automates itself. And you avoid complex code. Another version of the macro might be %macro insert_va(var,as,condcode); %if &global_cond = all or &globalcode = &condcode %then %do , &var as &as %end; %mend; This lets you set a specific condition for each variable, and if &global_cond is set to all (note no quotes), all variables are included.     ... View more

If you have a SAS 9.4 platform installation then you may have SAS Environment Manager which can be configured to montitor resources such as disk space utilization, and generate alerts with an escalation scheme. Some resources that may be of interest to you if you want to use this approach: SAS Global Forum Paper 463-2013: Monitoring 101: New Features in SAS 9.4 for Monitoring Your SAS Intelligence Platform SAS Blog Post: Monitor your SASWORK directory from SAS Environment Manager SAS Environment Manager 2.5: User's Guide including Example: Defining an Alert for SAS Work Directory Space   ... View more

It can be done efficiently with a data step, using an array:   data have; input Company : $8. Revenue Year; cards; HP 100 2012 HP 200 2013 HP 300 2014 Sun 200 2011 Sun 400 2012 Sun 500 2013 Sun 800 2015 <- Skipped 2014 Apple 150 2014 Apple 250 2015 Google 120 2010 Google 190 2011 Google 320 2012 Google 440 2013 ; proc sort data=have; by company year; run; data growth; set have; by company; array _r{1950:2050} _temporary_; if first.company then call missing(of _r{*}); _r{year} = revenue; if last.company then if not missing(_r{year-3}) then do; growth3y = (revenue-_r{year-3}) / _r{year-3}; output; end; format growth3y percentn8.2; run; proc print data=growth noobs; run; ... View more

Hi,   You can align it to Right so that it will have leading blanks. But will it solve your query.Could you please elaborate your exact problem with more details. Following code can align value of selected variable to right.   data person; infile datalines delimiter=','; input name $ dept $ value value1; datalines; John,Sales,-200,200 Mary,Accounts,-500,300 Johny,Sales,-200,200 Mak,Accounts,-100,100 ; run; data person; set person; name=right(name); dept=right(dept); run; ... View more

Hi   We get the solution of that problem. in precode create the bakup of account_bal table and write the following code in postcode.  %macro etls_jobRCChk; %if (&job_rc le 5) %then %do; proc sql; drop table ACCOUNT_BAL_bkp; quit; %end; %mend etls_jobRCChk; %etls_jobRCChk;   ... View more