Hello friends
I have a problem.
I am using tera data query in order to create a table that contains 3318 rows.
I am exporting the table to a txt file.
Then I am using in SAS: File--Import data and I get only 3281 rows.
As you can see number of rows is not matched to original table.
I checked what happened and found that some rows values are located in specific field.
What do you suggest in order to solve this problem please?
You have to post code and log, so that we see what actually happened.
How are you exporting the data, and to what format. If you export a CSV file, and your data contains commas, then you will obviously have issues. In these cases you can either enclose the data with commas in double quotes so the reader knows to read the whole block without delimeters, or you can switch to a delimeter that is not in your data, for example a pipe. How you do this in teradata, well there should be an option at export to specify the delimiter.
If of course its not the above then post some actual information about your problem, otherwise we are just guessing.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.