cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Alexxxxxxx
‎08-30-2023
  • 189 Posts
  • 91 Likes Given
  • 0 Solutions
  • 2 Likes Received

create three X Y scatter for each group

by Pyrite | Level 9 in SAS Programming
‎03-07-2020 08:12 PM
‎03-07-2020 08:12 PM
Hello all,   I expect to create a figure    for the following data, data have; INFILE CARDS DSD DLM=','; input CTRY :$10. INDUSTRY :$29. R&D :8 PATENTS :8 ; cards; AT,Manufacure,4316550,2033058 AU,Manufacure,2701929,961452 BE,Manufacure,1935804,564041 AT,Service,2069617,483619 AU,Service,1058213,235353 BE,Service,1024675,60304 AT,Oil,1725920,242679 AU,Oil,2178870,543554 BE,Oil,1024675,60304 ; run; I expect to create three X Y scatter for each INDUSTRY   I would like to put the value of "R&D" at Y-axis and value of "Patent" at X-axis and the value of " INDUSTRY" as the title of each scatter. SO the value of each country is expected to be displayed as a point on each scatter chart.   Could you please give me some suggestion about this? thanks in advance.     ... View more

if the below rows are blank then file it with the above strings.

by Pyrite | Level 9 in SAS Programming
‎03-03-2020 08:56 PM
‎03-03-2020 08:56 PM
Dear all   if I have a current table as  SIC_3_CODE SIC_3_description SIC_4_CODE SIC_4_description 124 COAL MINING SERVICES         1241  COAL MINING SERVICES 131 CRUDE PETROLEUM AND NATURAL GAS         1311  CRUDE PETROLEUM AND NATURAL GAS 132 NATURAL GAS LIQUIDS         1321  NATURAL GAS LIQUIDS 138 OIL AND GAS FIELD SERVICES         1381  DRILLING OIL AND GAS WELLS     1382  OIL AND GAS FIELD EXPLORATION SERVICES     1389  OIL AND GAS FIELD SERVICES, NOT ELSEWHERE CLASSIFIED   and expect to get table like SIC_3_CODE SIC_3_description SIC_4_CODE SIC_4_description 124 COAL MINING SERVICES 1241  COAL MINING SERVICES 131 CRUDE PETROLEUM AND NATURAL GAS 1311  CRUDE PETROLEUM AND NATURAL GAS 132 NATURAL GAS LIQUIDS 1321  NATURAL GAS LIQUIDS 138 OIL AND GAS FIELD SERVICES 1381  DRILLING OIL AND GAS WELLS 138 OIL AND GAS FIELD SERVICES 1382  OIL AND GAS FIELD EXPLORATION SERVICES 138 OIL AND GAS FIELD SERVICES 1389  OIL AND GAS FIELD SERVICES, NOT ELSEWHERE CLASSIFIED in order to get this result, I expect to if the below rows are blank then file it with the above strings. and then delete rows if the value of SIC_4_CODE is blank.   could you please give me some suggestions about this? thanks in advance.   ... View more

read a numerical value "111" in a format as "0111"

by Pyrite | Level 9 in SAS Programming
‎02-24-2020 07:09 PM
‎02-24-2020 07:09 PM
Dear all,   I want to read a numerical value (i.g., SIC)  "111" in a format as "0111" by the following code. DATA SIC_code_list; infile "G:\PATSTAT_control_variable\CSV\SIC_Code_List.csv" DLM = ";" DSD missover lrecl=32767 firstobs = 2; input SIC : 4. Description :$1000. ; format SIC 4. ; run; however, I only get 111, is there any method to change the format and shown as 0111?   thanks in advance. ... View more

import excel file into SAS

by Pyrite | Level 9 in SAS Programming
‎02-24-2020 11:28 AM
‎02-24-2020 11:28 AM
Dear all,   I have the excel file looks like this #NAME? BDATE 77605Q 31/08/2011 15455F 03/02/2003 286279 08/03/2000 31192X 17/02/2006 130165 11/12/1990 130298 22/02/1994 130412 03/03/1994 13052M 16/01/2001 When I import this excel file into SAS by the following code,   proc import datafile = "G:\PATSTAT_control_variable\Control_variable_Datastream.xlsx" OUT=Datastream_bdate DBMS=XLSX replace; Sheet="bdate"; RANGE="A1:B12034"; GETNAMES=YES; RUN;   it is shown as    #NAME? BDATE 77605Q 40786 15455F 37655 286279 36593 31192X 38765 130165 33218 130298 34387 130412 34396 13052M 36907 However, I expect to import them as the date value or character value?   thanks in advance ... View more

Re: create the line chart

by Pyrite | Level 9 in SAS Programming
‎11-19-2019 06:15 PM
‎11-19-2019 06:15 PM
Thanks,   now I get a serious picture like Is there any method to put them together like the Figure2.1, and 1.delete the explanation at the Y-axis 2. replace ALL with no_app_per_year, replace By corporation with no_cit_per_year, 3. replace "PERSON_CTRY_CODE=AT" with "AT"? Sorry, I have a lot of questions. I just start to learn how to use SAS to draw the line chart ... View more

Re: create the line chart

by Pyrite | Level 9 in SAS Programming
‎11-19-2019 05:39 PM
‎11-19-2019 05:39 PM
the file is added in the attachment. please have a look.   besides, by using the code    proc sgplot data=Results.PATSTAT_no_full_hrm_with_ctry5; by person_ctry_code; series x= year y=no_app_per_year / group = person_ctry_code; series x= year y=no_cit_per_year / group = person_ctry_code; run; I get a serious picture like    it looks much better now, however, I expect to get a picture of each "person_ctry_cod" and for each picture, there are two lines, one is the  no_app_per_year, one is no_cit_per_year. for current picture, the explanation of line and Y-axis are wrong. Could you please give me some suggestions about this? thanks in advance   ... View more

Re: create the line chart

by Pyrite | Level 9 in SAS Programming
‎11-19-2019 04:27 PM
‎11-19-2019 04:27 PM
thanks for your suggestion. however, when I use      proc sgplot data=Results.PATSTAT_no_full_hrm_with_ctry5; SERIES x=year y=no_app_per_year / group=person_ctry_code; SERIES x=year y=no_cit_per_year / group=person_ctry_code; run; all the lines are shown in one picture. Could you please give me more suggestions about this? ... View more

create the line chart

by Pyrite | Level 9 in SAS Programming
‎11-19-2019 12:06 PM
‎11-19-2019 12:06 PM
Dear all,   for the .excel file in the attachment, how to create the line chart of each "person_ctry_code" group, which just like the following picture? The Y-axis is the no_app_per_year and no_app_per_year; the X-axis is the years from 1990 to 2012. ... View more

Re: import excel. file into SAS and set the informat of the variable

by Pyrite | Level 9 in SAS Programming
‎10-23-2019 06:45 PM
‎10-23-2019 06:45 PM
hello @ballardw    by using the code the result is  12266 /*the result of manual match*/ 12267 proc import datafile = "C:\Users\70660\Desktop\manual_check_201910.xls" 12268 OUT=result_of_manual_match DBMS=XLSX replace; 12269 Sheet="Sheet1"; 12270 RANGE="A1:I484"; 12271 GETNAMES=YES; 12272 RUN; WARNING: Some character data was lost during transcoding in column: Note at obs 38. WARNING: Some character data was lost during transcoding in column: Note at obs 39. WARNING: Some character data was lost during transcoding in column: Note at obs 40. WARNING: Some character data was lost during transcoding in column: Note at obs 41. WARNING: Some character data was lost during transcoding in column: Note at obs 42. WARNING: Some character data was lost during transcoding in column: Note at obs 43. WARNING: Some character data was lost during transcoding in column: Note at obs 97. WARNING: Some character data was lost during transcoding in column: Note at obs 114. WARNING: Some character data was lost during transcoding in column: Note at obs 154. WARNING: Some character data was lost during transcoding in column: Note at obs 324. WARNING: Some character data was lost during transcoding in column: Note at obs 368. WARNING: Some character data was lost during transcoding in column: Note at obs 426. WARNING: Some character data was lost during transcoding in column: Note at obs 451. NOTE: The import data set has 483 observations and 9 variables. NOTE: WORK.RESULT_OF_MANUAL_MATCH data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.02 seconds cpu time 0.03 seconds 12273 12274 data result_of_manual_match1 ; 12275 set result_of_manual_match ; 12276 Note=tranwrd(Note, ';', ','); 12277 run; NOTE: There were 483 observations read from the data set WORK.RESULT_OF_MANUAL_MATCH. NOTE: The data set WORK.RESULT_OF_MANUAL_MATCH1 has 483 observations and 9 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds 12278 12279 PROC EXPORT DATA=result_of_manual_match1 12280 OUTFILE= "C:\Users\70660\Desktop\manual_check_201910.csv" 12281 DBMS=csv REPLACE; 12282 delimiter=";"; 12283 RUN; 12284 /********************************************************************** 12285 * PRODUCT: SAS 12286 * VERSION: 9.4 12287 * CREATOR: External File Interface 12288 * DATE: 22OCT19 12289 * DESC: Generated SAS Datastep Code 12290 * TEMPLATE SOURCE: (None Specified.) 12291 ***********************************************************************/ 12292 data _null_; 12293 %let _EFIERR_ = 0; /* set the ERROR detection macro variable */ 12294 %let _EFIREC_ = 0; /* clear export record count macro variable */ 12295 file 'C:\Users\70660\Desktop\manual_check_201910.csv' delimiter=';' DSD DROPOVER 12295! lrecl=32767; 12296 if _n_ = 1 then /* write column names or labels */ 12297 do; 12298 put 12299 "HRM_L2" 12300 ';' 12301 "Type" 12302 ';' 12303 "Status" 12304 ';' 12305 "Parant_Company" 12306 ';' 12307 "Type_of_parant_company" 12308 ';' 12309 "Status_of_parant_company" 12310 ';' 12311 "person_ctry_code" 12312 ';' 12313 "Ref_of_Note" 12314 ';' 12315 "Note" 12316 ; 12317 end; 12318 set RESULT_OF_MANUAL_MATCH1 end=EFIEOD; 12319 format HRM_L2 $99. ; 12320 format Type $6. ; 12321 format Status $16. ; 12322 format Parant_Company $31. ; 12323 format Type_of_parant_company $6. ; 12324 format Status_of_parant_company $12. ; 12325 format person_ctry_code $2. ; 12326 format Ref_of_Note $9. ; 12327 format Note $1345. ; 12328 do; 12329 EFIOUT + 1; 12330 put HRM_L2 $ @; 12331 put Type $ @; 12332 put Status $ @; 12333 put Parant_Company $ @; 12334 put Type_of_parant_company $ @; 12335 put Status_of_parant_company $ @; 12336 put person_ctry_code $ @; 12337 put Ref_of_Note $ @; 12338 put Note $ ; 12339 ; 12340 end; 12341 if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */ 12342 if EFIEOD then call symputx('_EFIREC_',EFIOUT); 12343 run; NOTE: The file 'C:\Users\70660\Desktop\manual_check_201910.csv' is: Filename=C:\Users\70660\Desktop\manual_check_201910.csv, RECFM=V,LRECL=32767,File Size (bytes)=0, Last Modified=23 October 2019 23:38:51 o'clo, Create Time=23 October 2019 23:38:51 o'clo NOTE: 484 records were written to the file 'C:\Users\70660\Desktop\manual_check_201910.csv'. The minimum record length was 11. The maximum record length was 1393. NOTE: There were 483 observations read from the data set WORK.RESULT_OF_MANUAL_MATCH1. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 483 records created in C:\Users\70660\Desktop\manual_check_201910.csv from RESULT_OF_MANUAL_MATCH1. NOTE: "C:\Users\70660\Desktop\manual_check_201910.csv" file was successfully created. NOTE: PROCEDURE EXPORT used (Total process time): real time 0.06 seconds cpu time 0.07 seconds 12344 12345 data result_of_manual_match2; 12346 infile "C:\Users\70660\Desktop\manual_check_201910.csv" 12347 DLM = ";" 12348 DSD 12349 missover 12350 lrecl=32767 12351 firstobs = 2; 12352 input 12353 HRM_L2 :$1000. 12354 Type :$50. 12355 STATUS :$50. 12356 Parant_Company :$1000. 12357 Type_of_parant_company :$50. 12358 Status_of_parant_company :$50. 12359 person_ctry_code :$1000. 12360 Ref_of_Note :$1000. 12361 Note :$2000. 12362 ; 12363 run; NOTE: The infile "C:\Users\70660\Desktop\manual_check_201910.csv" is: Filename=C:\Users\70660\Desktop\manual_check_201910.csv, RECFM=V,LRECL=32767,File Size (bytes)=71945, Last Modified=23 October 2019 23:38:52 o'clo, Create Time=23 October 2019 23:38:51 o'clo NOTE: 40 records were read from the infile "C:\Users\70660\Desktop\manual_check_201910.csv". The minimum record length was 25. The maximum record length was 348. NOTE: The data set WORK.RESULT_OF_MANUAL_MATCH2 has 40 observations and 9 variables. NOTE: DATA statement used (Total process time): real time 0.04 seconds cpu time 0.01 seconds 12364 12365 data result_of_manual_match3; 12366 set result_of_manual_match2; 12367 if STATUS='RIGHT' then output; 12368 else if STATUS='NO' and person_ctry_code ^= ' ' then output; 12369 run; NOTE: There were 40 observations read from the data set WORK.RESULT_OF_MANUAL_MATCH2. NOTE: The data set WORK.RESULT_OF_MANUAL_MATCH3 has 21 observations and 9 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds The main problem happens when I read csv. file into SAS. I do not know why. ... View more

Re: import excel. file into SAS and set the informat of the variable

by Pyrite | Level 9 in SAS Programming
‎10-23-2019 06:29 PM
‎10-23-2019 06:29 PM
Hello @Reeza  the attachment has been added. all variable is character variable. I expect to import variables in excel. file with a specific format.is there any simple code to do it? ... View more

import excel. file into SAS and set the informat of the variable

by Pyrite | Level 9 in SAS Programming
‎10-23-2019 05:34 PM
‎10-23-2019 05:34 PM
Hello,    I am trying to import excel. file into SAS and set the informat of the variable. by using the following codes,     /*the result of manual match*/ proc import datafile = "C:\Users\70660\Desktop\manual_check_201910.xls" OUT=result_of_manual_match DBMS=XLSX replace; Sheet="Sheet1"; RANGE="A1:I484"; GETNAMES=YES; RUN; proc sql; create table result_of_manual_match1 as select distinct * from result_of_manual_match ; quit; data result_of_manual_match1 ; set result_of_manual_match1 ; Note=tranwrd(Note, ';', ','); run; PROC EXPORT DATA=result_of_manual_match1 OUTFILE= "C:\Users\70660\Desktop\manual_check_201910.csv" DBMS=csv REPLACE; delimiter=";"; RUN; data result_of_manual_match2; infile "C:\Users\70660\Desktop\manual_check_201910.csv" DLM = ";" DSD missover lrecl=32767 firstobs = 2; input HRM_L2 :$1000. Type :$50. STATUS :$50. Parant_Company :$1000. Type_of_parant_company :$50. Status_of_parant_company :$50. person_ctry_code :$1000. Ref_of_Note :$1000. Note :$2000. ; run; data result_of_manual_match3; set result_of_manual_match2; if STATUS='RIGHT' then output; else if STATUS='NO' and person_ctry_code ^= ' ' then output; run;   However, only 39 observations been read. The original data is added in the attachment. Could you please give me some suggestions about this? ... View more

pick up specified obs from each group

by Pyrite | Level 9 in SAS Programming
‎10-21-2019 11:06 AM
‎10-21-2019 11:06 AM
Hello,   I am trying to pick up the specified data from the HAVE dataset. By using the HAVE table as an example, Obs HRM_L2 PERSON_CTRY_CODE Type GEOGRAPHIC_DESCR_ degree 1 A       0 2 A CN     0 3 A TW 31192X TW 9 4 B       3 5 B FR     0 6 B IT     0 7 B KR 745666 KR 8 8 B US 745666 US 9 9 C   745666 TH 3 10 C GB     0 11 C US     0   1.For each 'HRM_L2' group, if one of the degrees is larger or equal than 6 (i.e.,6,7,8,9) then I would like to have that observation. and has a note as 1 for example, for 'A' group, I expect to only keep the 'Obs' 3 as the degree is 9. 2.in the 'B' group, both 'Obs' 7 and 'Obs' 8 are larger than 6 then I expect to keep both of them, and have a note as 2. 3. if all of degree is less than 6 in the 'HRM_L2' group, then I expect to keep all of them and with a note 3. the result is expected to look like below. Obs HRM_L2 PERSON_CTRY_CODE Type GEOGRAPHIC_DESCR_ degree Note 3 A TW 31192X TW 9 1 7 B KR 745666 KR 8 2 8 B US 745666 US 9 2 9 C   745666 TH 3 3 10 C GB     0 3 11 C US     0 3 Could you please give me some suggestion about this? thanks in advance data have ; infile cards dsd dlm=","; input HRM_L2 $ PERSON_CTRY_CODE $ Type $ GEOGRAPHIC_DESCR_ $ degree ; cards ; A,,,,0 A,CN,,,0 A,TW,31192X,TW,9 B,,,,3 B,FR,,,0 B,IT,,,0 B,KR,745666,KR,8 B,US,745666,US,9 C,,745666,TH,3 C,GB,,,0 C,US,,,0 ; run; .   ... View more

get the largest number by group, keep all of the largest if they are s...

by Pyrite | Level 9 in SAS Programming
‎10-10-2019 08:39 PM
‎10-10-2019 08:39 PM
Hello,   I expect to get the largest DEGREE per 'HRM_L2, TYPE' group. If there are two same largest number of 'DEGREE' then I expect to keep all of them(even they are the missing value).    by using the following table as an example, HRM_L2 PERSON_CTRY_CODE TYPE DEGREE AB   1   AB US 1 6 AB GB 1 2 CC US 2   CC GB 2   DF CA 4 2 DF GB 4 2 DF DE 4 2 I expect to get  HRM_L2 PERSON_CTRY_CODE TYPE DEGREE note AB US 1 6 it is the largest number of 'AB 1' group CC US 2   I expect to keep both of them even they are the missing value CC GB 2     DF CA 4 2 I expect to keep all of them if the largest number of DEGREE of this group are the same DF GB 4 2   DF DE 4 2   Could you please give me some suggestion about this? thanks in advance. ... View more

pick up the top 40% company of each CTRY group

by Pyrite | Level 9 in SAS Programming
‎10-09-2019 08:22 PM
‎10-09-2019 08:22 PM
Hello,   I would like to pick up the top 40% innovative company of each 'PERSON_CTRY_CODE'.   By using the example,   1. If the data obtained has a decimal point, then add one. For example, the AD country includes 14 companies, so the top40% is 5.6 companies. in this case, I would like to includes 6 companies rather than 5. 2. For ZA country, which includes 10 companies. The 4th company has 8116 innovations which is as same as the number of innovation as the 5th company. so I expect to obtain both of them. 3. I expect to have a Flag for picked company.   the result is expected to look like following. PERSON_CTRY_CODE company sum_innovation Seq Top40% Flag_Top40 note AD L'OREAL 7925 1   1   AD VOLKSWAGEN 4909 2   1   AD BAKER HUGHES 4546 3   1   AD ABB (ASEA BROWN BOVERI) 2822 4   1   AD CARL FREUDENBERG 1481 5   1   AD ASTRA 587 6   0   AD GRUENENTHAL 435 7   0   AD KOLON INDUSTRIES 305 8   0   AD BRITISH AMERICAN TOBACCO (INVESTMENTS) 233 9   0   AD EVONIK ROEHM 221 10   0   AD SEIKAGAKU CORPORATION 106 11   0   AD BAYER ANIMAL HEALTH 23 12   0   AD M-U-T MASCHINEN-UMWELTTECHNIK-TRANSPORTANLAGEN 15 13   0   AD CONTROLLED THERAPEUTICS (SCOTLAND) 6 14 5.6 0 5.6=14*0.4, I would like to have 6 rather than 5 ZA IBM (INTERNATIONAL BUSINESS MACHINES CORPORATION) 143820 1   1   ZA SIEMENS 34929 2   1   ZA TELEFONAKTIEBOLAGET LM ERICSSON (PUBL) 14629 3   1   ZA 3M COMPANY (MINNESOTA MINING AND MANUFACTURING COMPANY) 8116 4   1   ZA BAYER 8116 5   1 I would like to keep both of them if the 5th company has the same number of sum_innovation as the 4 th company. ZA YAZAKI CORPORATION 5307 6   0   ZA ROHM & HAAS COMPANY 3816 7   0   ZA UNILEVER 3380 8   0   ZA L'AIR LIQUIDE SOCIETE ANONYME POUR L'ETUDE ET L'EXPLOITATION DES PROCEDES GEORGES CLAUDE 2403 9   0   ZA COLGATE-PALMOLIVE COMPANY 1934 10 4 0     Could you please give me some suggestion about this? Thanks in advance. ... View more

How to put both single quotes (') and double quote (") into the same P...

by Pyrite | Level 9 in SAS Programming
‎10-09-2019 01:17 PM
‎10-09-2019 01:17 PM
Hello,   How to put both single quotes (') and double quote (") into the same PRXCHANGE function? I would like to change the company suffix ' LTD LIABILITY CO' to 'LLC' if it is not partioned by the following puncations which are () [] {} ' "  However, it seems that I cannot put the single and double quotes in the same PRXCHANGE function. Could you please give me some suggestion about this?   data have; input string :$200.; infile datalines ; name_S25=prxchange('s/([^\w^\d])LTD[^\w^\d^\{^\}^\[^\]^\(^\)^\'^\"]+LIABILITY[^\w^\d^\{^\}^\[^\]^\(^\)^\'^\"]+CO([^\w^\d])/$1 LLC $2/',-1,cat(strip(compbl(name)),' ')); datalines; APPLE LTD., LIABILITY CO 'APPLE LTD' LIABILITY CO "APPLE LTD" LIABILITY CO APPLE LTD (LIABILITY CO) APPLE LTD [LIABILITY CO] {APPLE LTD} LIABILITY CO ; run; I expect to get  name  new_name   APPLE LTD., LIABILITY CO  APPLE LLC  changed 'APPLE LTD' LIABILITY CO  'APPLE LTD' LIABILITY CO  no change APPLE LTD LIABILITY CO  APPLE LTD LIABILITY CO  no change APPLE LTD (LIABILITY CO)  APPLE LTD (LIABILITY CO)  no change APPLE LTD [LIABILITY CO]  APPLE LTD [LIABILITY CO]  no change ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎08-30-2023 04:29 AM
Likes given to
Likes from
View All
Quick links