The attached NCDebt.csv file is the input file for the code in the attached .txt file labelled "Code." The code runs the way that I want it to, but I have the following item that I need to address. The "Desired Output.txt" file is not generated by the code, however, it holds the structure that I want my Code-generated output to follow; you will notice similarities in the structure of the output generated once you run the code and the structure of the contents in the "Desired Output.txt file." My problem is that I cannot think of a way to write SAS code such that I can add the 'end' line found at the bottom of the Desired Output.txt file. I have commented out the "End='end'" line in the second datastep of my Code (this was my last ditch effort); when I transpose in the proc step, however, I am still stuck with the variable name End, which I don't want. Ideally, I would have a blank in the variable name and retain the value 'end.' Any takers? ... View more

I am trying to import the column in the attached file into SAS; I have been using the following code and I am getting an error in the input line. I am using SAS 9.2; could someone provide some insight as to why this doesn't work? data WORK.NCDebt;      infile '/SourcePath/Example.csv'; informat Maturity yymmdd8.; format Maturity yymmdd8.; input Maturity :yymmdd8.; run; ... View more

Does anyone know if there is a way (ie SAS command) to insert a new variable between existing SAS variables in a dataset? For example I have the following dataset...... Name     Age Tom         10 John        18 Jill            23 Chris        25 Don          31 ......and I want to end up with the dataset below. Name     Sex     Age Tom         M        10 John        M        18 Jill            F         23 Chris        M        25 Don          M        31 ... View more

I have the code below which I am using to import the attached .csv file into SAS; I would like to retain whatever variable headings as SAS variable names (not all columns in the .csv file have a title). My biggest issue with the code below is that, as you can see, once imported into SAS, the variable values in the input statement below have their values overlapping with each other. Seeing that my variable values are of varying lengths, my data gets really ugly. Is there a neat way to import my variable values and preserving their values intact? data WORK.NCDebt;      infile '/Source/InputFileNCDebt.csv' dsd; input Var1 $10. Var2 $11-20 Var3 $21-30 Var4 $31-40 Var5 $41-50; run; ... View more

I have the following code which I managed to run and get desirable results. I did not expect to be able to run the code below, however, because I do not use the %eval() function when evaluating the ratios in the last datastep. Without the %eval(), shouldn't the ratios be evaluated as characters and shouldn't I be getting an ERROR as a result? Could someone please provide a sanity check? %macro count_runoff_all; %do i= 1 %to 9; proc sql ;   select count(psts3)      into :n_def_runoff&i. from runoff_all&i where psts3="n6"; quit; %end; %put n_def_runoff1 value is: &n_def_runoff1; %put n_def_runoff2 value is: &n_def_runoff2; %put n_def_runoff2 value is: &n_def_runoff3; %put n_def_runoff2 value is: &n_def_runoff4; %put n_def_runoff2 value is: &n_def_runoff5; %put n_def_runoff2 value is: &n_def_runoff6; %put n_def_runoff2 value is: &n_def_runoff7; %put n_def_runoff2 value is: &n_def_runoff8; %put n_def_runoff2 value is: &n_def_runoff9; data default_runoff_all; set runoff9; randv=rand("Uniform");     if randv < &n_def_runoff1/&n_def_runoff9 then quarter = 1;   else if randv < &n_def_runoff2/&n_def_runoff9 then quarter = 2;   else if randv < &n_def_runoff3/&n_def_runoff9 then quarter = 3;   else if randv < &n_def_runoff4/&n_def_runoff9 then quarter = 4;   else if randv < &n_def_runoff5/&n_def_runoff9 then quarter = 5;   else if randv < &n_def_runoff6/&n_def_runoff9 then quarter = 6;   else if randv < &n_def_runoff7/&n_def_runoff9 then quarter = 7;   else if randv < &n_def_runoff8/&n_def_runoff9 then quarter = 8;   else quarter = 9;   n_def_runoff1_ratio=&n_def_runoff1/&n_def_runoff9;   n_def_runoff2_ratio=&n_def_runoff2/&n_def_runoff9;   n_def_runoff3_ratio=&n_def_runoff3/&n_def_runoff9;   n_def_runoff4_ratio=&n_def_runoff4/&n_def_runoff9;   n_def_runoff5_ratio=&n_def_runoff5/&n_def_runoff9;   n_def_runoff6_ratio=&n_def_runoff6/&n_def_runoff9;   n_def_runoff7_ratio=&n_def_runoff7/&n_def_runoff9;   n_def_runoff8_ratio=&n_def_runoff8/&n_def_runoff9;   /*drop fcst_mon draw randv n_def_runoff1_ratio n_def_runoff2_ratio n_def_runoff3_ratio n_def_runoff4_ratio n_def_runoff5_ratio     n_def_runoff6_ratio n_def_runoff7_ratio n_def_runoff8_ratio;*/ run; %mend; %count_runoff_all; ... View more

I have to run three macros; each defined by extensive pieces of code (filename1, filename2, filename3). Rather than creating one large file with everything (which makes it extremely difficult to debug), I was wandering if I could use the %include statement in a seperate macros to run my other three macros one after the other. I have the following code; could someone with more exprience with the %include statement please provide a sanity check, because this doesn't seem to be running. %macro MainMacro;       %include '\filepathmaindirectory\filepathsubdirectory\filename1';       %include '\filepathmaindirectory\filepathsubdirectory\filename2';       %include '\filepathmaindirectory\filepathsubdirectory\filename3'; %mend MainMacro; %MainMacro; Any suggestions would be helpful. ... View more

I have the following code applied to the attached file which I need to modify such that I draw sample of N loans from the loan population labelled 'PUR' until the sum of the UPBs reaches 50000. Any thoughts are welcome. proc means data=LoanPopulation n; var Loan_ID; output=want; run;   proc surveyselect data=loan_population3    method=srs n=(.8*n) out=PUR_sample;    where purpcd='PUR'; run; ... View more

I need the following code to run on the sample dataset attached. The goal is to select all values of orig_date between today and six months ago. Any ideas? Thanks in advance. data test;   set farm_final;   end_date=%eval(&sysdate-180);   where orig_date between &sysdate and end_date; run; ... View more

To whom it may concern, Below is the code that I've been running on the 'example' dataset that is generated once I read the attached .txt file into SAS; my goal is to generate datasets hpi1 and hpi2. My problem is that after generating hpi1, the values of my observations seem to become rounded (which I don't want; I want the full number of decimal digits from the original variable in the example dataset) and when I try generating hpi2, I get no values for my variables whatsoever. I've tried the LENGTH and FORMAT statement, but I seem to be missing somthing simple. Reading .txt file into SAS: data example;   infile '/folders/example.txt' dlm='090D'x LRecL=10000;   input location $2. month1-month15;   format month1-month15 best15.12; run; options mprint mlogic symbolgen; %let arrlowbound=1;         %macro test();           %let arrelements=15;           %let arrupbound=%eval(&arrlowbound+14);           array month{&arrelements} month&arrlowbound-month&arrupbound;           format month&arrlowbound-month&arrupbound             %let increment=%eval(&arrlowbound+2);             drop month&arrlowbound-month&increment;                %let No1=%eval(&arrupbound+1);                %let No2=%eval(&arrupbound+2);                %let No3=%eval(&arrupbound+3);                month&No1=month(&arrupbound);                month&No2=month(&arrupbound);                month&No3=month(&arrupbound);                output;          %mend test; ***************************************I THINK THAT MY PROBLEMS BEGIN FROM HERE ON DOWN ****************************** data hpi1;     set example;              %test; run; data hpi2;      set hpi1;     %let arrlowbound=%eval(&arrlowbound+3);          %test(); run;  ... View more

The code below references the attached data set. I know that I can drop three variables and even more at a time from the array 'month' by simply changing the number of elements in me array. Is there a simpler way for me to also add three or more variables at a time, without having to write them out one after the other as I have done with month16, month17, and month18 below? All new variables added would have the same value.         data hpi;           set example;              array month{15} month1-month15;              drop month13-month15;                month16=month15;                month17=month15;                month18=month15;             run; ... View more

I have a dataset with three variables (var1, var2, var3). How can I go about indexing the dataset by var1, but making sure that var2 is also sorted in descending order? Thanks in advance. ... View more