This is some basic question. My code... data Uniquepolicy; set Sortedpolicy; By POLICY_SK; MAX_TRAN_SEQ_NUM= last.TRAN_SEQ_NUM; run; Sortedpolicy has variables POLICY_SK and TRAN_SEQ_NUM.It was sorted by POLICY_SK and then by TRAN_SEQ_NUM.I wanted all Policy_SK with largest TRAN_SEQ_NUM. I am getting same number of obs. in the new table Uniquepolicy. Please help. ... View more

I have a Unix SAS Account (SAS 9.1) . I have a Mainframe account.How do I get data from mainframe to SAS? Right now I can only view what is inside the mainframe.I need to pull the data. Anybody have any idea? Thanks ... View more

I have 2 data sets like these. Data set 1 Product, Seg, ID, Loc_cd, A1, SER, 200, 1 A2, OFF, 100, 1 A2, OFF, 100, 2 A2, OFF, 300, 1 A1, OFF, 101, 1 A1, OFF, 102, 2 A2, OFF, 101, 2 Dataset Price Product, Seg, Price A1, SER, 20 A1, OFF, 30 A2, SER, 40 A2, OFF, 50 What I need to do is to add another column in Dataset 1 named "Price". Which basically look Product and Sgments. When I do Left Join, It is taking cartician product including Loc_cd.The uniqueness of data in dataset 1 is Columns Product,Seg and Loc_cd.Is there any way I can solve this? Thanks ... View more

I have the following code, PROC IMPORT OUT= WORK.Data DATAFILE= "/home/rtp00//DataSets/Data.csv" DBMS=CSV REPLACE; GETNAMES=YES; DATAROW=2; PROC IMPORT OUT= WORK.Pc_factors DATAFILE= "/home/rtp00/DataSets/PC factors.csv" DBMS=CSV REPLACE; GETNAMES=YES; DATAROW=2; PROC IMPORT OUT= WORK.Class_base_rates DATAFILE= "/home/rtp00//DataSets/ClassBaseRates.csv" DBMS=CSV REPLACE; GETNAMES=YES; DATAROW=2; PROC SQL; CREATE table Work.Impact as SELECT Data.Product,Data.Seg,Data.Company,Data.Building,Class_base_rates.Class From Data LEFT OUTER JOIN Pc_factors ON Data.ProtCd=Pc_factors.ProtClass And Data.Seg=Pc_factors.Segments LEFT OUTER JOIN Class_base_rates ON Data.Product=Class_base_rates.Product AND Data.Class=Class_base_rates.Class ; Quit; This is showing an error . It says"ERROR;Expression using equals (=) has components that are of different data types" I can not spot any error. My second question is , in the above query, all the datasets are importing from csv files. How can I format the variables? for example the variable Class is to be numeric? Thanks. ... View more

Hi, Recently I started learning SAS. I have Excel 2007 in my PC. I am using Unix SAS. Is there any way I can read Excel file from my local PC in Unix SAS? I have also WIN SCP installed in my computer.My colleague was saying that I need to use PC SAS. Is that true? ... View more