Are you familiar with special input delimiters How are they
used?
Answers were Sorted based on User's Feedback
Answer / selvi
We can specify delimiter value in dlm option of infile stmt.
If any values are missing in between then dlm option does
nt recognize the same so we need to use DSD option to read
consecutive delimiter as missing values.DSD set two more
things 1.comma as default delimiter 2.remove quotion from
quted string
| Is This Answer Correct ? | 6 Yes | 1 No |
What are the difference between ceil and floor functions in sas?
Name statements that are execution only.
Can anyone help to find a statement to get all the predefined formats?
3 Answers Verinon Technology Solutions,
i have a dataset with var1,var2,var3; i want to upload the titles for the variables . How can we?
data jagan1.s; input bp$; cards; 100/90 120/89 112/87 run; in the above code how to convert character data values to numeric data values?
i have multiple .csv files in a unix directory. every file is having variable names as header.even for empty file also. suppose take 3 files a.csv b.csv c.csv a.csv contains data as name;age,salary; raja;34;4000; ravi;33;5000; kumar;25;3000; b.csv contains data as name;age,salary; ajay;40;4500; and c.csv contains name;age,salary; (only headers) Now i want to import and append all these files in to a single dataset. i tried infile statement with *.csv to import all at a time. but i m not getting correct data. please help me . its urgent. thank you in advance
what are input dataset and output dataset options?
how to generate means for every subject;
Explain how you can debug and test your SAS program?
How the Excel file enter into the SAS environment without Code of Infile & Import procs,if i have no file Conversion?
Describe the types of SAS programming tasks that you performed like Tables? Listings? Graphics? Ad hoc reports? Other?
What areas of SAS are you most interested in?