data traffic2; infile "/folders/myfolders/np_traffic.dat" dlm='|'; input Parkname$ Unitcode$ ParkType$ Region$TrafficCounter$ Reportdate$ TrafficCount; run; when I use the codes above to import np.traffic.dat to sas, the top labels (Parkname$ Unitcode$ ParkType$ Region$TrafficCounter$ Reportdate$ TrafficCountis) are exactly repeated as the labels of SAS dataset.  What is the better way to avoid the repeating label and the first row immediately starts with the real data? ... View more

Where can I find the SAS codes in the activities of programming 1 for BASE SAS certificate training? Like p101a03.sas, p101a04.sas. ... View more

data one; input S_id S_i score; cards; 1 1 98 1 2 76 1 3 63 2 1 96 2 2 85 2 3 76 ; run; data score_one; set one; by S_id S_i; array ascore(3); retain ascore1-ascore3; /*if first.S_id then call missing(of ascore1-ascore3);*/ ascore(S_i)=score; /*output;*/ if last.S_id then output; keep S_id ascore1-ascore3; run; when I work on the reshaping through by statement, it seems the first.s_id does not take an effect when combining with the call missing routine. As shown above, when I comments if first.S_id call missing line, the codes can generate the same data set. Call missing should assign empty values for first-id =1, but we do have the values for the first line. I use "output" to display the loop. It is a bit confusing about the data assignment. What is the proper understanding? ... View more

There are lots of examples in the SAS program documents (website). There is a "copy" symbol displaying "copy to clipboard". But I can not copy these codes to SAS studio and run them. Can anyone suggest a proper method to copy/past the SUS web codes to SAS studio? ... View more

The COMMAw.d informat can be used to read which of the following values? Options: A. all the three   B. $177.95   C. 12,805   D. 18 %   A or only C? why? ... View more

Given the SAS data set WORK.INPUT: Var1 Var2 ------ ------- A one A two B three C four A five The following SAS program is submitted: data WORK.ONE WORK.TWO; set WORK.INPUT; if Var1='A' then output WORK.ONE; output; run; How many observations will be in data set WORK.ONE? I do not understand why the observation is 8. I only got 3 observations when Var1 is A.    ... View more