Hi Community, I was given a text file named have_2.txt with 37 variables and over million records (a sample is attached). I need to read it into SAS. Some variable names of have_2.txt file were having two or more standing alone words. So, I have manually changed those names by putting an “underscore” in between like below. Originally I changed Loan number Loan_number ------ ---- Days Star Onn (oldest Amb) Days_Star_Onn_oldest_Amb The revised file is named as have_3.txt (attached). Q1: Does this manual name changes in text file affect my final SAS data file Q2: To read the data into SAS, I have tried below code but honestly not having full knowledge about what is happening internally. This code reads the data into SAS but values of some variables are truncated. I would really appreciate it if anyone of you could help me to develop the most accurate code. libname a "C:\MNS\"; Data a.test; LENGTH       Categor $ 18 /*length of this variable was set at $18 by trial and error, otherwise values under this variable are truncated*/ ABBRV_name  $ 41; /*length of this variable was set at $41 by trial and error, otherwise values under this variable are truncated*/   Infile "C:\MNS\have_3.txt" firstobs=2 dlm="," dsd LRECL=4096 truncover TERMSTR=CRLF;   Informat Account_date ddmmyy10.    Date_cancel  ddmmyy10. Date_Of_Firs_Deposit ddmmyy10.;   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 $ ;   Format Account_date date9.  Date_cancel date9. Date_Of_Firs_Deposit date9.; run;      Mirisage ... View more

Hi community, I have to run a same SAS program everyday having macro definitions like below. %let CDATE=May08; (lets call this eq. 1) %let PDATE=May07; (lets call this eq. 2) Then macro variables named &CDATE and &PDATE  are used in several places across the SAS program. Right hand side of eq. 1 refers to yesterday. Right hand side of eq. 2 refers to day before yesterday. I am manually changing the right hand side of the eq. 1 and eq. 2 everyday. I have a feeling that %sysdate automatic macro variable can be used to automate the process but fear it might upset everything in my organization. Any help to automate the process is highly appreciated. Mirisage ... View more

Hi Community, I have a data set “data.txt” (“txt” is the extension name) It has 37 variables and 1.3 million customers (records) I just opened the data set, and it automatically opened in notepad. The "Heading record" is found as a continuous string like below. "Bank number","Start date","Branch number","Person name", “Balance", and so on……. (note that names of some variables are having spaces) Each record of descriptor portion is also found as a continuous string as follows, seperated by commas. 77,22/2/2011 0:00:00,6,"JOHN JOSEPH", and so on…… First of all, I need to run some descriptive statistics in SAS and get some feel about the data set. I have given the following command to read the data set in SAS. data test;      infile 'H:\Model_Building\data.txt' firstobs=2 dlm='09'x dsd;      input Bank number Current date Branch number Short name Balance ........ ; Run; My question Is this approach correct? Name of a single variable has two names (how to handle this?) Help is highly appreciated. Thank you Mirisage ... View more

Hi Colleagues; I have a material deprivation data set having over 18,000 observations. The two variables of interest are like below. Data Deprivation; Input CDN DQ; Cards; 1350 2 2840 1 2745 3 9358 4 6570 2 1241 1 8759 5 3570 5 ; Run; CDN = Census Division Number DQ = Deprivation Quintile Question I need to categorize CDNs by DQs. In other words, I need to identify what are the CDAs falling under each deprivation quintile. For instance, the output should be like this. DQ CDN 1 2840, 1241 2 1350, 6570 3 2745 4 9358 5 8759, 3570 I searched literature on “Proc Tabulate” for over 8 hours but could not find. I wonder if anyone could help me to write the SAS code. Thank you Mirisage ... View more