topic Need Data Step Solution in SAS Programming

Need Data Step Solution

amitthakur — Sun, 02 Sep 2018 04:54:25 GMT

Dear All,

I have some text Like that.

Q1. Which among the following are cor-
rect about the provisions of the Govern-
ment of India Act, 1858?
(a) It ended the system of double government by abol-
ishing the Board of Control and Court of Directors
(b) It also provided for the establishment of new legis-
lative councils for Bengal
(c) It reconstituted the Council of the Governor-General
(d) The number of additional member in the Provincial
Legislative Councils was also increased
Ans: (a)

I need your support how to show the data below format.

Question	A	B	C	D	Ans
Which among the following are cor- rect about the provisions of the Govern- ment of India Act, 1858?	It ended the system of double government by abol- ishing the Board of Control and Court of Directors	It also provided for the establishment of new legis- lative councils for Bengal	It reconstituted the Council of the Governor-General	The number of additional member in the Provincial Legislative Councils was also increased	A

Re: Need Data Step Solution

Cynthia_sas — Sun, 02 Sep 2018 05:25:10 GMT

Hi:
It is nearly impossible to help you without knowing what the original data structure looks like. Where is this data stored? How is it stored? What are the column names. Does your data have a row for each question or does your data have multiple rows for the question and the possible answers.

Without more information about the data, it is nearly impossible to help.

Cynthia

Re: Need Data Step Solution

amitthakur — Sun, 02 Sep 2018 05:29:47 GMT

store in text file in my systems

Re: Need Data Step Solution

amitthakur — Sun, 02 Sep 2018 05:36:23 GMT

data work.question;
infile cards dlm= '? ()';
input Q $optiona $ optionob $ optionc $optiond $ correctans;

cards;
Q1. Which among the following are cor-
rect about the provisions of the Govern-
ment of India Act, 1858?
(a) It ended the system of double government by abol-
ishing the Board of Control and Court of Directors
(b) It also provided for the establishment of new legis-
lative councils for Bengal
(c) It reconstituted the Council of the Governor-General
(d) The number of additional member in the Provincial
Legislative Councils was also increased
Ans: (a)
;
run;

Re: Need Data Step Solution

amitthakur — Sun, 02 Sep 2018 05:49:13 GMT

this is original data stricture Q is Question, (A), (B) (C) (D) is options and Ans is (a)

Re: Need Data Step Solution

Ksharp — Sun, 02 Sep 2018 11:13:54 GMT

options compress=yes;
data have;
infile 'c:\temp\test.txt' lrecl=2000;
length temp $ 32767 question a b c d ans $ 2000;
retain temp question a b c d;
input;
temp=cats(temp,_infile_);
if _infile_ =: '(a)' then do;
question=substr(temp,1,find(temp,'(a)')-1);
temp=substr(temp,find(temp,'(a)'));
end;

if _infile_ =: '(b)' then do;
a=substr(temp,1,find(temp,'(b)')-1);
temp=substr(temp,find(temp,'(b)'));
end;

if _infile_ =: '(c)' then do;
b=substr(temp,1,find(temp,'(c)')-1);
temp=substr(temp,find(temp,'(c)'));
end;

if _infile_ =: '(d)' then do;
c=substr(temp,1,find(temp,'(d)')-1);
temp=substr(temp,find(temp,'(d)'));
end;

if _infile_ =: 'Ans:' then do;
d=substr(temp,1,find(temp,'Ans:')-1);
ans=substr(temp,find(temp,'Ans:'));
output;
end;
drop temp;
run;

Re: Need Data Step Solution

Reeza — Sun, 02 Sep 2018 17:48:15 GMT

For files like these the full pattern is very important.

Is it guaranteed to follow that structure? You can't have short answer or fill in the blank type questions? You always have options A, B, C, D? No chance of just A, B, C or ABCDE?