Hello,   I tried all I can think of including a data Null step. However when I use a simple proc export one variable exports with double quotes and trailing blanks. It's a character variable with a length and format of $35.    My Proc export looks like this:    proc export data=file1 outfile="&outpath.file1..txt" dbms=tab replace; run;   Output looks like this: Var N                                                                                              VarO            VarP         VarE "NNNNNNN                                                                               "  OOOOO      PPPPP     EEEEEE   I need the output to look like this:  Var N                  VarO            VarP         VarE NNNNNNN       OOOOO      PPPPP     EEEEEE   What is happening? Everything was fine when I ran this program before. Now this. The actual dataset in SAS looks fine. The reason I didn't use a data _null_ step, besides the fact I'm not too familiar with them, is because the one I wrote was not outputting the variable headers, just the values. What am I doing wrong? Please help. Thanks in advance, JMagenta ... View more

Hello,   I was having trouble using the last value in my groups as the value for all members in my groups. Basically, I want whatever the last value in the group is to be the value for all members in that group. What I have:  data Have; input ID Name $; cards; 1 '' 1 Yes 2 '' 2 No 3 '' 3 '' 3 Yes 4 No 5 '' 5 Yes 6 No 8 Yes ; run; Which looks like:  But What I WANT: How can I achieve my goal? Please help.   Thank you in advance, J   ... View more

Hello,   So thank you in advance. I used the following code to preserve leading zeros when I exported my CSV file: ods csv file="&outpath.Need.csv"; ods csv options (QUOTE_BY_TYPE='Yes' PREPEND_EQUALS='Yes' sheet_name='Need' embedded_titles='yes') style=daisy; proc print data=need; run; ods csv close; This code worked. However now I need to read that same file back into SAS without the appended quotes and equal signs. Is there code to take the quotes and equal signs off all the numeric data, basically reversing what I did without manually stripping each variable? There are 100 plus variables that now have equal signs and quotes around them. I thought I was on to something trying to import using proc document but I guess I was wrong.  Please message me if you need more information and I will do my best. ... View more

Hello and thank you in advance,   I want to output to two different datasets and use a counter variable in each data set that counts separately. Like so:   data have; infile datalines dlm=','; input blah $ var1 var2 ; datalines; a, 1, 2,  b, 3, 2,  c, 3, 3, d, 8, 4,  e, 5, 6,  f, 7, 2, g, 3, 1,  h, 9, 4,  i, 8, 9 ; run;   data want1 want2; set have; if blah in ('a', 'b', 'c', 'd') then do; do i=1 to (total number of records but I don't know how to specify that); recordno=i; output want1; end; end; else do; do i=1 to total obs in that dataset; recordno=i; output want2; end; end; run;   With the result that looks something like this: Want 1 : blah var1 var2 recordno a      1        2        1 b      3        2         2 c       3        3         3 d      8       4          4   Want 2: blah var1 var2 recordno e      5       6       1 f     7        2         2 g     3        1       3 h      9      4          4   and so on. How can I do this ? I know there must be use of a do loop. I'm just not figuring out how to do so.   Thank you ... View more

Hello and Thank you! I wanted to see if could create a new variable with values of a another variable and values from a range. I only want to replace missing values, and without duplicates. For instance my code looks like this:     data have; infile datalines dlm=','; input blah $ var1 var2 ; datalines; A, 1, 2,  b, 3, 2,  c, 3, ., d, 8, .,  e, 5, .,  f, 7, 2, g, 3, 1,  h, 9, 4,  i, 8, . ; run;   data want; set have; If var2 ne . then var3=var2; else if missing(var2) then var3=rand("integer", 1800, 1803); run;   What I want is this :   > What I get is this:   How can I end this pain? I know I need a do loop of some sort and/or an array maybe. How should I set it up? I have a much longer dataset and I don't want to assign duplicate values to this new variable. I know the answe Thank you!!! ... View more