Hi, You can directly import the csv file using SAS Import wizard,and you can also see the code what sas is using internally in the log file or once import is done if you press F4 you will get the complete code what SAS has used internally in your editor. Hope it helps...     data WORK.ss                                      ;      infile 'F:\Community_SAS\have_3.txt' delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2 ;        informat Loan_number best32. ;        informat Account_date $19. ;        informat ABCDEF_number best32. ;        informat Current_number $12. ;        informat ABBRV_name $16. ;        informat Notifcation_type $4. ;        informat Regulati_code best32. ;        informat Office_code $4. ;        informat XXXX_code $5. ;        informat Seconda_Nameser_code $5. ;        informat Country_Name $19. ;        informat AXZREST_code best32. ;        informat Product_Code $5. ;        informat Localnal_nominclacation_code $3. ;        informat Date_cancel anydtdtm40. ;        informat Date_Of_Firs_Deposit anydtdtm40. ;        informat Days_Star_Onn_oldest_Amb best32. ;        informat Officerv_longe_name $5. ;        informat Closing_balance comma32. ;        informat Locatio $10. ;        informat Station $8. ;        informat XYZ_Limit best32. ;        informat XYZ_Balance best32. ;        informat Exitt best32. ;        informat Outstan best32. ;        informat Categor $16. ;        informat Rurald $33. ;        informat Dividee_DD_Names $11. ;        informat Opennq best32. ;        informat Regional_Grade_Numb $10. ;        informat Delinquency_Band $9. ;        informat Fiscal_Quarter $9. ;        informat Fiscal_Year best32. ;        informat Krrears_Sand $9. ;        informat BpplicationNumber $1. ;        informat SkkkkUsed $1. ;        informat Scccc_Band $1. ;        format Loan_number best12. ;        format Account_date $19. ;        format ABCDEF_number best12. ;        format Current_number $12. ;        format ABBRV_name $16. ;        format Notifcation_type $4. ;        format Regulati_code best12. ;        format Office_code $4. ;        format XXXX_code $5. ;        format Seconda_Nameser_code $5. ;        format Country_Name $19. ;        format AXZREST_code best12. ;        format Product_Code $5. ;        format Localnal_nominclacation_code $3. ;        format Date_cancel datetime. ;        format Date_Of_Firs_Deposit datetime. ;        format Days_Star_Onn_oldest_Amb best12. ;        format Officerv_longe_name $5. ;        format Closing_balance comma12. ;        format Locatio $10. ;        format Station $8. ;        format XYZ_Limit best12. ;        format XYZ_Balance best12. ;        format Exitt best12. ;        format Outstan best12. ;        format Categor $16. ;        format Rurald $33. ;        format Dividee_DD_Names $11. ;        format Opennq best12. ;        format Regional_Grade_Numb $10. ;        format Delinquency_Band $9. ;        format Fiscal_Quarter $9. ;        format Fiscal_Year best12. ;        format Krrears_Sand $9. ;        format BpplicationNumber $1. ;        format SkkkkUsed $1. ;        format Scccc_Band $1. ;     input                 Loan_number                 Account_date $                 ABCDEF_number                 Current_number $                 ABBRV_name $                 Notifcation_type $                 Regulati_code                 Office_code $                 XXXX_code $                 Seconda_Nameser_code $                 Country_Name $                 AXZREST_code                 Product_Code $                 Localnal_nominclacation_code $                 Date_cancel                 Date_Of_Firs_Deposit                 Days_Star_Onn_oldest_Amb                 Officerv_longe_name $                 Closing_balance                 Locatio $                 Station $                 XYZ_Limit                 XYZ_Balance                 Exitt                 Outstan                 Categor $                 Rurald $                 Dividee_DD_Names $                 Opennq                 Regional_Grade_Numb $                 Delinquency_Band $                 Fiscal_Quarter $                 Fiscal_Year                 Krrears_Sand $                 BpplicationNumber $                 SkkkkUsed $                 Scccc_Band $     ;     if _ERROR_ then call symputx('_EFIERR_',1);      run; Thanks, Shiva ... View more

Hi, See the definition from SAS DI documentation. The optimizer considers a hash join when an index join is eliminated as a possibility. With a hash join, the smaller table is reconfigured in memory as a hash table. SQL sequentially scans the larger table and performs row-by-row hash lookup against the small table to form the result set. A memory-sizing formula, which is not presented here, determines whether a hash join is chosen. Thanks, Shiva ... View more

Hi, data mydata; input var1 var2 var3 var4; xx=mean(of var1-var4); datalines; 1 2 3 4 1 3 1 6 4 5 8 9 2 8 2 2 ; run; proc sort data=mydata;by descending xx;run; Thanks, Shiva ... View more

Hi, Try this...is this what you want(Guess) data have1;   input Boarding_point $ Destination_point $ Distance_KM;   newvar=catx('',Boarding_point,Destination_point);   newvar1=catx('',Destination_point,Boarding_point);   xx=lag(newvar1);   if xx=newvar then output;   cards; Delhi                Mumbai                    2000 Mumbai               Delhi                     2000 Delhi                Kolkata                   4000 Kolkata              Delhi                     4000 Mumbai               Kolkata                   6000 Kolkata              Mumbai                    6000 ; run; ... View more

Hi, You can just try reading about  Setting Options for Parallel Processing in SAS DI documentation. Thanks, Shiva ... View more

Hi, I am not able to understand copy and paste transformation. If you want your job or input/output tables to copied then you can make .spk file and import where ever you want . If the transformation is a generated transformation then you can specify your own path and transformation will be saved and you can use this by just drag and drop in your jobs. Thanks, Shiva ... View more

Hi, Check in this path... C:\SAS\Config\Lev1\AppData\SASContentServer\Repository\repository Thanks, Shiva ... View more

Hi, You can try: Job properties-options->enable parallel processing macros(Macros code are generated at the top of the job code then you can write your code) If you use Loop transformation these macros are generated default(you can find more info in Documentation). . Thanks, Shiva ... View more

Hi, You can try in this location of you webserver: /SASContentServer/repository/default/sasfolders or Rightclick on the SAS folder properties in SASMC and Check for the WEBDAV location and Base path. Thanks, Shiva ... View more

Hi Mike, Check the SAS documentation for proc olap. If you have OLAP cube studio then no need of writing code. http://support.sas.com/documentation/cdl/en/olapug/59574/HTML/default/viewer.htm#a002605129.htm Thanks, Shiva ... View more

Hi ken, Check this link and Example 5.Hope it helps. http://support.sas.com/documentation/cdl/en/odsug/61723/HTML/default/viewer.htm#a003152286.htm Thanks, Shiva ... View more