I try to use INPUT to read raw data, but I found that it should use the +1 correctly then SAS could read the data correctly, for the below example, why it is correct only when I add +1 after the variables of age and type? Could anyone explain for me that how do I know when to add +1 to a skip a column from the dateset?   with+1 after columns age and type   INPUT name $16. age 3. + 1 type $1. +1 date mmddyy10. (score1 score2 score3 score4 score5) (4.1 );   without +1 INPUT name $16. age 3.  type $1.  date mmddyy10. (score1 score2 score3 score4 score5) (4.1 ); So when to use +1   ... View more

attached is the dataset,   DATA data; INFILE "......\data.txt"; INPUT A 11. B ; RUN; but the result is weird. some values are right, but some of them are false.      The log shows:   14 CHAR 10.20.00000001 14 ZONE 33033233333333 NUMR 10920E00000001 A=. B=1 _ERROR_=1 _N_=13 NOTE: 16 records were read from the infile "\\client\E$\course materials\continue\Homeworks\HW2\data.txt". The minimum record length was 4. The maximum record length was 24. NOTE: SAS went to a new line when INPUT statement reached past the end of a line. NOTE: The data set WORK.DATA has 14 observations and 2 variables. NOTE: DATA statement used (Total process time): real time 0.26 seconds cpu time 0.03 seconds   What is the matter of my code? and What does the former lines(in red) mean in the log?   ... View more

how to make a 3D chart for categorical variable like   VARIABLE1   A A A A  B B B B B   I know some the code like the following, but if the variable is a categorical, how to sum and make a 3d pie chart? proc gchart data=a; pie3d YEAR / sumvar=CNT   ... View more

the names on the yaxis are overlap because  two many values. Can I just choose some values to display? e.g. choose formmer three values with a higher frequency.     I use the flowwing code to draw the plot   PROC SGPLOT DATA= Us_flight; HBAR _Equipment ; YAXIS FITPOLICY = NONE; RUN; ... View more

I want to merge two datasets  the variable in dataset 1is IATA and in dataset2 is UNIQUE_CARRIER. In the output, I want to remove the obserbations that "IATA" does'not have. Generally I know use the "PROC merge" like that. but it seems it only works when they have common variable. I don't know how to do if they don't have common name of a variable. could anybody give me some instructions?       DATA dataset3; MERGE dataset1 (IN=a) dataset2 (IN=b ); By common_variable IF a=1; RUN;   one is    IATA     B1       OO      QU         UNIQUE_CARRIER      AA AA B1                                OO                               QU                                   ... View more