如何把数据集中的数值型全部变为字符型

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

数据集中有字符型 也由数值型
要求：1.变量名不变 2.变量顺序不变。
如何实现，谢谢！

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏1 回帖

关键词：数据集 字符型 数值型 如何实现 如何

sas.com里面有例子，把所有字符型改为数值型，作下对调：

1. /* How to convert all numeric variables to character and use the same variable names in the output data set
   
2. The sample data set TEST contains both character and numeric variables*/
   
3. data test;
   
4. input id $ b c $ d e $ f;
   
5. datalines;
   
6. AAA 50 11 1 222 22
   
7. BBB 35 12 2 250 25
   
8. CCC 75 13 3 990 99
   
9. ;
   
10. /*PROC CONTENTS is used to create an output data set called VARS to list all */
    
11. /*variable names and their type from the TEST data set. */
    
12. 
    
13. proc contents data=test out=vars(keep=name type) noprint;
    
14. 
    
15. /*A DATA step is used to subset the VARS data set to keep only the numeric */
    
16. /*variables and exclude the one ID numeric variable. A new list of character*/
    
17. /*variable names is created from the numeric variable name with a "_n" */
    
18. /*appended to the end of each name. */
    
19. 
    
20. data vars;
    
21. set vars;
    
22. if type=1 and name ne 'id';
    
23. newname=trim(left(name))||"_n";
    
24. 
    
25. /*The macro system option SYMBOLGEN is set to be able to see what the macro*/
    
26. /*variables resolved to in the SAS log. */
    
27. 
    
28. options symbolgen;
    
29. 
    
30. /*PROC SQL is used to create three macro variables with the INTO clause. One */
    
31. /*macro variable named c_list will contain a list of each character variable */
    
32. /*separated by a blank space. The next macro variable named n_list will */
    
33. /*contain a list of each new numeric variable separated by a blank space. The */
    
34. /*last macro variable named renam_list will contain a list of each new numeric */
    
35. /*variable and each character variable separated by an equal sign to be used on*/
    
36. /*the RENAME statement. */
    
37. 
    
38. proc sql noprint;
    
39. select trim(left(name)), trim(left(newname)),
    
40. trim(left(newname))||'='||trim(left(name))
    
41. into :c_list separated by ' ', :n_list separated by ' ',
    
42. :renam_list separated by ' '
    
43. from vars;
    
44. quit;
    
45. 
    
46. /*The DATA step is used to convert the numeric values to character. An ARRAY */
    
47. /*statement is used for the list of character variables and another ARRAY for */
    
48. /*the list of numeric variables. A DO loop is used to process each variable */
    
49. /*to convert the value from character to numeric with the INPUT function. The */
    
50. /*DROP statement is used to prevent the character variables from being written */
    
51. /*to the output data set, and the RENAME statement is used to rename the new */
    
52. /*numeric variable names back to the original character variable names. */
    
53. 
    
54. data test2;
    
55. set test;
    
56. array ch(*) $ &c_list;
    
57. array nu(*) &n_list;
    
58. do i = 1 to dim(nu);
    
59. ch(i)=put(nu(i),8.);
    
60. end;
    
61. drop i &c_list;
    
62. rename &renam_list;
    
63. run;

复制代码

好吧，我怎么能用那么低效率的方法。。。
继续学习