Hi, I want to know that if i have data in excel file and i want to get only selected data out of it to make a dataset so can we use where statement in proc import. ? if not then how can i import selected data out of excel file ? ... View more

thanks for explaining. I Understood how does @ works. ... View more

Hi Reeza,   I am new to sas. Can you tell me the function of @ and : in sas programming. I am not exactly able to get it.   Thanks ... View more

Thanks ... View more

Hi Naveen,   In the raw data below   1 Ram 25,000 40%   2 XYZ 31,000 25%  3 ABC 42,000 46%  4 MMN 52,000 20%    I want to get table like below   First column: ID Second Column: Name Third Column: Incentive although it is the fourth column in Raw data Fourth Column: Salary, although it is the third column in Raw data that also without comma.   How to do it ? ... View more

My code is below   data new; infile "F:\Raw.txt"; input Id Name $ +7 Incentive : percent. Salary $ 6-12; run;   i have attached my raw file. I want to know how should i remove comma from salary. I have considered incentive after name and want to mention salary after incentive. Although in the raw data the sequence is different.  ... View more