What is the purpose of the trailing and How would you use them?
Answer Posted / sandhya
The trailing @ or more technically, line hold specifiers
are used to hold the pointer in the same record for
multiple iterations. The two tyoes of line hold specifiers
are single trailing(@) and double trailing(@@).
The single trailing hold the record until it encounters
either another input statement or end of the datastep.
They are used for the records such as
001F38 H
002 F 40 G
To read these values to the datastep
Data example;
input @10 type $ @;
if type='H' then
input @1 id 3. @4 gender $1. @5 age2.;
else if type='G' then
input @1 id3. @5 gender $1. @7 age 2.;
end;
cards;
001F38 H
002 F 40 G
;
run;
The double trailing holds the until the end of the record.
Data example2;
input id age @@;
cards;
001 23 002 43 003 65 004 32 005 54
;
run;
Is This Answer Correct ? | 19 Yes | 0 No |
Post New Answer View All Answers
What is the difference between one to one merge and match merge? Give an example.
what are the considerations when picking a SAS/STAT procedure?
how will you locate the sas platform applications? : Sas-bi
for what purpose would you use the retain statement? : Sas programming
What is program data vector (pdv)?
explain the main difference between the nodup and nodupkey options? : Sas-administrator
What is maximum storage capability of SAS?
What are the ways to do a “table lookup” in sas?
What is a put statement?
how many types prompting framework can be broken down to? : Sas-bi
How would you include common or reuse to be processed along with your statements?
What are the statements in proc sql?
What is SAS?
what is sas business intelligence? : Sas-bi
how does sas handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, procs? : Sas programming