In the data step, use
dlm="~" dsd firstobs=2 truncover
in the INFILE statement.
If there is a pattern to the variable names, use a macro to reduce your code.
"Does not help" is awful vague.
Are there errors in the log?: Post the code and log in a code box opened with the <> to maintain formatting of error messages.
No output? Post any log in a code box.
Unexpected output? Provide input data in the form of data step code pasted into a code box, the actual results and the expected results. Instructions here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-dat... will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the <> icon or attached as text to show exactly what you have and that we can test code against.
You should as an absolute minimum show the code, or the generated code, you attempted.
The options @Kurt_Bremser apply to reading a data set with a data step. If you are attempting to use Proc Import then show us.
did you try the import wizard by giving it a custom delimiter and see what code it generates. The code BallardW posted should work. Please provide your code and logs as suggested.
Is the delimiter a comma or a tilde? Your posted code is trying to use comma as the delimiter. If you want to tell PROC IMPORT to use tilde as the delimiter then add this statement to the proc import step.
dlm='~';
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.