how to handle in stream data containing semicolon in it?

Answers were Sorted based on User's Feedback



how to handle in stream data containing semicolon in it?..

Answer / prashanth

by using cards4 instead of cards.

Is This Answer Correct ?    7 Yes 0 No

how to handle in stream data containing semicolon in it?..

Answer / paul

data dummy;
input Name $ Remarks $15.;
cards4;
aaa 123;aaa;23;M
bbb 132;bbb;26;F
ccc 133;ccc;24;F
;;;;
run;

Is This Answer Correct ?    6 Yes 0 No

how to handle in stream data containing semicolon in it?..

Answer / n katepalli

we can also use datalines4 as well as cards4

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More SAS Interview Questions

what is the different between functions and procs that calculate the same simple descriptive statistics? : Sas programming

0 Answers  


is data integration and etl programming is same? : Sas-di

0 Answers  


I need to find the numeric field which contains blank in between..Ex:123 456...there is blank in between the 123 456..I need to know if there is any SAS function to find a field.. Please suggest...

5 Answers   TCS,


describe about physical data integration? : Sas-di

0 Answers  


How to convert .xls file into CSV format?

6 Answers   Quintiles,






what is the difference between infile and input? : Sas-administrator

0 Answers  


what is the use of proc sql?

5 Answers   CitiGroup,


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

0 Answers   Quintiles,


create macros---you have 365 number of data and you need to merge it throw the macros,,,,,, data file1; input a @@; cards; 1 2 3 4 ; run; data file2; input a @@; cards; 5 6 7 8 ; run; data file3; input a @@; cards; 9 10 11 12 ; run;data file4; input a @@; cards; 13 14 15 16 ; run;

6 Answers   WNS,


What is substr function?

0 Answers  


Explain the difference between using drop = data set option in set and data statement?

0 Answers  


what are input dataset and output dataset options?

6 Answers   HCL,


Categories