How to get any kind of data in SAS? Is it possible to take
data from notepad in SAS?

Answer Posted / naveen

Data sample_accounts;
INPUT Account 1-7 OpenDate $ 9-17 StatusCode $ 21-22
CreditLimit 25-29;
CARDS;
1234670 11-Sep-04 Z 2000
1234671 12-Sep-04 3000
1234672 13-Sep-04 Z 2500
1234673 14-Sep-04 T 3200
1234674 15-Sep-04 8000
run;

filename myfile "C:\Mydata\sample_accounts.txt";
data qqq;
infile myfile dlm=' ';
input Account OpenDate $ StatusCode $ CreditLimit;
run;

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What versions of SAS have you used (on which platforms)?

1015


explain about data integrator metadata reports? : Sas-di

565


What is the difference between one to one merge and match merge? Give an example.

571


How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?

1580


Briefly explain input and put function?

630






Explain data_null_?

609


what do the pad and dim functions do? : Sas programming

566


What are the special input delimiters used in SAS?

656


what is the difference between floor and ceil functions in sas? : Sas-administrator

704


how do you debug and test your sas programs? : Sas programming

560


What are SAS/ACCESS and SAS/CONNECT?

632


What is the order of application for output data set options, input data set options and SAS statements?

1080


Do you need to rearrange the order of the data for the report?

1835


how to do user inputs and command line arguments in sas?

2428


Why double trailing @@ is used in input statement?

702