I have a data set with 80 rows. For every set of 4 rows, I want to insert one kind of value into the first three rows, and a different value into the fourth row. I first figured the code might be something like this: data &_output;      set work.testdata;      while not last row;           if _n_ <= 3 then do;                new_row = value1;           end;           else if _n_ = 4 then do;                new_row = value2;                _n_ = 1;           end;      end; run; I just realized I'm misusing _n_ though, and need to reconsider it. Perhaps I can use a custom count variable. In any case, my question is, how do I do the "while not last row" part of the code correctly? Actually, the last row should preferably be included. Thanks for your attention. ... View more

If I have a character variable with the value "45 000" and want to turn it into a numeric variable, the space is obviously going to cause a problem. Can you please tell me how I can edit my expression to resolve this?           input(varname, 8.0) Incidentally, can you also please advise on how I can make my data step exclude the last row from the data set? The total number of rows will change from month to month. Thanks. ... View more

I've used PROC IMPORT to read a semicolon-delimited CSV-file. 14 variables have been created (VAR1-VAR14). Now I wonder what kind of statements I can use to change the name and format of these variables. This is my code so far: proc import   file='foldername/filename.csv'   out=&_OUTPUT. replace;   delimiter=";";   getnames=no; quit; P.S. As you can see I had to use getnames=no in the PROC IMPORT, and this cannot be changed. Thanks for your time, and sorry for the very newbie kind of question. ... View more

I have a CSV-file that I need to import into DI Studio. I've set up a transformation with this user written code: proc import   file='foldername/filname.csv'   out=&_OUTPUT. replace;   getnames=yes; quit; As you can see, getnames is set to "yes". I should also mention that the first row of the CSV-file contains column headers. The job runs without any warnings or errors, but when I attempt to open the output table, it tells me "Error accessing metadata: Table has no columns". How can I remedy this? Thanks for your time. ... View more

I need to use User Written Code in DI Studio in order to scan a folder for CSV-files, then transfer each of those files to another server. I'd greatly appreciate advice on how to go about doing this, and links to relevant material. Thanks for your time. ... View more

I need to import data from an XLS-document into DI Studio. I tried saving it as a CSV-file and importing it as a delimited external file, which worked well until I discovered that the CSV-file removes all unique Norwegian characters such as Æ, Ø, and Å. So, I figure I'll need to import the data directly from the XLS-file. Do you have any advice on how I might do this? Thanks for your time. ... View more

I'd appreciate good advice on a problem I'm faced with in DI Studio. My job includes a source table and an extract transformation. The source table has a datetime variable called "Last_Changed". If today is Monday, the Extract must get all rows where the Last_Changed weekday is between Fri-Sun the previous week. If today to Tue-Fri, the Extract must get all rows from yesterday. I've figured out some of the code: If weekday(&sysdate"d) = 2 (Monday), extract all rows where "Last_Changed" between "&sysdate"d-3 and "&sysdate"d-1 (previous Friday-Sunday). Else, if weekday(&sysdate"d) in (3,4,5,6) (Tuesday-Friday), extract all rows where "&sysdate"d = today()-1. My problem is that I can't quite figure out how to set this up in the Extract precode and where-statement. Thanks for your time. ... View more